📄 update.aspx
字号:
<% @ Page Language="C#" %>
<% @ Import Namespace="System.Data" %>
<% @ Import Namespace="System.Data.OleDb" %>
<Script Language="C#" Runat="Server">
OleDbConnection MyConn;
public void Page_Load(Object src,EventArgs e)
{
//连接语句
string MyConnString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source="+Server.MapPath(".")+"\\db1.mdb;";
MyConn = new OleDbConnection(MyConnString);
MyConn.Open();
if(!Page.IsPostBack)
{
//将数据捆绑至Orign数据表格
BindGrid(Orign);
}
}
public void btnUpdate_Click(Object sender,EventArgs e)
{
//更新语句--所有人的历史成绩减10分
string strUpdate = "Update Score Set history=history-10";
OleDbCommand MyComm = new OleDbCommand(strUpdate,MyConn);
//执行更新语句
MyComm.ExecuteNonQuery();
//数据捆绑至New数据表格
BindGrid(New);
}
public void BindGrid(DataGrid dg)
{
OleDbDataReader dr;
//查询语句--版面关系只取前5个人的成绩
string strSel = "Select Top 5 * from Score";
OleDbCommand MyComm = new OleDbCommand(strSel,MyConn);
//注意下面一句
dr = MyComm.ExecuteReader();
dg.DataSource = dr;
dg.DataBind();
}
</script>
<html>
<head>
<title></title>
</head>
<body>
<form runat="server">
<center>
<font size="-1">
<hr>
<table>
<tr><td><b>OldData</b></td><td><b>NewData</b></td></tr>
<tr>
<td>
<asp:DataGrid id="Orign" runat="server"
AutoGenerateColumns="False"
>
<HeaderStyle BackColor="#aaaadd" />
<AlternatingItemStyle BackColor="#eeeeee" />
<Columns>
<asp:BoundColumn HeaderText="Name" DataField="Name" />
<asp:BoundColumn HeaderText="History" DataField="History" />
<asp:BoundColumn HeaderText="Math" DataField="Math" />
</Columns>
</asp:DataGrid>
</td>
<td>
<asp:DataGrid id="New" runat="server"
AutoGenerateColumns="False"
>
<HeaderStyle BackColor="#aaaadd" />
<AlternatingItemStyle BackColor="#eeeeee" />
<Columns>
<asp:BoundColumn HeaderText="Name" DataField="Name" />
<asp:BoundColumn HeaderText="History" DataField="History" />
<asp:BoundColumn HeaderText="Math" DataField="Math" />
</Columns>
</asp:DataGrid>
</td>
</tr>
<tr><td><asp:Button id="btnUpdate" Text="更新" OnClick="btnUpdate_Click" runat="server" /></td></tr>
</table>
</font>
</center>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -