usingSystem.Data.SqlClient;
staticvoidMain(string[] args)
{stringconnString =@"Data Source=.; Initial Catalog=lh0216; User ID=sa;pwd=Founder123";//出了using括号objConnection类会被自动释放using(SqlConnection objConnection =newSqlConnection(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();
}