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();