📄 datagridbuttoncolumn.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);
MyAdapter.Fill(ds,"Score");
score.DataSource = ds;
score.DataMember = "Score";
score.DataBind();
}
public void DataGrid_ItemCommand(Object sender,DataGridCommandEventArgs e)
{
//获取被操作的那一行
TableRow tr = e.Item;
//获取每个TableCell的数据
lblName.Text = tr.Cells[1].Text;
lblChinese.Text = tr.Cells[2].Text;
lblMath.Text = tr.Cells[3].Text;
lblEnglish.Text = tr.Cells[4].Text;
}
</script>
<html>
<head>
<title></title>
</head>
<body>
<form runat="server">
<center>
<b>演示ButtonColumn</b>
<table>
<tr>
<td>
<asp:DataGrid id="score" runat="server"
HeaderStyle-BackColor="#aaaadd"
AlternatingItemStyle-BackColor="#eeeeee"
AutoGenerateColumns="False"
OnItemCommand="DataGrid_ItemCommand"
>
<Columns>
<asp:ButtonColumn HeaderText="操作区" Text="显示详细信息" />
<asp:BoundColumn HeaderText="姓名" DataField="Name" />
<asp:BoundColumn HeaderText="语文" DataField="Chinese" />
<asp:BoundColumn HeaderText="数学" DataField="Math" />
<asp:BoundColumn HeaderText="英语" DataField="English" />
</Columns>
</asp:DataGrid>
</td>
<td valign="top">
<table>
<tr><td>选中的人名:</td><td><asp:Label id="lblName" ForeColor="Red" runat="server" /></td></tr>
<tr><td>语文成绩：</td><td><asp:Label id="lblChinese" ForeColor="Red" runat="server" /></td></tr>
<tr><td>数据成绩：</td><td><asp:Label id="lblMath" ForeColor="Red" runat="server" /></td></tr>
<tr><td>英语成绩：</td><td><asp:Label id="lblEnglish" ForeColor="Red" runat="server" /></td></tr>
</table>
</td>
</tr>
</table>
</center>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -