Common的Class1.cs
using System;
using System.Collections.Generic;
using System.Text;
namespace Common
{
public class Class1
{
public const string ConnectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D://db//xxxx.mdb;Jet OLEDB:Database Password=password";
}
}
Dataaccess的Class1.cs
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.OleDb;
namespace DataAccess
{
public class Class1
{
OleDbConnection cn = new OleDbConnection(Common.Class1.ConnectString);
public void ExecuteSql(string sql)
{
OleDbCommand cmd = new OleDbCommand(sql,cn);
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
}
}
}
将Common点右键"生成"即可生成Common.dll。
在和DataAccess类库里面引用Common.dll然后再生成DataAccess.dll
在其他的项目中就可以引用DataAccess.dll了。
引用方法:
DataAccess.Class1 dac= new DataAccess.Class1();
string sql = "insert into xxxxxxxxxxxxxxxxxxxxxxxxxxxx";
dac.ExecuteSql(sql);