在DataGrid中经弹出窗口确认后执行操作(删除)。(附在DataGrid中修改,添加记录)详见代码!!
; BigClassList.EditItemIndex = (int)e.Item.ItemIndex;
BindGrid("BigClassID");
}
public void MyDataGrid_Cancel(Object sender, DataGridCommandEventArgs e)
{
// 将当前行置为非编辑状态
BigClassList.EditItemIndex = -1;
BindGrid("BigClassID");
}
public void MyDataGrid_Update(Object sender, DataGridCommandEventArgs e)
{
// 更新当前行
string BigClassID=e.Item.Cells[0].Text;
string BigClassName=Regex.Replace(((TextBox)e.Item.Cells[1].Controls[0]).Text,"'","''");
string BigClassSortID=((TextBox)e.Item.Cells[2].Controls[0]).Text;
String updateCmd = "UPDATE BigClass SET BigClassName ='" + BigClassName + "',"
+ "BigClassSortID=" + BigClassSortID
+ " where BigClassID =" + BigClassID;
myComm = new OdbcCommand(updateCmd, myConn);
myComm.Connection.Open();
try
{
myComm.ExecuteNonQuery();
// Response.Write("<font color=red><b>已更新记录</b><font><br>");
Message.Text = "<font color=red><b>已更新记录</b><font>
BindGrid("BigClassID");
}
public void MyDataGrid_Cancel(Object sender, DataGridCommandEventArgs e)
{
// 将当前行置为非编辑状态
BigClassList.EditItemIndex = -1;
BindGrid("BigClassID");
}
public void MyDataGrid_Update(Object sender, DataGridCommandEventArgs e)
{
// 更新当前行
string BigClassID=e.Item.Cells[0].Text;
string BigClassName=Regex.Replace(((TextBox)e.Item.Cells[1].Controls[0]).Text,"'","''");
string BigClassSortID=((TextBox)e.Item.Cells[2].Controls[0]).Text;
String updateCmd = "UPDATE BigClass SET BigClassName ='" + BigClassName + "',"
+ "BigClassSortID=" + BigClassSortID
+ " where BigClassID =" + BigClassID;
myComm = new OdbcCommand(updateCmd, myConn);
myComm.Connection.Open();
try
{
myComm.ExecuteNonQuery();
// Response.Write("<font color=red><b>已更新记录</b><font><br>");
Message.Text = "<font color=red><b>已更新记录</b><font>
| 对此文章发表了评论 |

