执行SQL存储脚本

using System.Data.SqlClient;
执行SQL存储脚本
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();
        }
执行SQL存储脚本

 

执行SQL存储脚本,布布扣,bubuko.com

执行SQL存储脚本

上一篇:How to Restore File Error 3219 on Microsoft SQL Servers


下一篇:Windows下Java程序实现对Mysql数据库的插入,删除,修改和查询