执行sql语句



using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace _03执行一条Sql语句
{
    class Program
    {
        static void Main(string[] args)
        {
            string connStr = @"server=.;database=MySecondDB;uid=sa;password=520;";

            string sql = "insert into [dbo].[loginTest](userId, [password], lastLoginTime) values ('张东来','happyZhang','2016-11-5 18:54:43.345');";
            // 创建连接对象
            SqlConnection conn = new SqlConnection(connStr);

            // 创建执行对象
            SqlCommand cmd = new SqlCommand(sql, conn);

            // 打开
            conn.Open();

            // 开始执行
            int count = cmd.ExecuteNonQuery();
            conn.Dispose();
            cmd.Dispose();

            Console.WriteLine("({0}行受影响)", count);
            Console.ReadKey();
        }
    }
}