为什么ASP.NET连接ACCESS数据库时出现"未指定的错误"?
大呆米 2012-11-21 01:18:02 using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.OleDb;
using System.Configuration;
namespace DAL
{
public class DBHelper
{
static readonly string conStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\\Programming\\C#\\ASP.NET_Access\\Wed\\App_Data\\HD.mdb;Persist Security Info=True";
/// <summary>
/// 创建command对象
/// </summary>
/// <param name="sql"></param>
/// <param name="oleParas"></param>
/// <returns></returns>
public static OleDbCommand BuildCommand(string sql, params OleDbParameter[] oleParas)
{
OleDbConnection oleConn = new OleDbConnection(conStr);
OleDbCommand oleComm = new OleDbCommand(sql, oleConn);
oleComm.Parameters.AddRange(oleParas);
oleComm.CommandType = CommandType.Text;
return oleComm;
}
/// <summary>
/// 返回所影响的行数,增删改
/// </summary>
/// <param name="sql"></param>
/// <param name="oleParas"></param>
/// <returns></returns>
public static int ExecuteNonQuery(string sql, params OleDbParameter[] oleParas)
{
int result = 0;
OleDbCommand oleComm = BuildCommand(sql, oleParas);
oleComm.Connection.Open();
result = oleComm.ExecuteNonQuery();
oleComm.Connection.Close();
return result;
}
/// <summary>
/// 返回第一行的第一列,查,使用count(*)得到数量
/// </summary>
/// <param name="sql"></param>
/// <param name="oleParas"></param>
/// <returns></returns>
public static object ExecuteScalar(string sql, params OleDbParameter[] oleParas)
{
object result = null;
OleDbCommand oleComm = BuildCommand(sql, oleParas);
oleComm.Connection.Open();
result = oleComm.ExecuteScalar();
oleComm.Connection.Close();
return result;
}
/// <summary>
/// 返回OleDbDataReader对象
/// </summary>
/// <param name="sql"></param>
/// <param name="oleParas"></param>
/// <returns></returns>
public static OleDbDataReader OleDataReader(string sql, params OleDbParameter[] oleParas)
{
OleDbDataReader result = null;
OleDbCommand oleComm = BuildCommand(sql, oleParas);
oleComm.Connection.Open();
result = oleComm.ExecuteReader(CommandBehavior.CloseConnection);
return result;
}
/// <summary>
/// 返回DataSet对象
/// 传入一个DataSet对象,填充它
/// </summary>
/// <param name="sql"></param>
/// <param name="oleParas"></param>
/// <returns></returns>
public static DataSet ExecuteDataSet(string sql, DataSet myDataSet, params OleDbParameter[] oleParas)
{
//DataSet result = new DataSet();
OleDbDataAdapter sda = new OleDbDataAdapter(BuildCommand(sql, oleParas));
sda.Fill(myDataSet);
return myDataSet;
}
}
}