欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  IT编程

asp.net 数据绑定的实例代码

程序员文章站 2024-03-01 17:32:10
复制代码 代码如下:public partial class _default : system.web.ui.page{    protec...
复制代码 代码如下:

public partial class _default : system.web.ui.page
{
    protected string title="大家好";            //前台代码<title><%#title %></title>
    protected void page_load(object sender, eventargs e)
    {
        dataset ds = new dataset();
        string sql = configurationmanager.connectionstrings["strsql"].connectionstring;
        using (sqlconnection sqlcnn=new sqlconnection(sql))
        {
            using (sqlcommand sqlcmm=sqlcnn.createcommand())
            {
                sqlcmm.commandtext = "select * from list";
                sqldataadapter adapter = new sqldataadapter(sqlcmm);
                adapter.fill(ds);
            }
            this.radiobuttonlist1.datasource = ds.tables[0];
            this.radiobuttonlist1.datatextfield = "listname";
            this.radiobuttonlist1.datavaluefield = "id";
            //this.radiobuttonlist1.databind();
            this.checkboxlist1.datasource = ds.tables[0];
            this.checkboxlist1.datatextfield = "listname";
            this.checkboxlist1.datavaluefield = "id";
            //this.radiobuttonlist1.databind();
            this.databind();
        }            //数据绑定到radiobuttonlist,checkboxlist
        if (!ispostback)
        {
            dataset ds1 = new dataset();
            using (sqlconnection sqlcnn1 = new sqlconnection(sql))
            {
                using (sqlcommand sqlcmm1 = sqlcnn1.createcommand())
                {
                    sqlcmm1.commandtext = "select provinceid,provincename from province";
                    sqldataadapter adapter = new sqldataadapter(sqlcmm1);
                    adapter.fill(ds1);
                    this.dropdownlist1.datasource = ds1.tables[0];
                    this.dropdownlist1.datatextfield = "provincename";
                    this.dropdownlist1.datavaluefield = "provinceid";
                    this.dropdownlist1.databind();
                }
            }
        }
    }
    protected void dropdownlist1_selectedindexchanged(object sender, eventargs e)
    {
        dataset ds = new dataset();
        string str = configurationmanager.connectionstrings["strsql"].connectionstring;
        using (sqlconnection sqlcnn = new sqlconnection(str))
        {
            using (sqlcommand sqlcmm = sqlcnn.createcommand())
            {
                sqlcmm.commandtext = "select cityid,cityname from city where provinceid='" + this.dropdownlist1.selectedvalue + "'";
                sqldataadapter adapter = new sqldataadapter(sqlcmm);
                adapter.fill(ds);
                this.dropdownlist2.datasource = ds.tables[0];
                this.dropdownlist2.datatextfield = "cityname";
                this.dropdownlist2.datavaluefield = "cityid";
                this.dropdownlist2.databind();
            }
        }
    }//实现省市二级联动
}