Update Event is not working properly in Grid View Control(Urgent)

Hi...

i didnt get any error in runtime. but updation event not working.... So Please help me to recover this problem..

Default.aspx.cs
----------------

protected void grdv_RowEditing(object sender, GridViewEditEventArgs e)
{

grdvCustomer.EditIndex = e.NewEditIndex;

bind();

}

protected void Grdv_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{

grdvCustomer.EditIndex = -1;

bind();

}

protected void grdv_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
// Response.Write("");

GridViewRow row = (GridViewRow)grdvCustomer.Rows[e.RowIndex];
Label lbl = (Label)row.FindControl("lblComId");

TextBox txtCmt = (TextBox)row.FindControl("txtComments");

DropDownList drpfdb = (DropDownList)row.FindControl("drpFeedback");
DropDownList drpStat = (DropDownList)row.FindControl("drpStatus");

conn.Open();
SqlCommand cmd = new SqlCommand("update compliants set status='" + drpStat.SelectedItem.Text + "',comments='" + txtCmt.Text + "' ,feedback ='" + drpfdb.SelectedItem.Text + "'where comid='" + lbl.Text + "'", conn);
cmd.ExecuteNonQuery();
grdvCustomer.EditIndex = -1;
conn.Close();

bind();

}

public void bind()
{

conn.Open();

SqlDataAdapter da = new SqlDataAdapter("select * from compliants where customerid='" + lblCusAns.Text + "' ", conn);

DataSet ds = new DataSet();

da.Fill(ds, "compliants");

grdvCustomer.DataSource = ds.Tables[0].DefaultView;

grdvCustomer.DataBind();

conn.Close();

}

protected void grdv_PageIndexChanging(object sender, GridViewPageEventArgs e)

{
grdvCustomer.PageIndex = e.NewPageIndex;

bind();
}

Source Code
-------------

AllowPaging="True" AllowSorting="True"
BorderColor="#999999"
BorderStyle="Solid"
BorderWidth="1px"
CellPadding="3"
ForeColor="Black"
GridLines="Vertical"
AutoGenerateColumns="False"
OnRowEditing="grdv_RowEditing "
OnRowCancelingEdit="Grdv_RowCancelingEdit"
OnRowUpdating="grdv_RowUpdating"
OnPageIndexChanging="grdv_PageIndexChanging" >

<%#Eval("comid") %>

<%#Eval("customerid") %>

<%#Eval("description") %>

<%#Eval("priority") %>

<%#Eval("status") %>

HeaderImageUrl="~/notepad_(edit)_16x16.gif" ShowEditButton="True" UpdateImageUrl="~/update1.jpg" EditText="" InsertText="" NewText="" SelectText="" />

7 Replies

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

Suthish Nair15y ago
You are missing something else.... refer GridView Events and how they work, study and implement..

msdn
Ankit Nandekar15y ago
ur Row updating event working or not when u r clicking on update button update event firing or not ?
send me ur both files i will design and cs i will check it.
Santhonabin15y ago
Hi Ankit Nandekar,

i used break point, but while running controls not move into that update function..... and also not have error in that... Please help to recover this problem
Ankit Nandekar15y ago
just put break point on this line and check txt.cmt and lbl.Text value
SqlCommand cmd = new SqlCommand("update compliants set status='" + drpStat.SelectedItem.Text + "',comments='" + txtCmt.Text + "' ,feedback ='" + drpfdb.SelectedItem.Text + "'where comid='" + lbl.Text + "'", conn);

if u r getting value in txt.cmt and lbl.Text then check postback.
Santhonabin15y ago
hi... s. the Update event is hitting while debugging
15y ago
If you dubug the application does the debugger is hitting the Update event ?
Krishna Garad15y ago
on your page might be there are another validation control which are causing that your gridview update event is not firing. Take all validation in groups and then try.