DataGrid Updates

[Michael Shaw]

Hello,

I'm not sure if this is the right forum for this but I'm having a great
difficulty in updating my datagrid. Basically, I have run the debugger and
it seems as though the new value I type in for the field "password" isn't
captured. I'm posting the code for the update portion and will appreciate
any help.

Thank you
Mike

private void DataGrid1_UpdateCommand(object source,
System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
string ItemIndex =
DataGrid1.DataKeys[(int)e.Item.ItemIndex].ToString();

TextBox tb;
tb = (TextBox)(e.Item.Cells[3].Controls[0]);
string password = tb.Text;

SqlConnection conn = new SqlConnection(strConn);
SqlCommand cmd = new SqlCommand(update, conn);

cmd.Parameters.Add(new SqlParameter("@Username", SqlDbType.NVarChar,
20));
cmd.Parameters["@Username"].Value =
DataGrid1.DataKeys[(int)e.Item.ItemIndex];
cmd.Parameters.Add("@Password",password);
try
{
conn.Open();
cmd.ExecuteNonQuery();
DataGrid1.EditItemIndex = -1;
}
finally
{
conn.Close();
}
DataGrid1.DataBind();
}