1、if(!IsPostBack)
{
....
}
表示该页面首次加载时需要做哪些事情。
2、用gridview邦定数据后,删除某一行操作,获取主键id代码为String id = GridView1.DataKeys[e.RowIndex].Value.ToString();
在gridview属性里的datakeynames设置字段。
3、连接数据库的代码:String db = Server.MapPath("test.mdb");
String ConnectionStr = "Data Source="+db+";Mode=Share Provider=Microsoft.Jet.OLEDB.4.0";
OleDbConnection conn = new OleDbConnection(ConnectionStr);
conn.Open();
Response.Write("当前连接状态为"+ conn.State.ToString());
conn.Close();
4、邦定数据集
Dataview dv;
String db = Server.MapPath("test.mdb");
String ConnectionStr = "Data Source=" + db + ";Provider=Microsoft.Jet.OLEDB.4.0";
OleDbConnection conn = new OleDbConnection(ConnectionStr);
String sql = "select *from test2 ";
OleDbCommand cmd = new OleDbCommand(sql, conn);
OleDbDataAdapter da = new OleDbDataAdapter();
da.SelectCommand = cmd;
DataSet ds = new DataSet();
da.Fill(ds,"test2");
dv=ds.Tables["test2"].DefaultView;
this.Gridview1.DataSource = dv;
this.Gridview1.DataBind();