Gridview Row deleting

Question

Hai

i doing project in c#2008 web application, i having gridview colums contain Groupname,First name,Lastname....like that.
i want to delete perticular row in grid view. please give me only c# coding to delete row,don't want asp coding..pls urgent...
i need only c# coding please......

Abhimanyu K Vatsa · Answer

@ Page Language =VB %> DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd> script runat =server> script > html xmlns =http://www.w3.org/1999/xhtml> head runat =server> title > title > head > body > form id =form1 runat =server> div > asp : GridView ID =GridView1 runat =server AutoGenerateColumns =False DataSourceID =SqlDataSource1 EmptyDataText =There are no data records to display. Width =788px DataKeyNames =ID> Columns > asp : BoundField DataField =ID HeaderText =ID SortExpression =ID /> asp : BoundField DataField =NAME HeaderText =NAME SortExpression =NAME /> asp : BoundField DataField =ADDRESS HeaderText =ADDRESS SortExpression =ADDRESS /> asp : BoundField DataField =MOBILE HeaderText =MOBILE SortExpression =MOBILE /> asp : CommandField ButtonType =Image ShowEditButton =true EditText =Edit Movie EditImageUrl =~/images/edit.GIF UpdateText =Update Movie updateimageurl =~/images/update.GIF ShowCancelButton =true CancelText =Cancel Edit cancelimageurl =~/images/cancel.GIF ShowDeleteButton =true DeleteText =Delete Movie Deleteimageurl =~/images/delete.GIF/> Columns > asp : GridView > asp : SqlDataSource ID =SqlDataSource1 runat =server ConnectionString = $ ConnectionStrings:DatabaseConnectionString1 %>  DeleteCommand =DELETE FROM MYTB WHERE ID=@ID ProviderName = $ ConnectionStrings:DatabaseConnectionString1.ProviderName %>  SelectCommand =SELECT [ID] [NAME] [ADDRESS] [MOBILE] FROM [MYTB] UpdateCommand =UPDATE MYTB SET ID =@ID NAME =@NAME ADDRESS =@ADDRESS MOBILE =@MOBILE WHERE ID=@ID> asp : SqlDataSource > div > form > body > html > For more Read this http://www.vbdotnetheaven.com/UploadFile/abhikumarvatsa/2249/

Ankit Nandekar · Answer

Follow this simple steps 1. on Gridview do AutoGenerateColumns=False. 2.use TemplateField and itemtemplate to show ur data . 3.do in gridview which look like AutoGenerateColumns=False onrowdeleting=gvDeleteUsers_RowDeleting BackColor=White BorderColor=#CC9966 BorderStyle=None BorderWidth=1px CellPadding=4> VerticalAlign=Middle /> ' Visible=false> '> HorizontalAlign=Center VerticalAlign=Middle /> Here UserId UserName is table field name if u dont want to show Userid then do it as visible false or if u want then use one more templete field to show id which is unqiue which will help us to delete perticular record. 4. Now genrate gridview's onrowdeleting event by going its property click on events u can see onrowdeleting events is ther double click on it. 5.write following code on it protected void gvDeleteUsers_RowDeleting(object sender GridViewDeleteEventArgs e) { Label lblUserId = (Label)gvDeleteUsers.Rows[e.RowIndex].Cells[0].FindControl(lblUserId); SqlConnection con = new SqlConnection(Data Source=C3;Initial Catalog=PhotoGallary;Persist Security Info=True;User ID=sa;Password=p@ssw0rd); SqlCommand cmd = new SqlCommand(DELETE FROM Registration_Table WHERE UserId= + Convert.ToInt32(lblUserId.Text)con); con.Open(); cmd.ExecuteNonQuery(); con.Close(); ShowData(); } public void ShowData() { write code to bind database with gridview......... } Note: Add Namespace using System.Data.SqlClient

Dinesh Beniwal · Answer

See this article http://www.c-sharpcorner.com/UploadFile/jayendra/108142009005216AM/1.aspx