I created a new database (tried both in 2005 and in SQL 2000) and then
created a SqlDataSource control in an asp.net application. Clicked on the
smart tag and whose configure data source. When I click Advanced should see
the Generate Insert, Update and Delete statements check box but it is grayed
out. Any idea what might cause this?
I can work around with this code, which does work:
SqlDataSource1. InsertCommand = "Insert into myTable Values (...)"
SqlDataSource1. InsertCommandTy pe = SqlDataSourceCo mmandType.Text
SqlDataSource1. Insert()