Updating database in asp bestdatingorg
The Selected Value property should reflect the current value at that moment.
I'm not sure why you aren't seeing your currently selected value in the update.
collection and can include hard-coded values, common parameter source values (querystring fields, session variables, Web control values, and so on), or can be programmatically assigned.
When the Sql Data Source control s method is invoked either programmatically or automatically from a data Web control a connection to the database is established, the parameter values are assigned to the query, and the command is shuttled off to the database.
NET, and now getting into the depths of database interaction!
This is probabaly a really easy solution, but i want a simple example of how to update a field in database?
The results are then returned as either a Data Set or Data Reader, depending on the value of the control s value has been specified, the Enable Inserting, Enable Editing, or Enable Deleting option in the corresponding data Web control s smart tag will become available.
From the Designer in Sql Data Source and then bring up the Properties window (from the View menu, choose Properties window, or simply hit F4).
Select the Delete Query property, which will bring up a set of ellipses.
Figure 2: Select the Delete Query Property from the Properties Window provide a value for this parameter (leave its Parameter source at None ).
Alternatively, the Sql Data Source can be used in place of the Object Data Source.
Recall that to support inserting, updating, and deleting, with the Object Data Source we needed to specify the object layer methods to invoke to perform the insert, update, or delete action.