首页 > 代码库 > 执行SQL存储脚本

执行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();
        }