<% @ Page Language="c#" %>
<% @ Import Namespace="System.Data" %>
<% @ Import Namespace="System.Data.OleDb" %>
<script language="C#" runat="server">
public void Page_Load(Object src,EventArgs e)
{
string MyConnString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath(".")+"/db1.mdb;";
string strSel="select * from Score";
string aaa;
DataSet ds=new DataSet();

OleDbConnection MyConn=new OleDbConnection(MyConnString);
OleDbDataAdapter MyAdapter= new OleDbDataAdapter(strSel,MyConn);
OleDbCommandBuilder custCB = new OleDbCommandBuilder(MyAdapter);
MyAdapter.UpdateCommand= custCB.GetUpdateCommand();

MyAdapter.Fill(ds,"Score");


//插入新的一行
DataRow dr= ds.Tables["Score"].NewRow();
dr["name"] ="aafly";
dr["ip"] ="aaa";
dr["time"] ="bbb";
ds.Tables["Score"].Rows.Add(dr);

// 更新第一行
dr =ds.Tables["Score"].Rows[0];
dr["name"] ="200";
dr["ip"] ="100";

//储存数据
MyAdapter.Update(ds,"Score");

//利用DataGrid在页面显示数据库的内容
score.DataSource= ds;
score.DataMember= "score";
score.DataBind();



}
</script>