Solved

update database with changes made in gridview in button click

Posted on 2011-03-10
6
510 Views
Last Modified: 2012-05-11
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
0
Comment
Question by:CPSRI
  • 3
  • 3
6 Comments
 
LVL 53

Expert Comment

by:Dhaest
Comment Utility
Did you try to use the update-method of your dataadapter ?

this.your_dataAdapter_name.Update(your_dataset_rhat_fill_the_datagrid);

0
 

Author Comment

by:CPSRI
Comment Utility
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.  
0
 

Author Comment

by:CPSRI
Comment Utility
is there any way Dhaest?
0
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 
LVL 53

Expert Comment

by:Dhaest
Comment Utility
Insert Update Edit Delete record in GridView using SqlDataSource ASP.NET

http://csharpdotnetfreak.blogspot.com/2009/05/gridview-sqldatasource-insert-edit.html
0
 
LVL 53

Accepted Solution

by:
Dhaest earned 500 total points
Comment Utility
Or do you want to write your  own update-query, take a look at the sqlCommand-object
http://www.csharp-station.com/Tutorials/AdoDotNet/Lesson03.aspx
0
 

Author Closing Comment

by:CPSRI
Comment Utility
thank u so much
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Lots of people ask this question on how to extend the “MembershipProvider” to make use of custom authentication like using existing database or make use of some other way of authentication. Many blogs show you how to extend the membership provider c…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now