string sqlText3 = "SELECT glj.工料机编号,glj.工料机名称,glj.单位,glj.规格,glj.类型,price.供应价,price.预算价,price.市场价,price.询价日期,price.供应商 FROM glj,price WHERE price.价格文件编号 = "+PriceFileId+" AND price.工料机编号 = glj.工料机编号";
OleDbCommand Comm = connGongLJ.CreateCommand();
Comm.CommandText = sqlText3;
OleDbDataAdapter DAdaper = new OleDbDataAdapter();
DAdaper.SelectCommand = Comm;
DataSet ds = new DataSet();
DAdaper.Fill(ds,"table1");
DataTable dt = new DataTable();
dt = ds.Tables["table1"];