Tuesday, March 28, 2006

datagrid中ItemTemplate的使用





<asp:Label runat="server"><%# formatString(Container.DataItem("RowType")) %>asp:Label>







橘色可省略...

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網頁了,不然似乎刪除完網頁沒有反應。

datagrid update的問題

private void Page_Load(object sender, System.EventArgs e) {
// 在這裡放置使用者程式碼以初始化網頁
//檢查session
Auth_check ac = new Auth_check();
string alert_str = ac.check_login(Session);
Response.Write(alert_str);
this.dbp = new DBprocess(Server.MapPath("../ag.mdb"));


this.dbp.dbconn.Open();
this.sql = "Select * From "+ this.tb_name;

if(!IsPostBack) {
DataGrid1.DataSource = dbp.GetDataTable(this.sql,dbp.dbconn,tb_name);
DataGrid1.DataBind();
}
this.dbp.dbconn.Close();

}