📄 admin.aspx

📁 这是.net2005学习不可缺少的教程

💻 ASPX

字号:

<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<script language="C#" runat="server">
	private void Page_Load(object sender,EventArgs e)
	{
		if(!IsPostBack)
			BindData();                                  //启动页面时调用数据绑定子程序
	}
	//单击删除时执行该事件过程
	private void MyDataGrid_Delete(object sender,DataGridCommandEventArgs e)
	{
		//建立Connection对象,注意从web.Config中获取数据库连接字符串
		OleDbConnection conn = new OleDbConnection(ConfigurationSettings.AppSettings["strConn"]);
		//建立Command对象
		string strSql;
		strSql="Delete from users Where username='" +  MyDataGrid.DataKeys[e.Item.ItemIndex] +"'";
		OleDbCommand cmd = new OleDbCommand(strSql, conn);
		conn.Open();
		cmd.ExecuteNonQuery();          //执行删除操作
		conn.Close();
		MyDataGrid.EditItemIndex = -1;   //重新绑定
		BindData();
	}
	private void  BindData()
	{
		//建立Connection对象,注意从web.Config中获取数据库连接字符串
		OleDbConnection conn = new OleDbConnection(ConfigurationSettings.AppSettings["strConn"]);
		OleDbCommand cmd = new OleDbCommand("select * from users", conn);        //建立Command对象
		OleDbDataAdapter adp = new OleDbDataAdapter(cmd);                            //建立DataAdapter对象
		DataSet ds = new DataSet();                                         //建立DataSet对象
		adp.Fill(ds, "users");                                          //填充DataSet
		MyDataGrid.DataSource=ds.Tables["users"].DefaultView;            //指定数据源
		MyDataGrid.DataBind();                                           //执行绑定
	}
</script>
<html>
<body>
	<h4 align="center">管理员界面</h4>
	<form runat="server">
		<ASP:DataGrid id="MyDataGrid" Width="100%" HeaderStyle-BackColor="#BCBCBC" OnDeleteCommand="MyDataGrid_Delete"  DataKeyField="username" runat="server" >
			<Columns>
			<asp:ButtonColumn Text="删除" CommandName="Delete"/>
			</Columns>
		</ASP:DataGrid>
	</form>
	<p align="center"><asp:hyperlink id="HyperLink1" text="返回首页" NavigateUrl="../default.aspx" runat="server" />

</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -