我用SQL 2005时还好用 换ACCESS就出现这问题了
程序如下:
public Test()
{
s = ConfigurationManager.ConnectionStrings["DatabaseConnection"].ConnectionString;
str = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
ds = new DataSet();
} public DataSet ShowA()
{
using (System.Data.OleDb.OleDbConnection con = new System.Data.OleDb.OleDbConnection(str))
{
using (System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand())
{
cmd.CommandText = "SELECT a.*,b.* FROM Survey AS A,Surveyitem AS B where A.SurveyID=B.ParrentID and A.ShowID=1";
cmd.Connection = con;
using (System.Data.OleDb.OleDbDataAdapter dp = new System.Data.OleDb.OleDbDataAdapter(cmd))
{
dp.Fill(ds);
return ds;
}
}
}
}
程序如下:
public Test()
{
s = ConfigurationManager.ConnectionStrings["DatabaseConnection"].ConnectionString;
str = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
ds = new DataSet();
} public DataSet ShowA()
{
using (System.Data.OleDb.OleDbConnection con = new System.Data.OleDb.OleDbConnection(str))
{
using (System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand())
{
cmd.CommandText = "SELECT a.*,b.* FROM Survey AS A,Surveyitem AS B where A.SurveyID=B.ParrentID and A.ShowID=1";
cmd.Connection = con;
using (System.Data.OleDb.OleDbDataAdapter dp = new System.Data.OleDb.OleDbDataAdapter(cmd))
{
dp.Fill(ds);
return ds;
}
}
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货