我用的 access小数据库!!!有这么一条查询;
select sum(FenShu) as s,92 as t from User where UserID like '*92*'在数据库中直接查询都没有问题;但是在程序中查询时候,查处的结果是“”
程序是(我想应该没问题): cmdText=@"select sum(FenShu) as s,92 as t from User where UserID like '*92*'";
OleDbConnection dbConn=DBConnection.CreateInstance();
OleDbCommand dbCmd=new OleDbCommand(cmdText, dbConn);
dbConn.Open();
try
{
OleDbDataReader odr=dbCmd.ExecuteReader();
if(odr.Read())
{
reValue=odr.GetValue(0).ToString();//这里查出来的是空值
}
select sum(FenShu) as s,92 as t from User where UserID like '*92*'在数据库中直接查询都没有问题;但是在程序中查询时候,查处的结果是“”
程序是(我想应该没问题): cmdText=@"select sum(FenShu) as s,92 as t from User where UserID like '*92*'";
OleDbConnection dbConn=DBConnection.CreateInstance();
OleDbCommand dbCmd=new OleDbCommand(cmdText, dbConn);
dbConn.Open();
try
{
OleDbDataReader odr=dbCmd.ExecuteReader();
if(odr.Read())
{
reValue=odr.GetValue(0).ToString();//这里查出来的是空值
}
原因不在这里!
改用dataset吧。