EditIndex的值设置

protected void GridView1_RowUpdating

(object sender, GridViewUpdateEventArgs e)

{

int empid;

string fname, lname;

empid = int.Parse(GridView1.Rows[e.RowIndex].

Cells[0].Text);

fname = ((TextBox)GridView1.Rows[e.RowIndex].

Cells[1].Controls[0]).Text;

lname = ((TextBox)GridView1.Rows[e.RowIndex].

Cells[2].Controls[0]).Text;

 

SqlConnection cnn = new SqlConnection(@"data source=

./sqlexpress;initial catalog=northwind;integrated 

security=true");

cnn.Open();

SqlCommand cmd = new SqlCommand("update employees set 

firstname=@fname,lastname=@lname where employeeid=@empid",

 cnn);

cmd.Parameters.Add(new SqlParameter("@fname",fname));

cmd.Parameters.Add(new SqlParameter("@lname", lname));

cmd.Parameters.Add(new SqlParameter("@empid", empid));

cmd.ExecuteNonQuery();

cnn.Close();

 

GridView1.EditIndex = -1;

BindGrid();

}