请帮我看看这段代码!
我要将查询的结果在dataGrid中显示,代码如下,但是一直出错,把我都搞糊了,请帮我看一下吧!!
另外,我在窗口里面放了一个dataGrid控件,感觉很不方便,我想在查询出结果后动态显示出来应该怎么做呢?
string myConn1 = " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source =f:\\pic\\boos.mdb" ;
OleDbConnection myConn = new OleDbConnection ( myConn1 ) ;
myConn.Open ( ) ;
string strsql= "SELECT custname,pym,compyname,lxr FROM custinfo WHERE custname= "+ txt_custname.Text +",pym= " + txt_pym.Text +",compyname=" + txt_compyneme.Text +",lxr = " + txt_lxr.Text +"";
OleDbCommand instr = new OleDbCommand (strsql,myConn);
instr.ExecuteNonQuery ();
OleDbDataAdapter da = new OleDbDataAdapter ();
DataSet ds = new DataSet ();
da.Fill (ds,"custinfo");
//DataGrid dg = new DataGrid ();
dataGrid1.DataSource = ds.Tables ["custinfo"].DefaultView ;
//dataGrid1.DataBind();