datasetupdate.aspx

来自「ASP.net动画教程」· ASPX 代码 · 共 46 行

ASPX
46
字号
<% @ 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);
	MyAdapter.Fill(ds,"Score");

	//取出第一行
	DataRow dr = ds.Tables["Score"].Rows[0];
	dr["Name"]		= "比尔";
	dr["Class"]		= "201";
	dr["Chinese"]	= 0;
	dr["Math"]		= 100;
	dr["English"]	= 90;
	dr["Physics"]	= 90;
	dr["History"]	= 60;

	score.DataSource = ds;
	score.DataMember = "Score";
	score.DataBind();

}
</script>
<html>
<head>
<title></title>
</head>
<body>
<form runat="server">
<b>演示DataSet</b>
<asp:DataGrid id="score" runat="server"
HeaderStyle-BackColor="#aaaadd"
AlternatingItemStyle-BackColor="#eeeeee"
/>
</form>
</body>
</html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?