Link to home
Start Free TrialLog in
Avatar of CPSRI
CPSRIFlag for United States of America

asked on

update database with changes made in gridview in button click

Hi,
I have a gridview in my asp.net page, in button click event i want to update the database with the changes made in the gridview. I dont want to use gridview's auto edit and update features. Please help me. I attached the snap shot of my gridview I will do change in the dropdown list with in the girdview, ill do the changes wherever needed and i want to update the database according to changes done in gridview. or if its ok/good i want to update the row by clicking on the update button within the row as shown in the gridview. help me in doing this.
thanks in advance
gridview.JPG
Avatar of Dirk Haest
Dirk Haest
Flag of Belgium image

Did you try to use the update-method of your dataadapter ?

this.your_dataAdapter_name.Update(your_dataset_rhat_fill_the_datagrid);

Avatar of CPSRI

ASKER

Thank you Dhaest, for your reply , i dont have data adapter because i am using Sql data source. If there is a way to use dataadapter when we are working with sqldatasource, Please let me now.  
Avatar of CPSRI

ASKER

is there any way Dhaest?
Insert Update Edit Delete record in GridView using SqlDataSource ASP.NET

http://csharpdotnetfreak.blogspot.com/2009/05/gridview-sqldatasource-insert-edit.html
ASKER CERTIFIED SOLUTION
Avatar of Dirk Haest
Dirk Haest
Flag of Belgium image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of CPSRI

ASKER

thank u so much