How to delete rows from DataGrid in ASP.NET ?

Hi . I have an employee table with fields Employee Id, Employee Name, Address,Salary , Department ID and department table with fields DeptID,DeptName.
I have added a data grid control with the columns showing Empname , address , salary,DeptName and Edit and Delete columns .
I have inserted image using template columns in the Edit and Delete column .
By clicking on the image in delete column , it should delete that particular row from the datagrid and from database and on refreshing the grid the changes should be shown in the datagrid .
I have written the following code :

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Configuration;

using System.Data.SqlClient;

using System.Data;

public partial class Default2 : System.Web.UI.Page

protected void Page_Load(object sender, EventArgs e)

{

if (!Page.IsPostBack)

{

FillDataGrid();

}

public void FillDataGrid()

{

String strConnString = ConfigurationManager.ConnectionStrings["Company"].ConnectionString;

SqlConnection con = new SqlConnection(strConnString);

SqlCommand cmd = new SqlCommand();

cmd.CommandType = CommandType.StoredProcedure;

cmd.CommandText = "proc_Getallempdetails";

cmd.Connection = con;

try

{

con.Open();

DataGrid1.DataSource = cmd.ExecuteReader();

DataGrid1.DataBind(); }

catch (Exception ex)

{

throw ex;

}

finally

{

con.Close();

con.Dispose();

}

protected void DataGrid1_DeleteCommand(object source, DataGridCommandEventArgs e)

{ String strConnString = ConfigurationManager.ConnectionStrings["Company"].ConnectionString ;

SqlConnection con = new SqlConnection(strConnString);

SqlCommand cmd = new SqlCommand();

cmd = new SqlCommand("Delete from Emp where Empid=" + DataGrid1.DataKeys[e.Item.ItemIndex].ToString(), con);

con.Open();

int rows = cmd.ExecuteNonQuery();

if (rows > 0)

{

Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "Deleted", "");

con.Close();

FillDataGrid();

}

I m able to get the data in the datagrid but delete is not taking place. Please help .

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vikram Agrawal11y ago
Well then set property CommandName="Delete" for your delete button. and then see is it executing that event or not. I hope it will work.
0
Dipanjana Mukherjee11y ago
Hi I have tried debugging the code .. the delete command function is not executing only . What can I do to execute it ?
0
Vikram Agrawal11y ago

Hi Deepanjana,
Have you debugged your code?
first verify is DataGrid1_DeleteCommandy event executing or not?
0