foreach (DataGridItem gridrow in DataGrid2.Items)
{
string autoid = this.bill_no.Text;
SqlConnection conairno = Operate.createCon();
//建立DataSet中testTable表的新行
DataRow row = ds1.Tables["per1"].NewRow();
//针对绑定数据源的数据项索引建立数据行的索引
row = ds1.Tables["per1"].Rows[gridrow.DataSetIndex];
//取得当前行文本框中的数据值,添加到DataSet中testTable表
//DataGrid2.Items[1].Cells[1].Text;
row["client_autoid"] = gridrow.Cells[0].Text;
// row["client_autoid"] = ((TextBox)(gridrow.FindControl("client_autoid"))).Text;
row["airno"] = ((TextBox)(gridrow.FindControl("airno"))).Text;
string strSQLairno = "update diary set airno='" + row["airno"] + "' where client_autoid='" + row["client_autoid"] + "' and autoid='" + autoid + "'";
SqlCommand cmdairno = new SqlCommand(strSQLairno, conairno);
conairno.Open();
cmdairno.ExecuteNonQuery();
}