using System.Data.SqlClient;
static void Main(string[] args) { string connString = @"Data Source=.; Initial Catalog=lh0216; User ID=sa;pwd=Founder123"; //出了using括號objConnection類會被自動釋放 using (SqlConnection objConnection = new SqlConnection(connString)) { objConnection.Open(); Console.WriteLine("數據庫連接成功。"); using (SqlCommand objCmd = objConnection.CreateCommand()) { objCmd.CommandText = "INSERT INTO tbID(strName,strCname,iMax ) VALUES ('aaa','測試',1)"; objCmd.ExecuteNonQuery(); Console.WriteLine("插入數據成功。"); } } Console.ReadKey(); }
新聞熱點
疑難解答