datagrid中显示查询后的数据.txt

来自「c#的知识类库」· 文本 代码 · 共 11 行

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