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

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

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

楼上谢谢！我解决了!

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

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

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