OleDbDataAdapter 具体使用案例



using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.OleDb;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

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

        OleDbDataAdapter ad;
        DataSet ds;
        public void fanfa() {
            //string connectString = "Data Source=localhost;Initial Catalog=MytestDB;Integrated Security=SSPI";
            //SqlConnection sqlConnect = new SqlConnection(connectString);
            string connectString = @"File Name=D:\VS2015Programming\MyTest\TestUDL\TextFile1.udl;";
            OleDbConnection conn = new OleDbConnection(connectString);
            conn.Open();
            OleDbCommand sqlCommand = conn.CreateCommand();
            string sqlCommandText = "SELECT [ID],[Name] FROM[MytestDB].[dbo].[PersonTable]";
            sqlCommand.CommandText = sqlCommandText;
            //OleDbDataReader sqlDataReader = sqlCommand.ExecuteReader();
            ad = new OleDbDataAdapter(sqlCommand);

            //重要的数据更新操作，下面的OleDbDataAdapterUpdate会用到，可以自懂执行数据库操作
            OleDbCommandBuilder bb = new OleDbCommandBuilder(ad);
            ad.UpdateCommand = bb.GetUpdateCommand();
            ad.InsertCommand = bb.GetInsertCommand();
            ad.DeleteCommand = bb.GetDeleteCommand();
             ds = new DataSet();
            ad.Fill(ds);
        }
        private void button1_Click(object sender, EventArgs e)
        {
            string connectString = "Data Source=localhost;Initial Catalog=MytestDB;Integrated Security=SSPI";
            SqlConnection sqlConnect = new SqlConnection(connectString);
            //string connectString = @"File Name=D:\VS2015Programming\MyTest\TestUDL\TextFile1.udl;";
            //OleDbConnection conn = new OleDbConnection(connectString);
            //conn.Open();
            //OleDbCommand sqlCommand = conn.CreateCommand();
            //string sqlCommandText = "SELECT [ID],[Name] FROM[MytestDB].[dbo].[PersonTable]";
            //sqlCommand.CommandText = sqlCommandText;
            OleDbDataReader sqlDataReader = sqlCommand.ExecuteReader();
            //OleDbDataAdapter ad = new OleDbDataAdapter(sqlCommand);
            //DataSet ds = new DataSet();
            //ad.Fill(ds);
            fanfa();
            this.dataGridView1.DataSource = ds.Tables[0];
        }

        private void button2_Click(object sender, EventArgs e)
        {
            DataTableCollection ss = ds.Tables;
            //ds.Tables[0].Rows[5].RowState = DataRowState.Added;
            this.ad.Update(ds.Tables[0]);
        }
    }
}