DataSet的填充

 

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

using System.Data.SqlClient;

using System.Configuration;

 

namespace 数据库读取数据填充到DataSet

{

    public partial class Form1 : Form

    {

        public Form1()

        {

            InitializeComponent();

        }

 

        private void button1_Click(object sender, EventArgs e)

        {

            string connString = ConfigurationManager.AppSettings["conString"];

            string sql = "select * from TbStudent";

            //其实SqlDataAdapter在内部自动帮我们封装了SqlConnection和SQLCommand

            SqlDataAdapter adapter = new SqlDataAdapter(sql, connString);

            //DataSet ds = new DataSet();

            //adapter.Fill(ds);//填充

            DataTable dt=new DataTable();

            adapter.Fill(0, 1,dt);//分页,只能填充DataTable，不能给DataSet

            //这个分页是假分页，不是真的

            //数据绑定

           // dataGridView1.DataSource = ds.Tables[0];

            dataGridView1.DataSource = dt;

           

        }

 

        private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)

        {

 

        }

    }

}