gridview列出搜索结果的问题

zmidl 发布于 2010-05-08 12:10， 1021 次点击

protected void Button1_Click(object sender, EventArgs e)
    {
        SqlConnection conn = new SqlConnection(strConn);
        conn.Open();
        string str = "select count(*) from chanpin where guige ='" + TextBox2.Text + "'";
        SqlCommand cmd = new SqlCommand(str, conn);
        SqlDataAdapter sda = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        sda.Fill(ds);
        gridview1.DataSource = ds;
        gridview1.DataBind();
        conn.Close();
    }
以上是我的代码，但是实现的效果却是：
Column1
   0

不知道到底哪里出错了？？

5 回复

等待冰柠檬2010-05-08 13:28

程序代码：

        SqlConnection conn = new SqlConnection(strConn);
        conn.Open();
        string str = "select * from chanpin where guige ='" + TextBox2.Text.Trim() + "'";
        SqlCommand cmd = new SqlCommand(str, conn);
        SqlDataAdapter sda = new SqlDataAdapter(cmd);
        DataTable ds = new DataTable();
        sda.Fill(ds);
        gridview1.DataSource = ds;
        gridview1.DataBind();
        conn.Close();

zmidl2010-05-08 15:11

楼上谢谢！我解决了!

zongshi1232010-05-12 21:53

程序代码：

protected void Button1_Click(object sender, EventArgs e)
    {
        SqlConnection conn = new SqlConnection(strConn);
        conn.Open();
        string str = "select count(*) from chanpin where guige ='" + TextBox2.Text + "'";
        SqlCommand cmd = new SqlCommand(str, conn);
        SqlDataAdapter sda = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        sda.Fill(ds,"chanpin");
        gridview1.DataSource = ds.Tables["chanpin"];
        gridview1.DataBind();
        conn.Close();
    }

源本英明C2010-05-15 10:27

看了大家的帖子，感觉自己真是个菜鸟！

源本英明C2010-05-15 10:29

不知何时，才能有各位这样的造诣。不过我相信名师出高徒