经典的GridView72种使用技巧(13)

{

sqlcon = new SqlConnection(strCon);

string sqlstr = \飞狐工作室 set 姓名='\

+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim() + \家庭住址='\

+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim() + \where 身份证号码='\

+ GridView1.DataKeys[e.RowIndex].Value.ToString() + \ sqlcom = new SqlCommand(sqlstr, sqlcon); sqlcon.Open();

sqlcom.ExecuteNonQuery(); sqlcon.Close();

GridView1.EditIndex = -1; bind(); }

protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) {

GridView1.EditIndex = -1; bind(); }

public void bind() {

string sqlstr = \top 10 * from 飞狐工作室\ sqlcon = new SqlConnection(strCon);

SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon); DataSet myds = new DataSet(); sqlcon.Open();

myda.Fill(myds, \飞狐工作室\ GridView1.DataSource = myds;

GridView1.DataKeyNames = new string[] { \身份证号码\}; GridView1.DataBind();

for (int i = 0; i <= GridView1.Rows.Count - 1; i++) {

DataRowView mydrv = myds.Tables[\飞狐工作室\ string score = Convert.ToString(mydrv[\起薪\

if (Convert.ToDouble(score) < 34297.00)//大家这里根据具体情况设置可

能ToInt32等等

{

GridView1.Rows[i].Cells[4].BackColor = System.Drawing.Color.Red; } }