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

using System.Data;
using System.Data.OleDb;
OleDbConnection myConn=new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Application.StartupPath+"\\First.mdb;");
				myConn.Open();
				//建立数据集
				DataSet thisDataSet=new DataSet();
				//建立适配器
				OleDbDataAdapter studentAdapter= new OleDbDataAdapter("SELECT * FROM Student",myConn);
				OleDbCommandBuilder studentBuilder=new OleDbCommandBuilder(studentAdapter);
				
				OleDbDataAdapter teacherAdapter= new OleDbDataAdapter("SELECT * FROM Teacher",myConn);
				OleDbCommandBuilder teacherBuilder=new OleDbCommandBuilder(teacherAdapter);
				
				OleDbDataAdapter genearchAdapter= new OleDbDataAdapter("SELECT * FROM Genearch",myConn);
				OleDbCommandBuilder genearchBuilder=new OleDbCommandBuilder(genearchAdapter);

								//填充
				studentAdapter.Fill(thisDataSet,"Student");
				teacherAdapter.Fill(thisDataSet,"Teacher");
				genearchAdapter.Fill(thisDataSet,"Genearch");
								myConn.Close();