code to edit data in grid view of the form and to store the changes into the database via button

Check out this data grid sample for web based applications (ASP.NET):

http://asp.net/learn/videos/video-08.aspx

and this one for GridView and FromView (both assume you are using ASP.NET 2.0 which is the current version (.NET Framework 2.0 is a free download and you'll need either Visual Web Developer Express or Visual Studio 2005 to work with ASP.NET code)

http://asp.net/learn/videos/video-07.aspx

Or this sample for Windows forms applications:

http://msdn.microsoft.com/vstudio/tour/vs2005_guided_tour/VS2005pro/Smart_Client/WindowsFormsOverview.htm

Navigate to the "Data Centric Applications" section

Jason

JasonMcConnellMSFT at 2007-10-2 >