Web Technologies

While using GridView in asp.net pages wants to confirm the deletion form user. To do this we can take him to another page having GUI to confirm and then delete the record on that page.

Instead of doing so much hardwork you can achieve this on the same page with a little bit of extra code.

Workaround

Add a client alert script to the delete button of every row.
In the delete event of GridView delete the record.

Code

==================================================
Page’s Aspx Design File Begins
==================================================
<asp:GridView ID=”gvFaq” runat=”server” AutoGenerateColumns=”False” CellPadding=”4″
ForeColor=”#333333″ GridLines=”None” OnRowDataBound=”gvFaq_RowDataBound” OnRowDeleting=”gvFaq_RowDeleting”>
<footerstyle backcolor=”#5D7B9D” bold=”True” forecolor=”White”>
<rowstyle backcolor=”#F7F6F3″ forecolor=”#333333″>
<columns>
<asp:boundfield datafield=”slno” headertext=”Sl">
<asp:boundfield datafield=”cHeading” headertext=”Question”>
<asp:boundfield datafield=”cPosition” headertext=”Position”>
<asp:commandfield headertext=”Manage” showselectbutton=”True”>
<asp:commandfield headertext=”Delete” showdeletebutton=”True”>
</columns>
<pagerstyle backcolor=”#284775″ forecolor=”White” horizontalalign=”Center”>
<selectedrowstyle backcolor=”#E2DED6″ bold=”True” forecolor=”#333333″>
<headerstyle backcolor=”#5D7B9D” bold=”True” forecolor=”White”>
<editrowstyle backcolor=”#999999″>
<alternatingrowstyle backcolor=”White” forecolor=”#284775″>
</asp:GridView>
==================================================
Page’s Aspx Design File Ends
==================================================

==================================================
Code Behind File Begins
==================================================
1) Import Namespaces
using System.Data.SqlClient;

2) Declare global variables which will be used in page
DataSet ds = new DataSet();
SqlDataAdapter da;
SqlConnection myConnection;
String connStr = “your database connection string goes here”‘;
String sql = string.Empty;

3) Page Load event
protected void Page_Load(object sender, EventArgs e)
{
if (Page.IsPostBack == false)
{
fillGridView();
}
}

4) GridView filling method
private void fillGridView()
{

try
{
myConnection = new SqlConnection(connStr);
sql = “select * from tblFaq order by slno desc”;

da = new SqlDataAdapter(sql, myConnection);
ds.Clear();
da.Fill(ds, “tblFaq”);

gvFaq.DataSource = ds.Tables[0];
Page.DataBind();

}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}

5) In the RowDataBound event add a java script event to the delete cell.
protected void gvFaq_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
e.Row.Cells[4].Attributes.Add(”onClick”, “return confirm(’Are you sure you want to delete the record?’);”);
}
}

6) Handle the RowDeleting event to delete the record of current row.

protected void gvFaq_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
try
{
myConnection = new SqlConnection(connStr);
myConnection.Open();
sql = “delete from tblFaq where slno = ” + Convert.ToInt32(gvFaq.Rows[e.RowIndex].Cells[0].Text);
SqlCommand oldcom = new SqlCommand(sql, myConnection);
oldcom.ExecuteNonQuery();
myConnection.Close();
fillGridView();
Response.Write(”Record Deleted”);
}
catch (Exception ex)
{
lblError.Text = ex.Message;
}
}

Labels: ASP.Net, Gridview Delete, JavaScript