In this tutorial we will learn how to perform the deletion of records in asp.net using C#. First of all we will show all records coming from database in gridview and then using gridview’s built-in event RowDeleting we will perform deletion of records in asp.bet using C#. To perform deletion of records in aso.net using C# is quite easy.
<Columns>
<asp:TemplateField HeaderText="ID" >
<ItemTemplate>
<asp:Label ID="lbl_UserID" Text='<%# Bind("User_ID")%>' runat="server"></asp:Label>
</ItemTemplate>
<ItemStyle Font-Size="15px" />
</asp:TemplateField>
<asp:TemplateField HeaderText="Email" >
<ItemTemplate>
<asp:Label ID="lbl_Email" Text='<%# Bind("User_Email")%>' runat="server"></asp:Label>
</ItemTemplate>
<ItemStyle Font-Size="15px" />
</asp:TemplateField>
<asp:TemplateField HeaderText="First Name" >
<ItemTemplate>
<asp:Label ID="lbl_first_name" Text='<%# Bind("User_First_Name")%>' runat="server"></asp:Label>
</ItemTemplate>
<ItemStyle Font-Size="15px" />
</asp:TemplateField>
<asp:TemplateField HeaderText="Last Name" >
<ItemTemplate>
<asp:Label ID="lbl_last_name" CssClass="aLinkButton" Text='<%# Bind("User_Last_Name")%>' runat="server"></asp:Label>
</ItemTemplate>
<ItemStyle Font-Size="15px" />
</asp:TemplateField>
<asp:TemplateField HeaderText="Delete" >
<ItemTemplate>
<asp:Label ID="lbl_delete" Visible="false" Text='<%# Bind("User_ID")%>' runat="server"></asp:Label>
<asp:ImageButton runat="server" ID="img" ImageUrl="images/b_drop.png" CommandName="Delete" />
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:gridview>
deleting_records_in_gridview.aspx.cs
using System.Data;
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.Data.SqlClient;
public partial class Tutorials_deleting_data_in_gridview : System.Web.UI.Page
{
string strcon = "server=localhost;database=tutorials-db; uid=adeel;password=pakistan; Connect Timeout=200; Max Pool Size=5000";
SqlConnection con = new SqlConnection();
SqlCommand com = new SqlCommand();
DataSet ds = new DataSet();
SqlDataAdapter da;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
bindgrid();
}
}
private void bindgrid()
{
ds.Clear();
con.ConnectionString = strcon;
com.Connection = con;
con.Open();
string strQuery = "select * from users";
da = new SqlDataAdapter(strQuery,con);
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
con.Close();
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
com.Connection=con;
con.Open();
int index = e.RowIndex;
GridViewRow row=GridView1.Rows[index];
Label lbl = (Label)row.FindControl("lbl_delete");
string id = lbl.Text;
string strDelete = "delete from users where User_ID='"+id+"'";
com.CommandText = strDelete;
com.ExecuteNonQuery();
con.Close();
bindgrid();
//Deleting records function ends here
}
