private void button3_Click(object sender, EventArgs e)
        {
            string connString = "Data Source=.\\SQLSERVER;Initial Catalog=Record;User ID=sa;pwd=123;";
            SqlConnection conn = new SqlConnection(connString);
            string sql = "select * from operation where name = '" + label5.Text.Trim() + "'";
            conn.Open();


        }

我才学C# 很多不懂，我上面是查询按钮的，我读出的数据想赋值给表格 dataGridView1 不知道怎么写，请各位帮忙指教下！

[ 本帖最后由 lovellq39 于 2011-2-18 11:17 编辑 ]

请各位多多帮忙

没人能帮忙吗~？？？？

你这样写 只是打开连接了 并没有读取数据啊 所以你要显示什么呀？？？？？

比如：public static DataSet selectshuju()
        {
            SqlConnection conn = new SqlConnection("server=.;uid=sa;pwd=sa;database=test");
            SqlCommand comm = new SqlCommand("select parentid,id,mycontent from testtable", conn);
            SqlDataAdapter da = new SqlDataAdapter();
            da.SelectCommand = comm;
            DataSet ds= new DataSet();
            da.Fill(ds);
            return ds;
        }

希望以上对你有所帮助 ，我也不太懂，但学过一段时间了，呵呵

你那只是打开链接,还需要给他绑定一个数据源!

private void button3_Click(object sender, EventArgs e)
        {
            string connString = "Data Source=.\\SQLSERVER;Initial Catalog=Record;User ID=sa;pwd=123;";
            SqlConnection conn = new SqlConnection(connString);
            string sql = "select * from operation where name = '" + label5.Text.Trim() + "'";
            conn.Open();

            SqlDataAdapter da = new SqlDataAdapter(sql ,conn);
            DataSet ds= new DataSet();
            da.fill(ds);
            GridView1.DataSource = ds.Tables[0];
            GridView1.DataBind();
        }