While Updating gridview data,it shows an error.

Priyanka Singh

7y873.NET

{
int id = (int)gvEmployee.DataKeys[row.RowIndex].Value;
String firstName = ((TextBox)row.Cells[0].Controls[0]).Text;
String lastName = ((TextBox)row.Cells[0].Controls[0]).Text;
String position = ((TextBox)row.Cells[0].Controls[0]).Text;
String team = ((TextBox)row.Cells[0].Controls[0]).Text;
if ((firstName ?? lastName ?? position ?? team) != String.Empty)
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString))
{
string sql = @"update set employee set SET FirstName = @FirstName,LastName = @LastName,Position = @Position,Team = @Team WHERE Id = @Id";
using (SqlCommand cmd = new SqlCommand(sql, con))
{
con.Open();
cmd.Parameters.AddWithValue("@FirstName", firstName);
cmd.Parameters.AddWithValue("@LastName", lastName);
cmd.Parameters.AddWithValue("@Position", position);
cmd.Parameters.AddWithValue("@Team", team);
cmd.Parameters.AddWithValue("@ID", id);
cmd.ExecuteNonQuery();
}
}
return true;
}
return false;
}

It shows an error.Help me to resolve the problem.

4 Replies

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

Jignesh Kumar7y ago
Hi Priyanka,

you need to add command agrument in GridView button.
CommandArgument='<%# DataBinder.Eval(Container, "RowIndex") %>'
https://stackoverflow.com/questions/2818203/get-datakey-values-in-gridview-rowcommand
Laxmidhar Sahoo7y ago
https://www.c-sharpcorner.com/UploadFile/anjudidi/select-update-and-delete-data-in-a-Asp-Net-gridview-control/
Mohsin Arif7y ago
Priyanka Singh

there is one issue you pick from GridviewRow which return 0 and less than so kindly use the selected index property it will return selected index of slected row.

or pass Rowid through command filed
CommandArgument='<%# DataBinder.Eval(Container, "RowIndex") %>'

int rowIndex = int.Parse(e.CommandArgument.ToString());

string val = (string)this.grid.DataKeys[rowIndex]["myKey"];

or follow this link
https://stackoverflow.com/questions/2818203/get-datakey-values-in-gridview-rowcommand

or do like this
protected void GV_PCC_PCF_RowDeleting(object sender, GridViewDeleteEventArgs e)

{

try

{

DataTable dt = (DataTable)ViewState["GV_PCC_PCF"];

dt.Rows[e.RowIndex].Delete();

GV_PCC_PCF.DataSource = dt;

GV_PCC_PCF.DataBind();

ObjTransaction.map_JQ_DataTable_To_GridView(GV_PCC_PCF);

}

catch (Exception ex)

{

Master.ShowError = ex.Message;

}

}
Amit Kumar7y ago
Hi, The meaning of your error is that means the index you are looking for is not exist in that gridview. you need to add one check condition before reading data.You need to check if gvEmployee.DataKeys.Count is covered in e.RowIndex. Hope you got the Solution.