delete event not working

muhammad waqas

13y1.5k.NET

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

6 Replies

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

Sunny Sharma13y ago
How have you added delete button, show me your code.
Iftikar Hussain13y ago
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 Sharma13y ago
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 waqas13y ago
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 Hussain13y ago
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
13y ago
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()?