11-15两种连接数据库的方法

来源：互联网发布：淘宝买止咳水的暗语编辑：程序博客网时间：2024/06/05 10:36

//连接Access
            //---------------------用OleDbConnection连接数据库
            //string Oconstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=="+ Server.MapPath("~/") + "\\test.mdb";
            //OleDbConnection conn = new OleDbConnection();
            //conn.ConnectionString = Oconstr;//"provider=sqloledb.1;Data Source=PC-20120604KNHD;Initial Catalog=MyTest;User ID=sa;Password=910809";
            //conn.Open();
            //this.Response.Write(conn .State .ToString ());
            //conn.Close();
            //this.Response.Write(conn.State.ToString());

            //----------------用OleDbConnection连接Sql数据库
            string Oconstr1 = "provider=sqloledb.1;Data Source=PC-20120604KNHD;Initial Catalog=MyTest;User ID=sa;Password=910809";
            OleDbConnection conn1 = new OleDbConnection();
            conn1.ConnectionString = Oconstr1;//"provider=sqloledb.1;Data Source=PC-20120604KNHD;Initial Catalog=MyTest;User ID=sa;Password=910809";
            conn1.Open();
            this.Response.Write(conn1.State.ToString());
            conn1.Close();
            this.Response.Write(conn1.State.ToString());
        }

        //---------------------------用SqlConnection连接数据库
        protected void Button1_Click(object sender, EventArgs e)
        {
            string constr = "Data Source=.;Initial Catalog=MyTest;Persist Security Info=True;User ID=sa;Password=910809";
            //string constr = "Data Source=PC-20120604KNHD;Initial Catalog=MyTest;Integrated Security=sspi";
            SqlConnection conn = new SqlConnection();
            conn.ConnectionString = constr;
            conn.Open();
            this.Response.Write("open ");
            conn.Close();
            this.Response.Write("close");

}