请大侠指点:为何在dataGrid中不能更新?
设置edit,update,cancel列后,点编缉进行编缉,完成编缉后,点更新按纽但无法获取相应列的值:
private void OnUpdate(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
string FirstName,LastName;
FirstName= e.Item.Cells[6].Text;
//获取的FirstName为空值,为什么???????????
DoDataBind();
//下面再接执行sql的update语句
}
但是按另一列的Delete按钮却可以获得其值:
private void OnDelete(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
Mess.Text = e.Item.Cells[6].Text;//可获取相应列的值
DoDataBind();
}
protected void DoDataBind()
{
System.Data.DataSet MyDS;
System.Web .UI.WebControls.BoundColumn BndCol;
MyCon=new SqlConnection(ConStr);
MyCon.Open();
String SqlStr="Select EmployeeID,LastName,FirstName,Birthdate,Address,City From Employees Order by EmployeeID";
MyDA=new SqlDataAdapter(SqlStr,MyCon);
MyDS=new DataSet("MyDsName");//为新建的数据集合名为'MyDsName'
MyDA.Fill(MyDS,"Employees");
this.DataGrid1.DataSource=MyDS.Tables["Employees"].DefaultView;
BndCol=new BoundColumn();
BndCol.DataField="EmployeeID";
BndCol.HeaderText="职员号";
BndCol.ReadOnly=true;
BndCol.ItemStyle.HorizontalAlign=HorizontalAlign.Center;
this.DataGrid1.Columns.Add(BndCol);
this.DataGrid1.DataBind();
}