006_.Net DB link

public DB()
 {
  //
  // TODO: 在此处添加构造函数逻辑
  //
 }
    public static OleDbConnection createConnection()
    {
        string MyConnString = "Provider=Microsoft.Jet.OLEDB.4.0;";     

        MyConnString += @"Data Source=d:\JobPassword_DB\JobPassword.mdb";

        OleDbConnection con = new OleDbConnection(MyConnString);
        return con;
    }

//*******************************Server.MapPath****用法
   OleDbConnection conn;//声明一个OledbConnection对象
            conn=new OleDbConnection();//建立一个oledbConnection对象
            //设定连接字符串ConnectionString
            conn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;"
    +"Data Source=" + Server.MapPath("user.mdb");
            conn.Open();

//*******************************
    public static OleDbConnection createConnectionOra()
    {
        string MyConnString = "provider=oraoledb.oracle;Data Source=hs01;user id=system;password=manager;";
        OleDbConnection con = new OleDbConnection(MyConnString);
        return con;
    }

posted on 2009-03-07 14:35  shao  阅读(60)  评论(0)    收藏  举报

导航