C#連結SQL Server資料庫

標籤：pwd   div   http   sys   cst   reading   data   ram   資料   

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;
namespace SQLHelper {
class Program {
static void Main(string[] args) {
string con;
//Window身分識別驗證
//con = "Server=DESKTOP-SIKEISM\\SQLEXPRESS;Database=MusicStore;Trusted_Connection=SSPI";
//SQL Server身分識別驗證
con = "Server=DESKTOP-SIKEISM\\SQLEXPRESS;Database=MusicStore;uid=sa;pwd=123456";
SqlConnection mycon = new SqlConnection(con);
try {
mycon.Open();
Console.WriteLine("Success!");
} catch (SqlException ex) {
Console.WriteLine("Fail!" + ex.Message);
}
}
}
}
 

null

C#連結SQL Server資料庫