简单数据绑定和复杂数据绑定

最新推荐文章于 2023-03-28 08:00:00 发布

C979170768

最新推荐文章于 2023-03-28 08:00:00 发布

阅读量710

点赞数

CC 4.0 BY-SA版权

分类专栏： ASP.NET 文章标签： dataset object button string cmd security

本文链接：https://blog.csdn.net/C979170768/article/details/6998188

ASP.NET 专栏收录该内容

39 篇文章

订阅专栏

本文介绍了一个使用ASP.NET进行数据库操作的例子，包括通过SqlConnection连接数据库，使用SqlCommand执行SQL语句，以及如何填充数据到DataSet和DataTable，并展示数据到UI组件如DropDownList、RadioButtonList、CheckBoxList和GridView。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

public partial class Default2 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
       
    }

    protected void Button1_Click(object sender, EventArgs e)
    {
        string strcon = ConfigurationManager.ConnectionStrings["con"].ConnectionString;

        //  string con = "server=.\\sqlexpress;initial catalog=english;integrated security=true";
        using (SqlConnection con1 = new SqlConnection(strcon))
        {
            DataSet dt = new DataSet();

            using (SqlCommand cmd = new SqlCommand("select * from [user]", con1))
            {
                con1.Open();
                SqlDataAdapter ada = new SqlDataAdapter(cmd);
                ada.Fill(dt);

                DropDownList1.DataSource = dt.Tables[0];
                DropDownList1.DataTextField = "name";
                DropDownList1.DataTextField = "id";
                DropDownList1.DataBind();


                RadioButtonList1.DataSource = dt.Tables[0];
                RadioButtonList1.DataTextField = "stuid";
                RadioButtonList1.DataValueField = "id";
                RadioButtonList1.DataBind();


                CheckBoxList1.DataSource = dt.Tables[0];
                CheckBoxList1.DataTextField = "name";
                CheckBoxList1.DataBind();
            }
        }
    }    //数据集

    protected void Button2_Click(object sender, EventArgs e)
    {
        string strcon = ConfigurationManager.ConnectionStrings["con"].ConnectionString;
        DataTable dt = new DataTable();
        using (SqlConnection con=new SqlConnection(strcon))
        {
            using (SqlCommand cmd=new SqlCommand("select * from [user]",con))
            {
                con.Open();
                using (SqlDataReader myreader=cmd.ExecuteReader())
                {
                    dt.Load(myreader);
  
                }  
            } 
        }
        GridView gv = new GridView();
        gv.DataSource = dt;
        gv.ID = "baining";
        gv.DataBind();
        disp.Controls.Add(gv);
    }    //用DataTable

    protected void Button3_Click(object sender, EventArgs e)
    {
       
        Class1.prove.getname();
        DropDownList1.DataSource =
        DropDownList1.DataSource = "id";
              
    }
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

public partial class Default2 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
       
    }

    protected void Button1_Click(object sender, EventArgs e)
    {
        string strcon = ConfigurationManager.ConnectionStrings["con"].ConnectionString;

        //  string con = "server=.\\sqlexpress;initial catalog=english;integrated security=true";
        using (SqlConnection con1 = new SqlConnection(strcon))
        {
            DataSet dt = new DataSet();

            using (SqlCommand cmd = new SqlCommand("select * from [user]", con1))
            {
                con1.Open();
                SqlDataAdapter ada = new SqlDataAdapter(cmd);
                ada.Fill(dt);

                DropDownList1.DataSource = dt.Tables[0];
                DropDownList1.DataTextField = "name";
                DropDownList1.DataTextField = "id";
                DropDownList1.DataBind();


                RadioButtonList1.DataSource = dt.Tables[0];
                RadioButtonList1.DataTextField = "stuid";
                RadioButtonList1.DataValueField = "id";
                RadioButtonList1.DataBind();


                CheckBoxList1.DataSource = dt.Tables[0];
                CheckBoxList1.DataTextField = "name";
                CheckBoxList1.DataBind();
            }
        }
    }    //数据集

    protected void Button2_Click(object sender, EventArgs e)
    {
        string strcon = ConfigurationManager.ConnectionStrings["con"].ConnectionString;
        DataTable dt = new DataTable();
        using (SqlConnection con=new SqlConnection(strcon))
        {
            using (SqlCommand cmd=new SqlCommand("select * from [user]",con))
            {
                con.Open();
                using (SqlDataReader myreader=cmd.ExecuteReader())
                {
                    dt.Load(myreader);
  
                }  
            } 
        }
        GridView gv = new GridView();
        gv.DataSource = dt;
        gv.ID = "baining";
        gv.DataBind();
        disp.Controls.Add(gv);
    }    //用DataTable

    protected void Button3_Click(object sender, EventArgs e)
    {
       
        Class1.prove.getname();
        DropDownList1.DataSource =
        DropDownList1.DataSource = "id";
              
    }
}