📄 6-26.aspx
字号:
<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<script runat="server">
OleDbConnection Conn;
protected void Page_Load(Object Src, EventArgs E ) {
String Provider,DataBase,ConnStr,SQL;
Provider = "Microsoft.Jet.OLEDB.4.0;";
DataBase = Server.MapPath("person.mdb");
ConnStr = "Provider="+Provider+"Data Source="+DataBase;
Conn = new OleDbConnection(ConnStr);
if (!IsPostBack) BindGrid();
}
void DataGrid_Edit(Object sender,DataGridCommandEventArgs E){
dg.EditItemIndex = (int)E.Item.ItemIndex;
BindGrid();
}
void DataGrid_Cancel(Object sender,DataGridCommandEventArgs E){
dg.EditItemIndex = -1;
BindGrid();
}
void DataGrid_Update(Object sender,DataGridCommandEventArgs E){
String strSQL = "UPDATE grade SET "+
"姓名='"+((TextBox)E.Item.Cells[3].Controls[0]).Text
+"',数学="+((TextBox)E.Item.Cells[4].Controls[0]).Text
+" where 学号="+dg.DataKeys[(int)E.Item.ItemIndex];
OleDbCommand cm = new OleDbCommand(strSQL,Conn);
Conn.Open();
try {
cm.ExecuteNonQuery();
Message.InnerHtml="<b>编辑成功</b>";
// 退出编辑状态
dg.EditItemIndex=-1;
}
catch (OleDbException) {
Message.InnerHtml="编辑失败";
Message.Style["color"]="red";
}
cm.Connection.Close();
// 更新DataGrid
BindGrid();
}
// 处理删除事件
public void DataGrid_Delete(Object sender,DataGridCommandEventArgs E){
String strSQL="DELETE FROM grade WHERE 学号="
+ dg.DataKeys[(int)E.Item.ItemIndex];
OleDbCommand cm = new OleDbCommand(strSQL,Conn);
Conn.Open();
try {
cm.ExecuteNonQuery();
Message.InnerHtml = "<b>删除成功</b>";
}
catch (OleDbException){
Message.InnerHtml = "<b>删除失败</b>";
Message.Style["color"]="red";
}
Conn.Close();
BindGrid();
}
public void BindGrid() {
OleDbDataAdapter da=new OleDbDataAdapter("select * from grade",Conn);
DataSet ds = new DataSet();
da.Fill(ds);
dg.DataSource=ds;
dg.DataBind();
}
</script>
<body style="font: 10pt verdana">
<form runat="server">
<asp:DataGrid id="dg" runat="server"
Width="400" BackColor="#ccccff"
BorderColor="black" ShowFooter="false"
CellPadding=3 CellSpacing="0"
Font-Name="Verdana" Font-Size="8pt"
HeaderStyle-BackColor="#aaaadd"
OnEditCommand="DataGrid_Edit"
OnCancelCommand="DataGrid_Cancel"
OnUpdateCommand="DataGrid_Update"
OnDeleteCommand="DataGrid_Delete"
DataKeyField="学号"
AutoGenerateColumns="false"
MaintainState="false">
<Columns>
<asp:EditCommandColumn EditText="编辑" CancelText="取消"
UpdateText="更新" ItemStyle-Wrap="false"/>
<asp:ButtonColumn Text="删除" CommandName="Delete" ItemStyle-Wrap="false"/>
<asp:BoundColumn HeaderText="学号" DataField="学号" ReadOnly="True"/>
<asp:BoundColumn HeaderText="姓名" DataField="姓名" />
<asp:BoundColumn HeaderText="数学" DataField="数学" />
</Columns>
</asp:DataGrid>
<span id="Message" MaintainState="false"
style="font: arial 11pt;" runat="server"/>
</form>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -