执行SQL存储脚本

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();

        }