///access 数据库
<appSettings>
<add key="conn" value="Provider=Microsoft.Jet.OleDb.4.0; Data Source="/>
<add key="dbPath" value="~/App_Data/jhtest.mdb"/>
</appSettings>
// 说明:GetDataSet数据集,返回数据源的数据集
//返回值:数据集DataSet
//参数:strsql SQL字符串,TableName 数据表名称
public System.Data.DataSet GetOleDataSet(string strsql, string tableName)
{
string strConn = System.Configuration.ConfigurationManager.AppSettings["conn"].ToString() + System.Web.HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["dbPath"]) + ";";
System.Data.OleDb.OleDbConnection OleDbConn = new OleDbConnection(strConn);
OleDbConn.Open();
OleDbDataAdapter dbAdapter = new OleDbDataAdapter(strsql, OleDbConn);
DataSet ds = new DataSet();
dbAdapter.Fill(ds, tableName);
OleDbConn.Close();
return ds;
}
///sql 数据库
<connectionStrings>
<add name="conn" providerName="System.Data.SqlClient" connectionString="server=. ; database = Northwind; uid = sa; pwd=sa"/>
</connectionStrings>
// 说明:GetDataSet数据集,返回数据源的数据集
//返回值:数据集DataSet
//参数:strsql SQL字符串,TableName 数据表名称
public System.Data.DataSet GetSqlDataSet(string strsql, string tableName)
{
string strConn = System.Configuration.ConfigurationManager.ConnectionStrings["sqlconn"].ConnectionString;
SqlConnection sqlC = new SqlConnection(strConn);
sqlC.Open();
SqlDataAdapter dbAdapter = new SqlDataAdapter(strsql, sqlC);
DataSet ds = new DataSet();
dbAdapter.Fill(ds, tableName);
sqlC.Close();
return ds;
}
///后台调用即可
///dbConn 为类文件名
dbConn dgC = new dbConn();
Repeater3.DataSource = dgC.GetOleDataSet("select * from new", "new");
Repeater3.DataBind();