how to delete a a prticular row in datagrid using asp.net

Question

how to delete a a prticular row in datagrid using asp.net .please the code to delte the row in data grid .

Satyapriya Nayak · Answer

Create table student (sid varchar(50)sname varchar(50)) Untitled Page ' CommandName=Delete runat=server>Delete using System; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; public partial class _Default : System.Web.UI.Page { string connStr = ConfigurationManager.ConnectionStrings[ConnectionString].ConnectionString; SqlCommand cmd = new SqlCommand(); SqlConnection con; protected void Page_Load(object sender EventArgs e) { if (!Page.IsPostBack) { BindGrid(); } } private void BindGrid() { con = new SqlConnection(connStr); cmd.Connection = con; cmd.CommandText = Select * from student; con.Open(); GridView1.DataSource = cmd.ExecuteReader(); GridView1.DataBind(); con.Close(); } protected void GridView1_RowDataBound(object sender GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { LinkButton l = (LinkButton)e.Row.FindControl(LinkButton1); l.Attributes.Add(onclick javascript:return  + confirm('Are you sure you want to delete this record::  + DataBinder.Eval(e.Row.DataItem sid) + ')); } } protected void GridView1_RowDeleting(object sender GridViewDeleteEventArgs e) { string sid = (string)GridView1.DataKeys[e.RowIndex].Value; SqlConnection con = new SqlConnection(connStr); cmd.Connection = con; cmd.CommandText = DELETE FROM student WHERE sid=' + sid + '; con.Open(); cmd.ExecuteNonQuery(); con.Close(); BindGrid(); } }

Lakshmanan Sethu · Answer

Hi Please Post your data grid code here.

selvi subramanian · Answer

me asked in datagrid

Abhay Shanker · Answer

Can check below link also http://csharpexample.com/CsharpExampleSeeDetail.aspx?Did=10&CatID=21 http://www.dotnetgallery.com/kb/resource10-How-to-perform-insert-update-delete-and-select-rows-in-ASPNET-gridview-c.aspx

selvi subramanian · Answer

its not working please check the eror Server Error in '/Riyaz Asp' Application. Compilation Error Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately. Compiler Error Message: CS1061: 'System.Web.UI.WebControls.DataGridCommandEventArgs' does not contain a definition for 'RowIndex' and no extension method 'RowIndex' accepting a first argument of type 'System.Web.UI.WebControls.DataGridCommandEventArgs' could be found (are you missing a using directive or an assembly reference?) Source Error: Line 91: { Line 92: Line 93: int index = Convert.ToInt32(e.RowIndex); Line 94: DataTable dt = ViewState[dt] as DataTable; Line 95: dt.Rows[index].Delete(); Source File: d:\Riyaz Asp\Master\Section.aspx.cs Line: 93 Show Detailed Compiler Output: Show Complete Compilation Source: Version Information: Microsoft .NET Framework Version:2.0.50727.4984; ASP.NET Version:2.0.50727.4971

Lakshmanan Sethu · Answer

Hi Selvi Pls refer this http://www.aspsnippets.com/Articles/ASPNet-GridView---Delete-Row-with-Confirmation.aspx