how we can delete the particular row in the grid view. We will add the link button in the grid view and we will create the click event of the link button.
Sql Server (Data Base):-
Sql Server (Data Base):-
Script the creation of table:-
USE [CodeSolution]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[reg](
[id] [int] IDENTITY(1,1) NOT NULL,
[Name] [nvarchar](50) NULL,
[Gender] [nvarchar](50) NULL,
[Email] [nvarchar](50) NULL,
CONSTRAINT [PK_reg] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE =OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
Source Code:-
<%@ Page Language="C#" AutoEventWireup="true"CodeFile="deleteingridview.aspx.cs" Inherits="deleteingridview" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>delete button inside the grid view</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="gvdetails" runat="server"AutoGenerateColumns="False" CellPadding="4"
DataKeyNames="ID" Width="560px" GridLines="None"Font-Names="Times New Roman"
ForeColor="#333333" RowStyle-HorizontalAlign="Center">
<AlternatingRowStyle BackColor="White" />
<Columns>
<asp:BoundField DataField="name" HeaderText="Name"SortExpression="Name" ItemStyle-Width="90px" />
<asp:BoundField DataField="Gender"HeaderText="Gender" SortExpression="Gender"
ItemStyle-Width="90px" />
<asp:BoundField DataField="Email" HeaderText="Email"SortExpression="Email"
ItemStyle-Width="90px" />
<asp:TemplateField HeaderText="Delete">
<ItemTemplate>
<asp:LinkButton ID="lnkdelete" runat="server"OnClick="lnkdelete_Click" Text="Delete"></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<EditRowStyle BackColor="#7C6F57" />
<FooterStyle BackColor="#1C5E55" ForeColor="White"Font-Bold="True" />
<HeaderStyle BackColor="#1C5E55" Font-Bold="True"ForeColor="White" />
<PagerStyle ForeColor="White" HorizontalAlign="Center"BackColor="#666666" />
<RowStyle BackColor="#E3EAEB" />
<SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />
<SortedAscendingCellStyle BackColor="#F8FAFA" />
<SortedAscendingHeaderStyle BackColor="#246B61" />
<SortedDescendingCellStyle BackColor="#D4DFE1" />
<SortedDescendingHeaderStyle BackColor="#15524A" />
</asp:GridView>
</div>
</form>
</body>
</html>
Code behind(c#):-
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
public partial class deleteingridview : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
BindUserDetails();
}
protected void lnkdelete_Click(object sender, EventArgs e)
{
LinkButton lnkbtndel = sender as LinkButton;
GridViewRow gdrow = lnkbtndel.NamingContainer asGridViewRow;
int fileid =Convert.ToInt32(gvdetails.DataKeys[gdrow.RowIndex].Value.ToString());
using (SqlConnection con = new SqlConnection("Data Source=NEERAJ-PC;Initial Catalog=CodeSolution;Persist Security Info=True;User ID=sa; password=12345678"))
{
using (SqlCommand cmd = new SqlCommand("", con))
{
cmd.CommandText = "delete from reg where id=@id";
cmd.Parameters.AddWithValue("@id", fileid);
cmd.Connection = con;
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
DataTable dataTable = new DataTable();
dataTable.Load(dr);
gvdetails.DataSource = dataTable;
gvdetails.DataBind();
Response.Write("<script>alert('Record successfully delete')</script>");
BindUserDetails();
}
}
}
protected void BindUserDetails()
{
SqlConnection con = new SqlConnection("Data Source=NEERAJ-PC;Initial Catalog=CodeSolution;Persist Security Info=True;User ID=sa; password=12345678");
SqlCommand cmd = new SqlCommand(("select * from reg"), con);
con.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
con.Close();
if (ds.Tables[0].Rows.Count > 0)
{
gvdetails.DataSource = ds;
gvdetails.DataBind();
}
else
{
ds.Tables[0].Rows.Add(ds.Tables[0].NewRow());
gvdetails.DataSource = ds;
gvdetails.DataBind();
int columncount = gvdetails.Rows[0].Cells.Count;
gvdetails.Rows[0].Cells.Clear();
gvdetails.Rows[0].Cells.Add(new TableCell());
gvdetails.Rows[0].Cells[0].ColumnSpan = columncount;
gvdetails.Rows[0].Cells[0].Text = "No Records Found";
}
}
}
0 comments:
Post a Comment