Hi, I'm trying to do the relationship between two tables, but I realized that I have to add (or change) a column name, how can I modify a table once it has been saved and realted to others.

You can edit a table by right-clicking it in the Database Explorer / Solution Explorer in Visual Studio.

Cheers,

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!

but wait... I can't add or modify the columns. I just can change the column information but not the header of the column or add another column

Are you really editing the table, not merely opening it? Which command do you choose from the context menu?

If I am not mistaken, you can't edit remote tables using VWD. If your SQL Server is not a local one, you need to install SQL Server Management Studio, of which the Express Edition is a free download from the Microsoft site.

Cheers.

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!