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);             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]);         }     } }