📄 datasetopera.aspx
字号:
<% @ 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(".")+"..\\DataBase\\db1.mdb;";
string strSel = "select * from Score";
DataSet ds = new DataSet();
OleDbConnection MyConn = new OleDbConnection(MyConnString);
OleDbDataAdapter MyAdapter = new OleDbDataAdapter(strSel,MyConn);
OleDbCommandBuilder custCB = new OleDbCommandBuilder(MyAdapter);
MyAdapter.Fill(ds,"Score");
Orign.DataSource = ds;
Orign.DataMember = "Score";
Orign.DataBind();
//插入新的一行
DataRow dr = ds.Tables["Score"].NewRow();
dr["Name"] = "比尔";
dr["Class"] = "201";
dr["Chinese"] = 0;
dr["Math"] = 100;
dr["English"] = 90;
dr["Physics"] = 90;
dr["History"] = 60;
ds.Tables["Score"].Rows.Add(dr);
//更新第二行
dr = ds.Tables["Score"].Rows[1];
dr["Chinese"] = 100;
dr["Math"] = 100;
dr["English"] = 90;
dr["Physics"] = 90;
dr["History"] = 100;
//删除第三行
ds.Tables["Score"].Rows[2].Delete();
MyAdapter.Update(ds,"Score");
New.DataSource = ds;
New.DataMember = "Score";
New.DataBind();
}
</script>
<html>
<head>
<title></title>
</head>
<body>
<form runat="server">
<b>演示DataSet各项操作</b><br>
操作前：
<asp:DataGrid id="Orign" runat="server"
HeaderStyle-BackColor="#aaaadd"
AlternatingItemStyle-BackColor="#eeeeee"
/>
操作后：
<asp:DataGrid id="New" runat="server"
HeaderStyle-BackColor="#aaaadd"
AlternatingItemStyle-BackColor="#eeeeee"
/>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -