When I update a record, I can change the [Name] of the activity (because it's a default textbox generated by the Grid View), and the record is updated fine.But the value of the ddl box is not inserted into the record.Now you have to specify which database the Sql Data Source control will get data from. Click Next two times, leaving the default connection String name.At the end of this wizard, a “connection Strings” element will be added to your Web.config file. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. By joining today you can post your own programming questions, respond to other developers questions, and eliminate the ads that are displayed to guests. The [Category] field is populated by a dropdown list box that gets the categories from another table (and it works fine).
To start with, open VS2012 and create an empty ASP. Then select “database” leaving the default name for datasource’s ID and click OK.For example ‘@Parameter’, will be sent in the update to the record instead of null.