c#連接配接資料庫MS SQL Server

c#連接配接資料庫MS SQL Server

方法一：

可以利用SqlConnectionStringBuilder，這樣不必去記住名稱。

using System.Data.Sql;

using System.Data.SqlClient;

    SqlConnectionStringBuilder scsb = new SqlConnectionStringBuilder();

    scsb.DataSource = @"(local)\SQLExpress";

    //scsb.DataSource = @"192.168.2.200";//如果連接配接專用SQL伺服器,則輸入IP位址

    scsb.IntegratedSecurity = false;

    scsb.InitialCatalog = "ERP"; //資料庫名 

    scsb.UserID = "sa";

    scsb.Password = "Aaz1397";

    SqlConnection myConnection = new SqlConnection(scsb.ConnectionString);

方法二：

using System.Data.Sql;

using System.Data.SqlClient;

DataTable dt = new DataTable();

string con = "Server = (local)\\SQLEXPRESS;database = ERP;user = sa;pwd = Aaz1397;Initial Catalog=pcmis;";//本地資料庫伺服器

string str1 = string.Empty;

str1 = string.Format("SELECT [UserId] as 帳号 ,[Processing] as 制程 FROM [dbo].[Authority_MU]  where  1=2");

SqlConnection conn = new SqlConnection(con);

SqlDataAdapter adapter = new SqlDataAdapter();

conn.Open();

adapter.SelectCommand = new SqlCommand(str1, conn);

string con = "user=sa;pwd=Aaz1397;database=ERP;server=(local)\\SQLEXPRESS";(連接配接SQL Express,非Server版,并且使用雙反斜線\\)

string con = "user=sa;pwd=Aaz1397;database=ERP;server=.";(連接配接本地SQL Server版,用.即可)

string con = "user=sa;pwd=Aaz1397;database=ERP;server=192.168.2.200";(連接配接公司專用SQL Server伺服器,用IP位址)