Monday, March 27, 2006

datagrid修改的問題

private void DataGrid1_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) {
string strSQL = "Delete From "+this.tb_name+" Where ID="+e.Item.Cells[0].Text+"";
this.dbp.dbconn.Open();
OleDbCommand objCmd = new OleDbCommand(strSQL, this.dbp.dbconn);
objCmd.ExecuteNonQuery();
objCmd.Connection.Close();
this.dbp.dbconn.Open();
OleDbDataAdapter objCmd2 = new OleDbDataAdapter(this.sql,this.dbp.dbconn);
DataSet ds = new DataSet();
objCmd2.Fill(ds,"fqa");
DataGrid1.DataSource = ds.Tables["fqa"].DefaultView;
DataGrid1.DataBind();
}

加了下面這兩行就會reflesh網頁了,不然似乎刪除完網頁沒有反應。

No comments: