关于GridView和dataset的应用



  string select = "select row_number() over (order by 主键列),* from AAAA";//用于读取sql中表里面默认的ID序号

//创建连接

            SqlConnection con = new SqlConnection(source);

            SqlDataAdapter adapt = new SqlDataAdapter(select, con);

           
            try
            {
                con.Open();
       
                MessageBox.Show("connection is successful!", "tishi");
            }

            catch (Exception ex)
            {
  
                MessageBox.Show("connection error is :{0}" + ex.ToString(), "tishi");
            }

            //创建DataSet

            DataSet ds = new DataSet();

            //将数据添加到DataSet中
 
            adapt.Fill(ds, "mytest");
      
            //取出mytest表各列名

        
             dataGridView1.DataSource = ds.Tables["mytest"];//读出来的roe-number,在控件中的第一列显示列名为column1，若想改成自己需要的名字，添加下面一行就行了。
             dataGridView1.Columns[0].HeaderText = "ID";
            
             con.Close();
        }