How to perform Edit,Delete operation in Grid view using Asp.net 2.0 in visual studio 2005?

Question

hi, How to perform Edit,Delete operation in Grid view using Asp.net 2.0 in visual studio 2005?

Purushottam Rathore · Answer

http://www.c-sharpcorner.com/UploadFile/raj1979/GridViewExample11232008075052AM/GridViewExample.aspx

Kirtan Patel · Answer

Friend, Here is Simplest Way to Do that Without Writing Single Line of Code :) . if you are Beginner then this will be help full to you . friend, if my answer helps you then please check "Do you like this answer check box" :) Bind Your Database table With GridView by Click On SmartTag which is on the Right Top Corner of the GridView then Select the DataSource From there . Now In Grid Step 1 (Click On Samrt Tag As Show Below ) Step 2 While Selecting the DataSource Click On Advance Sql Option button and Check Generate Insert Update Delete Check box Step 3 Now In SmartTag You Will Have New Options Enable Editing and Delete .Check Them Both Step 4 you are Done!! Now your Grid Allow you to Update and delete the DataRows :)

keshav singh · Answer

http://www.aspdotnetcodes.com/GridView_Insert_Edit_Update_Delete.aspx this will help you please mark it as Accepted

Amit Choudhary · Answer

Hi, Here is the instructions for you problem.... Implementing a Delete, Insert and Update operations you must have a DataAdapter and define its Delete, Insert and Update commands. You could use this adapter against your datasource and call the adapters' update method... SqlDataAdapter adapter = new SqlDataAdapter("SELECT * FROM table1", conn); adapter.InsertCommand = new SqlCommand("INSERT INTO table1 VALUES(@param1, @param2)", conn); adapter.InsertCommand.Parameters.Add("@param1",...); Just do the same to the Update and Delete commands. Then, Create a DataSet and Fill it using the adapter and make it as a datasource of your datagrid... DataSet ds = new DataSet(); adapter.Fill(ds); DataGrid1.DataSource = ds; When you want to send your changes to the database you can just call the adapter.update method... adapter.Update(ds); ======================================== if it helps you mark it as answer..please it'll help me getting some points :)

How to perform Edit,Delete operation in Grid view using Asp.net 2.0 in visual studio 2005?

Answers (4)