Table Developer Greyed Out

chalomwimba · January 18th, 2018, 07:23 PM

I need help urgently. I am working in Visual Studio 2015 going through Imar's BEGINNING ASP.NET 3.5 IN C# AND VB (Chapter 13). I have shown Table Developer icons from Toolbars. When I add new Tables in Server Explorer and want to create RELATIONSHIPS, TABLE DESIGNER is not activated, it is still greyed out. What can I do?

Imar · January 19th, 2018, 08:47 AM

Hi there,

Can you be a bit more specific about the exercise and steps you're on? ASP.NET targets Visual Studio 2008 so I am pretty sure some stuff will be quite different.

Cheers,

Imar

chalomwimba · January 19th, 2018, 06:28 PM

Thanks Imar,
I am on page 444, Try It Out - A SIMPLE LINQDATASOURCE APPLICATION. I can create the two tables PhotoAlbum and Picture but I cannot establish the relationship because Table Designer is greyed out. Even If I connect to another SQL database and create tables, the Table Designer cannot be available, still greyed out.
Kindly help.
Thank
Chalo

Quote:

Originally Posted by Imar

Hi there,

Can you be a bit more specific about the exercise and steps you're on? ASP.NET targets Visual Studio 2008 so I am pretty sure some stuff will be quite different.

Cheers,

Imar

Imar · January 22nd, 2018, 04:45 AM

Looks like what you're running into is documented here: https://social.msdn.microsoft.com/Fo...ner?forum=ssdt

The table designer is now legacy and works with old versions of SQL Server only. My recommendation would be to use SQL Server Management Studio (also discussed in the book) for all schema and data manipulation. That's what I switched to in later versions of my book.

Hope this helps,

Imar

chalomwimba · January 22nd, 2018, 09:32 PM

Hi Imar, Now on a different one about an exercise in your book BEGINNING ASP.NET 3.5

I am doing Try It Out Exercise pg 451. Once done it throws an error as
Server Error in '/' Application.
Index (zero based) must be greater than or equal to zero and less than the size of the argument list.
Error is in line 7 Response.Redirect(String.Format("ManagePhotoAlbum. aspx?PhotoAlbumId={0}"), myPhotoAlbum.ID.ToString())

MANY THANKS

Imar · January 23rd, 2018, 03:42 AM

You're closing the call to String.Format too early. In other words,

this:

Code:

Response.Redirect(String.Format("ManagePhotoAlbum.aspx?PhotoAlbumId={0}"), myPhotoAlbum.ID.ToString())

should be this:

Code:

Response.Redirect(String.Format("ManagePhotoAlbum.aspx?PhotoAlbumId={0}", myPhotoAlbum.ID.ToString()))

Please don't send me your forum posts to my private email also. I am following the posts on this forum, so when I see one come in, I'll reply to it when I have the time.

Cheers,

Imar

chalomwimba · January 23rd, 2018, 07:02 PM

Quote:

Originally Posted by Imar

You're closing the call to String.Format too early. In other words,

this:

Code:

Response.Redirect(String.Format("ManagePhotoAlbum.aspx?PhotoAlbumId={0}"), myPhotoAlbum.ID.ToString())

should be this:

Code:

Response.Redirect(String.Format("ManagePhotoAlbum.aspx?PhotoAlbumId={0}", myPhotoAlbum.ID.ToString()))

Please don't send me your forum posts to my private email also. I am following the posts on this forum, so when I see one come in, I'll reply to it when I have the time.

Cheers,

Imar

Imar, Thanks a million. Your code is excellent and it worked. Sorry about sending to Private email, comments noted.
Cheers
Chalomwimba