第一次用Access数据库,大家帮忙。
我的链接字符串是:
<add key="DbProviderName" value="System.Data.OleDb"/>
<add key="TaxInvoiceConn" value="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\Tax.accdb;Persist Security Info=True"/>
public static DataSet GetAllTaxPlayer()
{
DbHelper helper=new DbHelper();
DataSet ds=new DataSet();
string sqlStr = "Select TaxID,TaxName,Name,IsImpose,Tax,TradeID,Scope,DistrictID,ManagerID,Phone,Mobile From TaxPlayer"; DbCommand dbCom = helper.GetSqlStringCommond(sqlStr);
try
{
ds = helper.ExecuteDataSet(dbCom);
}
catch (ApplicationException ex)
{
MessageBox.Show(ex.Message);
}
finally
{
}
return ds;
}
private static string dbProviderName = ConfigurationSettings.AppSettings["DbProviderName"];
//private static string dbp = "Provider=System.Data.OleDb";
private static string dbConnectionString = ConfigurationManager.AppSettings["TaxInvoiceConn"]; private DbConnection connection;
public DbHelper()
{
this.connection = CreateConnection(DbHelper.dbConnectionString);
}
public static DbConnection CreateConnection(string connectionString)
{
DbProviderFactory dbfactory = DbProviderFactories.GetFactory(DbHelper.dbProviderName);
DbConnection dbconn = dbfactory.CreateConnection();
dbconn.ConnectionString = connectionString;
return dbconn;
} public DbCommand GetSqlStringCommond(string sqlQuery)
{
DbCommand dbCommand = connection.CreateCommand();
dbCommand.CommandText = sqlQuery;
dbCommand.CommandType = CommandType.Text;
return dbCommand;
} public DataSet ExecuteDataSet(DbCommand cmd)
{
DbProviderFactory dbfactory = DbProviderFactories.GetFactory(DbHelper.dbProviderName);
DbDataAdapter dbDataAdapter = dbfactory.CreateDataAdapter();
dbDataAdapter.SelectCommand = cmd;
DataSet ds = new DataSet();
dbDataAdapter.Fill(ds);
return ds;
}错误:Microsoft Office Access 数据库引擎找不到输入表或查询“TaxPlayer”。请确定它存在且其名称拼写正确。
我的表名是正确的。
我的链接字符串是:
<add key="DbProviderName" value="System.Data.OleDb"/>
<add key="TaxInvoiceConn" value="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\Tax.accdb;Persist Security Info=True"/>
public static DataSet GetAllTaxPlayer()
{
DbHelper helper=new DbHelper();
DataSet ds=new DataSet();
string sqlStr = "Select TaxID,TaxName,Name,IsImpose,Tax,TradeID,Scope,DistrictID,ManagerID,Phone,Mobile From TaxPlayer"; DbCommand dbCom = helper.GetSqlStringCommond(sqlStr);
try
{
ds = helper.ExecuteDataSet(dbCom);
}
catch (ApplicationException ex)
{
MessageBox.Show(ex.Message);
}
finally
{
}
return ds;
}
private static string dbProviderName = ConfigurationSettings.AppSettings["DbProviderName"];
//private static string dbp = "Provider=System.Data.OleDb";
private static string dbConnectionString = ConfigurationManager.AppSettings["TaxInvoiceConn"]; private DbConnection connection;
public DbHelper()
{
this.connection = CreateConnection(DbHelper.dbConnectionString);
}
public static DbConnection CreateConnection(string connectionString)
{
DbProviderFactory dbfactory = DbProviderFactories.GetFactory(DbHelper.dbProviderName);
DbConnection dbconn = dbfactory.CreateConnection();
dbconn.ConnectionString = connectionString;
return dbconn;
} public DbCommand GetSqlStringCommond(string sqlQuery)
{
DbCommand dbCommand = connection.CreateCommand();
dbCommand.CommandText = sqlQuery;
dbCommand.CommandType = CommandType.Text;
return dbCommand;
} public DataSet ExecuteDataSet(DbCommand cmd)
{
DbProviderFactory dbfactory = DbProviderFactories.GetFactory(DbHelper.dbProviderName);
DbDataAdapter dbDataAdapter = dbfactory.CreateDataAdapter();
dbDataAdapter.SelectCommand = cmd;
DataSet ds = new DataSet();
dbDataAdapter.Fill(ds);
return ds;
}错误:Microsoft Office Access 数据库引擎找不到输入表或查询“TaxPlayer”。请确定它存在且其名称拼写正确。
我的表名是正确的。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货