UpdateCommand

[Luis Moises Rojas]

This code is suppose to update a table, but: Why e.item.Cells[2].Text does not have any value?
What i am doing wrong?

private void DataGrid1_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{ Utilitarios oUtil=new Utilitarios();
string sqlquery="Update ENC_TIPO_RESPUESTA set chr_tipo_respuesta='" + e.Item.Cells[2].Text + "'" +
" where chr_tipo_respuesta='" + TextBox1.Text + "'";
int RowAffected=oUtil.DeleteRow(sqlquery);
if(RowAffected ==0)
{
Page.RegisterStartupScript("errs","<script language=Javascript>alert('Registro Actualizado...');</script>");
BindData();
}
else
{
Page.RegisterStartupScript("errs","<script language=Javascript>alert('No se puede actualizar Registro...');</script>");
}
DataGrid1.EditItemIndex=-1;
BindData();
}

[RhinoBull]

This is VB6 forum - not C#. Ask admins to move it to the appropriate place.

[r0ach]

What you're doing wrong is posting a C# question in a vb forum.

Next, how many items are in the DataGrid? Remember that it is all 0 based, so [2] will be item 3

[si_the_geek]

Moved to C# forum

[Luis Moises Rojas]

This is VB6 forum - not C#. Ask admins to move it to the appropriate place.

Sorry!
It was a mistake.