In that case, is there a way to change the initial set up for this? I have Details View that automatically selects data from a datasource.
) - Next project I will follow everyone's suggestion :) Thanks all Using the Default Value property passes this value to the query. I tried that before (see my commented-out code above) but I tried it again: //Update Order Table with Total of Order Sql Data Source2.
And yes, this is the last time I will be using Sql Data Source - It seems everyone recommends a different approach (DAC?
But, given what I learned yesterday about how I should Insert/Delete into the events?
I looked at this, but it doesn't really get at what I'm trying to do.
events before it executes the SQL statement for the corresponding command property.
The following code example demonstrates how to display and update data retrieved from an ODBC database in a Grid View control.
The statement can include parameters if the data source supports them.
Parameters are used to send values for insert, update, and delete operations to the data source.
After a record is successfully updated, the Updated event is handled by an event handler to perform a post-processing step where an e-mail message notification is sent.