如何把数据库中的内容绑定到CheckBoxList上？

最新推荐文章于 2017-12-18 10:33:56 发布

码上有钱了

最新推荐文章于 2017-12-18 10:33:56 发布

阅读量8.7k

点赞数

文章标签：数据库 asp button string server object

本文链接：https://blog.csdn.net/xft_1981/article/details/1423873

版权

本文介绍了如何将数据库中的数据绑定到ASP.NET的CheckBoxList控件上，以实现显示用户上次选择的权限项。通过示例展示了利用Login和ProdClass两个表，以及在ProdClass表中增加UserID字段来实现这一功能。

摘要由CSDN通过智能技术生成

有时候我们不但要把CheckBoxList的数据写入到数据库，还要把数据库的内容与CheckBoxList对应，让他显示上次我们选中的项，我是这么实现的：

比方说我们要给用户赋予不同的权限，那么我们数据库有Login,ProdClass两张表，那么我们在ProdClass表中插入一个字段UserID，下面是程序：

UserClass.aspx页面：

<% @ Page language = " c# " Codebehind = " UserClass.aspx.cs " AutoEventWireup = " false " Inherits = " LabWeb.adminstra.UserClass " %>
<! DOCTYPE HTML PUBLIC " -//W3C//DTD HTML 4.0 Transitional//EN " >
< HTML >
     < HEAD >
         < title > UserClass </ title >
         < meta content = " Microsoft Visual Studio .NET 7.1 " name = " GENERATOR " >
         < meta content = " C# " name = " CODE_LANGUAGE " >
         < meta content = " JavaScript " name = " vs_defaultClientScript " >
         < meta content = " http://schemas.microsoft.com/intellisense/ie5 " name = " vs_targetSchema " >
     </ HEAD >
     < body >
         < form id = " Form1 " method = " post " runat = " server " >
             < FONT face = " 宋体 " >
                 < asp:radiobuttonlist id = " RadioButtonList1 " runat = " server " RepeatColumns = " 3 " RepeatDirection = " Horizontal "
                    AutoPostBack = " True " ></ asp:radiobuttonlist >
                 < hr color = " red " >
             </ FONT >
             < asp:checkboxlist id = " CheckBoxList1 " runat = " server " RepeatColumns = " 3 " RepeatDirection = " Horizontal " ></ asp:checkboxlist >
             < hr color = " red " >
             < asp:button id = " Button1 " runat = " server " Text = " 设置分类 " Width = " 176px "<