我以前用ASP.NET编写 用的是SQL数据库 代码是这样的
private DataSet myds;
private DataTable mytb;
private SqlDataAdapter myAdapter;
private SqlConnection _SConn;
//private SqlDataAdapter da;
private DataSet dss = new DataSet();
public SqlConnection SConn
{
get { return _SConn; }
set { _SConn = value; }
}
#region 打开关闭连接 Open(),Close()
/// <summary>
/// 打开数据库连接
/// </summary>
public void Open()
{
if (_SConn.State == ConnectionState.Closed)
_SConn.Open();
} /// <summary>
/// 关闭数据库连接
/// </summary>
public void Close()
{
if (_SConn.State == ConnectionState.Open)
{
_SConn.Close();
_SConn.Dispose();
}
}
#endregion而现在我们毕业设计要求用ACCESS数据库,如果我也想做这样个链接该怎么写?对了 首先我的前提是 基于桌面的 ,毕业设计要求写基于桌面的,先谢谢大家了。。,
private DataSet myds;
private DataTable mytb;
private SqlDataAdapter myAdapter;
private SqlConnection _SConn;
//private SqlDataAdapter da;
private DataSet dss = new DataSet();
public SqlConnection SConn
{
get { return _SConn; }
set { _SConn = value; }
}
#region 打开关闭连接 Open(),Close()
/// <summary>
/// 打开数据库连接
/// </summary>
public void Open()
{
if (_SConn.State == ConnectionState.Closed)
_SConn.Open();
} /// <summary>
/// 关闭数据库连接
/// </summary>
public void Close()
{
if (_SConn.State == ConnectionState.Open)
{
_SConn.Close();
_SConn.Dispose();
}
}
#endregion而现在我们毕业设计要求用ACCESS数据库,如果我也想做这样个链接该怎么写?对了 首先我的前提是 基于桌面的 ,毕业设计要求写基于桌面的,先谢谢大家了。。,
string szConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=数据源;Jet OLEDB:Database Password=密码";//创建连接,并打开
OleDbConnection conn = new OleDbConnection(szConnStr);
conn.Open();//执行一个SQL
OleDbCommand cmd = OleDbCommand();
cmd.Connection = conn;
cmd.Execu.......;//关闭连接
conn.Close();
string szConStr = string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0}\\文件名.mdb", Application.StartupPath);
private OleDbDataAdapter myAdapter;
private DataSet myds;
private DataTable mytb;
private DataSet dss = new DataSet();
OleDbConnection _SConn=new OleDbConnection(strConnection);
//这里是相对路径
public OleDbConnection SConn
{ get { return _SConn; }
set { _SConn = value; }
}
#region 打开关闭连接 Open(),Close()
/// <summary>
/// 打开数据库连接
/// </summary>
public void Open()
{
if (_SConn.State == ConnectionState.Closed)
_SConn.Open();
} /// <summary>
/// 关闭数据库连接
/// </summary>
public void Close()
{
if (_SConn.State == ConnectionState.Open)
{
_SConn.Close();
_SConn.Dispose();
}
}
#endregion
我现在这这样写对么?
如果你在Close里把他释放掉了,那么也要修改Open函数:
public void Open()
{
_SConn =new OleDbConnection(strConnection);
if (_SConn.State == ConnectionState.Closed)
_SConn.Open();
}
http://www.cnblogs.com/hownet/archive/2007/11/06/951332.html
http://www.cnblogs.com/jembai/archive/2008/10/29/1322121.html
http://www.cnblogs.com/whitetiger/archive/2007/03/27/689620.html