Gridview用法之数据库绑定

最新推荐文章于 2022-10-12 10:03:28 发布

原创最新推荐文章于 2022-10-12 10:03:28 发布 · 520 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#数据库 #textbox #sql #string #dataset #security

ASP.NET 专栏收录该内容

8 篇文章

订阅专栏

本文介绍了一个使用ASP.NET进行数据库查询的过程，并展示了如何根据不同的输入条件查询数据库并更新GridView控件显示的数据。通过重构代码提高了可读性和可维护性。

protected void Button1_Click(object sender, EventArgs e)
    {


        if (TextBox1.Text == "" && TextBox2.Text == "")
        {
            Response.Write("<script>alert('请输入查询条件')</script>");
        }
        if (TextBox1.Text != "" && TextBox2.Text == "")
        {
            string sql = "server=183461326A124C6;database=ms;integrated Security=SSPI;";
            string sql1 = "SELECT [Dno], [Dname], [Dmanager], [Dintroduction] FROM [ms].[dbo].[Depart] where [Dno]='"+TextBox1.Text.ToString()+"'";
            databind(sql, sql1);
        }
        if (TextBox1.Text == "" && TextBox2.Text != "")
        {
            string sql = "server=183461326A124C6;database=ms;integrated Security=SSPI;";
            string sql1 = "SELECT [Dno], [Dname], [Dmanager], [Dintroduction] FROM [ms].[dbo].[Depart] where [Dname]='"+TextBox2.Text.ToString()+"'";
            databind(sql, sql1);
        }
        if(TextBox1.Text!=""&&TextBox2.Text!="")
        {
            string sql = "server=183461326A124C6;database=ms;integrated Security=SSPI;";
            string sql1 = "SELECT [Dno], [Dname], [Dmanager], [Dintroduction] FROM [ms].[dbo].[Depart] where [Dno]='"+TextBox1.Text.ToString()+"' and [Dname]='"+TextBox2.Text.ToString()+"'";
            databind(sql, sql1);
        }
    }

//重构成databind方法

    private void databind(string sql, string sql1)
    {
        SqlConnection con = new SqlConnection(sql);
        con.Open();
        SqlDataAdapter sdap = new SqlDataAdapter(sql1, con);
        DataSet ds = new DataSet();
        sdap.Fill(ds, "table");
        GridView2.DataSource = ds.Tables[0];
        GridView2.DataBind();