Click to See Complete Forum and Search --> : Update database with SqlDatasource control


fozail
10-12-2009, 09:46 PM
Hey Guys, Does somone know how can I update a field in the database using SqlDatasource control. I can retrieve the data successfull with the following line:

DataView returnedDataView = (DataView)Pages.Select(DataSourceSelectArguments.Empty);
elm1.Content = returnedDataView[0][5].ToString();

I'm trying this to update but it does not work.

Pages.UpdateParameters["html"].DefaultValue = elm1.Content;

Pages.Update();

Please advise. Thanks!