SQL语句如下:
select a.*,b.AName from MWell_TBS_Product a,MWell_TBS_Area b where a.AID = b.AID and ( a.PName like '*" + strSch + "*' or a.PMemo like '*" + strSch + "*')and a.CID in ( select CID from MWell_TBS_Catalog where CPID="+iCID +" )"
在Access的查询分析器中可以查询出结果,可是在
public DataTable GetDataTable(string strSQL)
{
string strConnection = "Provider=Microsoft.Jet.OLEDB.4.0; " +
"Data Source=" + HttpContext.Current.Server.MapPath(strDataPath);
string strCommandText =strSQL; OleDbConnection myConnection = new OleDbConnection(strConnection);
myConnection.Open();
OleDbDataAdapter myAdpater = new OleDbDataAdapter(strSQL,myConnection);
OleDbCommandBuilder myBuilder = new OleDbCommandBuilder(myAdpater);
DataSet myDataset = new DataSet();
myAdpater.Fill(myDataset);
DataTable mytable = myDataset.Tables[0];
myConnection.Close();
return mytable;
}
这种方式下传入SQL,查询得到的结果却是空的,为什么???希望大家指点指点?
select a.*,b.AName from MWell_TBS_Product a,MWell_TBS_Area b where a.AID = b.AID and ( a.PName like '*" + strSch + "*' or a.PMemo like '*" + strSch + "*')and a.CID in ( select CID from MWell_TBS_Catalog where CPID="+iCID +" )"
在Access的查询分析器中可以查询出结果,可是在
public DataTable GetDataTable(string strSQL)
{
string strConnection = "Provider=Microsoft.Jet.OLEDB.4.0; " +
"Data Source=" + HttpContext.Current.Server.MapPath(strDataPath);
string strCommandText =strSQL; OleDbConnection myConnection = new OleDbConnection(strConnection);
myConnection.Open();
OleDbDataAdapter myAdpater = new OleDbDataAdapter(strSQL,myConnection);
OleDbCommandBuilder myBuilder = new OleDbCommandBuilder(myAdpater);
DataSet myDataset = new DataSet();
myAdpater.Fill(myDataset);
DataTable mytable = myDataset.Tables[0];
myConnection.Close();
return mytable;
}
这种方式下传入SQL,查询得到的结果却是空的,为什么???希望大家指点指点?
select a.*,b.AName from MWell_TBS_Product a,MWell_TBS_Area b where a.AID = b.AID and ( a.PName like '%" + strSch + "%' or a.PMemo like '%" + strSch + "%')and a.CID in ( select CID from MWell_TBS_Catalog where CPID="+iCID +" )"
oldmoon(浪者) : ds结果中没有数据测试过了,但是在查询中可以查到数据