C语言操作ADO数据库 这些操作是对一个微软Access 2000数据库进行的,但是SQL或是其它 ADO数据源可以通过简单的改变连接字符串来使用.

OleDbConnection myConn=new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\D\DevCs\Works2\Person.mdb;");
myConn.Open();
OleDbDataAdapter thisAdapter= new OleDbDataAdapter("SELECT * FROM Intro",myConn);
OleDbCommandBuilder thisBuilder=new OleDbCommandBuilder(thisAdapter);
DataSet thisDataSet=new DataSet();
thisAdapter.Fill(thisDataSet,"Intro");
Console.WriteLine("Name before change:{0}",thisDataSet.Tables["Intro"].Rows[1]["TheName"]);
thisDataSet.Tables["Intro"].Rows[1]["TheName"]="Acme";//更新
thisAdapter.Update(thisDataSet,"Intro");
Console.WriteLine("Name after change:{0}",thisDataSet.Tables["Intro"].Rows[1]["TheName"]);
myConn.Close();