Sqldatasource onupdating cancel update christian mingle dating websites
Hey, I've been working a gridview that uses an Object Data Source to perform either select, insert, delete or update.
Environment: VS2005, C#, SQLServer 2005 Error Message: Object Must Implement IConvertible I'm using a Form View whose Data Source ID = Sql Data Source1 Sql Data Source1 has an update command whose WHERE clause references an GUID column in the underlying table,ie, WHERE Addr GUID = @Addr GUID Addr GUID is the primary key on the table and the Form View Data Key Names=Addr GUID.
When the Edit Item Template is showing the fields to update and I click the Submit button, I get the Object "Must Implement IConvertible" error.
-- Thank you kindly, Dan Sikorsky BA, BSCE, MCS Just solved it.
The Grid View, Form View must use strings for the GUIDs, so the Sql Data Source must convert the guids to strings.
You might want to look into the other types of parameters as well.
Of course it depends on your usage/requirements but I like the Control Parameters as they hook up to a page control such as a dropdown and automatically grab its value - great for user input based queries.So the problem I am having is that when I get the Datakey value I am trying to get the values in the controls in the Edit Mode of the current row I am trying to update. I am using the Find Control function to get the values from the editing row so I specifically name the dropdownlists and textboxes so I can access them here.But what happens is that I do get some of the values but they are the original values not the new ones being changed.It still gets the old values, when I loop thru the Dictionary and in debug step thru it I see it still gets the original values not the new values that the user enters when they are changing each item.// Iterate through the New Values collection and HTML encode all // user-provided values before updating the data source. New Values) guru_sami, sorry it took me so long to get back, I have been off on vacation and just got back, but yes you are right on, I went back and debugged the entire postback and it was rebinding the grid on postback on the page_load event. In the code below I do get the Country ID and Region ID but they are the original values not the new ones selectedfrom the Edit Mode row.Tags: Adult Dating, affair dating, sex dating