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(); }
新闻热点
疑难解答