asp.net中串連各種資料庫字串串連程式(mysql/mssql/access)(1/2)

MSSQL連接字串

（1）OLEDB
Windows 身分識別驗證

代碼如下	複製代碼
"Provider=SQLOLEDB;Data Source=PEK7-6TKX23XSQLEXPRESS;Initial Catalog=Test;Trusted_Connection=Yes;"; SQL Server 身分識別驗證 "Provider=SQLOLEDB;Data Source=127.0.0.1SQLEXPRESS;Initial Catalog=Test;User Id=sa;Password=123456;";

（2）SqlConnection
Windows 身分識別驗證

代碼如下	複製代碼
"Data Source=PEK7-6TKX23XSQLEXPRESS;Initial Catalog=Test;Trusted_Connection=Yes;"; SQL Server 身分識別驗證 "server=127.0.0.1SQLEXPRESS;database=Test;Uid=sa;PassWord=123456";

（3）ODBC

代碼如下	複製代碼
Driver={SQL Server}; Server=伺服器IP; Database=資料庫名; Uid=使用者名稱; Pwd=密碼;

（4）DSN方式

代碼如下	複製代碼
DSN=DSN名; Uid=使用者名稱; Pwd=密碼;

 

例：mysql樣本

代碼如下

複製代碼

using System; using System.Collections.Generic; using System.Data; using System.Data.Common; using System.Linq; using System.Text; using System.Data.OleDb; using System.Data.SqlClient; using System.Data.Sql; namespace ado {     public class ConnectionDemo1     {         public void GetOleDbTable()         {             #region namespace             //using System.Data.OleDb;             #endregion             #region OLEDB Access             //OLEDB             //C#串連Access的方式             //Access 2003   Provider=Microsoft.Jet.OLEDB.4.0             //Access 2007   Provider=Microsoft.Ace.OleDb.12.0             //(1)無資料庫密碼，無使用者密碼，共用方式開啟             //"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:qjx文檔GenericDemoDataStudent.accdb;"             //(2)有資料庫密碼，沒有使用者密碼,這種方式以獨佔方式開啟             //"Provider=Microsoft.Jet.OleDB.4.0;Data Source=D:qjx文檔GenericDemoDataStudent.accdb;Jet OleDb:DataBase Password=123"             //(3)有資料庫密碼，有使用者密碼 可以用該方法,但使用者密碼處就算設有密碼也必須為空白，這種方式以獨佔方式開啟             //"Provider=Microsoft.Jet.OleDB.4.0;Data Source=D:qjx文檔GenericDemoDataStudent.accdb;Jet OleDb:DataBase Password=12345;Persist Security Info=true;password=;user id=Admin"             #endregion             #region OLEDB MSSQL             //OLEDB             //C#串連MSSQL的方式             //Windows 身分識別驗證             //"Provider=SQLOLEDB;Data Source=PEK7-6TKX23XSQLEXPRESS;Initial Catalog=Test;Trusted_Connection=Yes;";             //SQL Server 身分識別驗證             //"Provider=SQLOLEDB;Data Source=127.0.0.1SQLEXPRESS;Initial Catalog=Test;User Id=sa;Password=123456;";             #endregion             #region OLEDB Oracle             //OLEDB             //C#串連Oracle的方式             //"Provider=MSDAORA;Data Source=MyDatabaseAlias;User ID=MyUID;Password=MyPassword";             #endregion             //string strConn = @"Provider=Microsoft.Ace.OleDb.12.0;Data Source=D:qjx文檔GenericDemoDataStudent.accdb;Jet OleDb:DataBase Password=123";//Access 2007             string strConn =                 @"Provider=SQLOLEDB;Data Source=127.0.0.1SQLEXPRESS;Initial Catalog=Test;User Id=sa;Password=123456;";             OleDbConnection conn = new OleDbConnection(strConn);             OleDbCommand comm = new OleDbCommand();             comm.CommandText = "SELECT * FROM Users";             comm.CommandType = CommandType.Text;             comm.Connection = conn;             if (conn.State != ConnectionState.Open)             {                 conn.Open();                 DataSet ds = new DataSet();                 OleDbDataAdapter da = new OleDbDataAdapter(comm);                 da.Fill(ds);                 conn.Close();             }         }         public void GetSqlConnectionTable()         {             #region namespace             //using System.Data.SqlClient;             #endregion             #region MSSQL SqlConnection             //SqlConnection             //C#串連MSSQL的方式             //Windows 身分識別驗證             //"Data Source=PEK7-6TKX23XSQLEXPRESS;Initial Catalog=Test;Trusted_Connection=Yes;";             //SQL Server 身分識別驗證             //"server=127.0.0.1SQLEXPRESS;database=Test;Uid=sa;PassWord=123456";             #endregion             //string strConn = @"server=127.0.0.1SQLEXPRESS;database=Test;Uid=sa;PassWord=123456";             string strConn = @"Data Source=PEK7-6TKX23XSQLEXPRESS;Initial Catalog=Test;Trusted_Connection=Yes;";                         SqlConnection conn = new SqlConnection(strConn);             SqlCommand comm = new SqlCommand();             comm.CommandText = "SELECT * FROM Users";             comm.CommandType = CommandType.Text;             comm.Connection = conn;             if(conn.State!=ConnectionState.Open)             {                 conn.Open();                 DataSet ds = new DataSet();                 SqlDataAdapter da = new SqlDataAdapter(comm);                 da.Fill(ds);                 conn.Close();             }         }     } }

首頁 1 2 末頁