ADO.net

 

数据库连接 SqlConnection

数据适配器 SqlDataAdapter

数据命令 SqlCommand

数据读取器 SqlDataReader

事务处理 SqlTransaction

命令参数 SqlParameter

//SqlDataAdapter

    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            string sql = "select * from TicketCheckSum";
            dataGridView1.DataSource = getTable(sql);
        }

        private DataTable getTable(string sql)
        {
            SqlConnection sqlcom = new SqlConnection("Data Source=.;Initial Catalog=RC_balance;User Id=sa;Password=sqlenterprise");
            sqlcom.Open();

//　　　　sqlcommand cmd = new sqlcommand(sql,sqlcom);

//　　　　sqlDataReader dr =cmd.ExecuteReader();

//　　　　while (dr.Read())

//            {

//　　　　}
            SqlDataAdapter sda=new SqlDataAdapter(sql,sqlcom);
            DataSet ds =new DataSet();
            sda.Fill(ds);
            return ds.Tables[0];
        }
    }