datagrid

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

private void btnSear_Click(object sender, System.EventArgs e)
		{
			OleDbConnection myConn=new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Environment.CurrentDirectory+"\\QiaoJN.mdb");
			myConn.Open();
			OleDbDataAdapter myAdapter= new OleDbDataAdapter("SELECT XingM,GongZ FROM JianL",myConn);
			OleDbCommandBuilder myBuilder=new OleDbCommandBuilder(myAdapter);
			DataSet myDataSet=new DataSet();
			myAdapter.Fill(myDataSet,"JianL");		
			dataGrid1.DataSource = myDataSet.Tables["JianL"];			
			myConn.Close();		
		}