delete event not working

Question

protected void gvMyRecord_RowDeleting(object sender, GridViewDeleteEventArgs e)

{

SqlCommand command = new SqlCommand("DELETE FROM customer_record WHERE customer_id='" + ResultGridView.DataKeys[e.RowIndex].Values[0].ToString() + "'");

connection.Open();

command.ExecuteNonQuery();

connection.Close

FillVendorGrid();

}

QUESTION: i an unable to understand this code please give me some guideline i will be very thank full to you

Sunny Sharma · Answer

How have you added delete button show me your code.

Iftikar Hussain · Answer

can you put the break point in below line and check what value you are getting protected void gvMyRecord_RowDeleting(object sender GridViewDeleteEventArgs e) { SqlCommand command = new SqlCommand(DELETE FROM customer_record WHERE customer_id=' + ResultGridView.DataKeys[e.RowIndex].Values[0].ToString() + '); connection.Open(); command.ExecuteNonQuery(); connection.Close FillVendorGrid(); } Regards Iftikar } Regards Iftikar

Sunny Sharma · Answer

Hi waqas RowDeleting event fires just before the row gets deleted inside a gridview in asp.net. To answer your question that this Delete event is not working- you must have a command button or link that will invoke this event. As you're unable to understand this code let me explain a bit. Two events are fired when deleting a record in gridveiw the first one is RowDeleting and the other is RowDeleted . When you invoke a delete command on your gridview it first fires the RowDeleting event offering you the chance to update your database for the record being deleted. until this event completes your data remain in gridview it's not deleted yet. After RowDeleting it fires RowDeleted which allows you to update any related view/control on the page if connected to the gridview. Hope you got the point and find it useful. Happy Coding :)

muhammad waqas · Answer

i make a gridview it show the data which i insert into database but the problem is now i add the delete and edit coloumns in the gridview . after that i code for this in DAL layer so it not working properly i need help what should i do i work properly. i am send you my whole DAL code please help me . using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Data; using System.Data.SqlClient; using crecord.buBE; namespace crecord.buDAL { public class buDAL { SqlConnection connection = new SqlConnection(Data Source=viky\waqas;Initial Catalog=final assinment;Integrated Security=True); public bool cust(crecord.buBE.buBE crecord) { bool status = false; try { SqlCommand command = new SqlCommand(cus connection); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(customer_name SqlDbType.NVarChar).Value = crecord.customer_name; command.Parameters.Add(customer_order SqlDbType.NVarChar).Value = crecord.customer_order; command.Parameters.Add(customer_address SqlDbType.NVarChar).Value = crecord.customer_address; command.Parameters.Add(customer_contact SqlDbType.Int).Value = crecord.customer_contact; connection.Open(); command.ExecuteNonQuery(); status = true; connection.Close(); } catch (Exception ex) { throw ex; } finally { } return status; } public List GetAll() { List Recordlst = new List (); SqlCommand command = new SqlCommand(sp_MyTestApplication_GetAllRecord connection); command.CommandType = CommandType.StoredProcedure; connection.Open(); SqlDataReader dr = command.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { crecord.buBE.buBE objRecord = new crecord.buBE.buBE(); objRecord.customer_id = Convert.ToInt32(dr[customer_id]); objRecord.customer_name = Convert.ToString(dr[customer_name]); objRecord.customer_order = Convert.ToString(dr[customer_order]); objRecord.customer_contact = Convert.ToInt32(dr[customer_contact]); objRecord.customer_address = Convert.ToString(dr[customer_address]); Recordlst.Add(objRecord); } } return Recordlst; } protected void gvMyRecord_RowDeleting(object sender GridViewDeleteEventArgs e) { SqlCommand command = new SqlCommand(DELETE FROM customer_record WHERE customer_id=' + ResultGridView.DataKeys[e.RowIndex].Values[0].ToString() + '); connection.Open(); command.ExecuteNonQuery(); connection.Close FillVendorGrid(); } } }

Iftikar Hussain · Answer

Hi The RowDeleting event is raised when a row's Delete button is clicked try like this protected void gvMyRecord_RowDeleting(object sender GridViewDeleteEventArgs e) { string id=ResultGridView.DataKeys[e.RowIndex].Value. ToString() ; SqlCommand command = new SqlCommand(DELETE FROM customer_record WHERE customer_id=' + id + '); connection.Open(); command.ExecuteNonQuery(); connection.Close FillVendorGrid(); } Regards Iftikar

Muralidharan Deenathayalan · Answer

Once the Delete button is pressed in the grid control gvMyRecord_RowDeleting will get fired. It will get the ID or primary key values from the ResultGridView.DataKeys[e.RowIndex control. Later the ID will get passed into the Delete statement and command + connect object will execute the query. BTW Are you getting any exception? What is the result of command.ExecuteNonQuery()?