绑定数据源 dgv 1207

119 阅读1分钟

        private void Form1_Load(object sender, EventArgs e)
        {
            // 连接对象
            String connString = "Data Source=.;Initial Catalog=dbok;Persist Security Info=True;User ID=sa;Password=root123123";
            SqlConnection conn = new SqlConnection(connString);

            // 小车对象
            String sql = "select * from sanguo";
            SqlDataAdapter adapter = new SqlDataAdapter(sql,conn);

            // 数据集对象
            DataSet ds = new DataSet();

            // 小车卸货
            adapter.Fill(ds,"hero");

            // 控件绑定数据源
            dataGridView1.DataSource = ds.Tables["hero"];
        }