VWDExpress SQL Config Problem

[Evie]

Hi!

I apologize but I tried to search for this and nothing showed up.

I have a remote db on GoDaddy that I have configured to allow remote connection so I can develop. It has ASP Schema and DSN installed.

I am using Visual Web Developer Express. The server is IIS8 and does not use FPExtensions so I am xferring files via Filezilla

I have set up several tables.

I have put a SqlDataSource on a page and I can get a SELECT statement to go, but in the Advanced window, the option to generate INSERT, UPDATE and DELETE queries is not available for selection. I need this, the whole point of creating the site/db is to enter data and display it.

Thanks in advance.

[ryanbutler]

Then create it yourself:

<asp:SqlDataSource id="myDS" runat="server"
SelectCommand="SELECT * FROM Table
InsertCommand=INSERT INTO Table(field, field2) VALUES (@field, @field2)
DeleteCommand=DELETE FROM Table WHERE field=@ID
UpdateCommand=UPDATE Table SET field=@field, field2=@field2">

[Evie]

Cool, thanks :)