在SqlDataAdapter的select语句中可以用多条语句,在OleDbDataAdapter 中不行,是这样吗?我这里有例子,麻烦来看一下!
string now=System.DateTime.Now.ToString("yyyy-MM-dd");
string sqlstring="select kindid,count(*) as totaltopic from questions group by kindid;";//获得各版块共有多少贴子
sqlstring=sqlstring+"select kindid,count(*) as todaytopic from questions where Convert(varchar(10),ReleaseTime,120)='"+now+"' group by kindid;";
sqlstring=sqlstring+"select kindid,count(*) as todaypost from Answers where Convert(varchar(10),Ans_Time,120 )='"+now+"' group by kindid";
OleDbConnection conn=new OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;Data Source="+System.Web.HttpContext.Current.Server.MapPath("./Data.mdb"));
OleDbDataAdapter da=new OleDbDataAdapter(sqlstring,conn);
DataSet ds=new DataSet();
try
{
conn.Open();
da.Fill(ds);
}
catch(OleDbException ex)
{
Lizheng.Common.JScript.Alert(ex.Message);
}
finally
{
conn.Close();
}
报错:在SQL语句结束之后找到非法字符。