6-14.aspx

来自「这是一个很好的基于数据库的系统」· ASPX 代码 · 共 28 行

<%@ Page Language="C#" %>
<%@Import Namespace="System.Data"%>
<%@Import Namespace="System.Data.OleDb"%>
<Script runat="server">
void Page_Load(Object Src, EventArgs E) { 
	OleDbConnection Conn=new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;"+
                    "Data Source="+Server.MapPath("person.mdb"));
	Conn.Open();
	string strSQL="select * from grade;";
	OleDbDataAdapter da=new OleDbDataAdapter(strSQL, Conn);
	DataSet ds = new DataSet();
	da.Fill(ds,"grade");
	DataTable dt = ds.Tables["grade"];
	DataRow row = dt.NewRow();
	row["学号"] = "199";
	row["姓名"] = "小布什";
	row["数学"] = 58;
	dt.Rows.Add(row);
	OleDbCommandBuilder cb = new OleDbCommandBuilder(da);
	da.Update(ds,"grade");
	dg.DataSource = ds.Tables["grade"].DefaultView;
	dg.DataBind();
	Conn.Close();
}
</script>

<ASP:DataGrid id="dg" runat="server"/>