#region 01连接对象

           //01 连接字符串

            string connstr = "server=.;uid=sa;pwd=sa;database=DemoDB;";

            SqlConnection conn = new SqlConnection(connstr);

            conn.Open();

            //02 创建sql命令对象

            SqlCommand cmd = new SqlCommand();

            //0201-通过属性 指定连接对象

            cmd.Connection = conn;

            cmd.CommandText = "insert into UserInfo (EmpId, StuName, StuAge, Delflag, ClassNo) values (12,'张三',23,0,1)";

            Console.WriteLine("受影响行数{0}",  cmd.ExecuteNonQuery());

            conn.Close();

            #endregion

using System;

using System.Collections.Generic;

using System.Data.SqlClient;

using System.Linq;

using System.Text;

using System.Threading;

using System.Threading.Tasks;

namespace ADO.NET

{

    class Program

    {

        static void Main(string[] args)

        {

            #region 01连接对象

           //01 连接字符串

            string connstr = "Data Source=127.0.0.1;uid=sa;pwd=sa;Initial Catalog=DemoDB;";

            using ( SqlConnection conn = new SqlConnection(connstr))

            {

                using (SqlCommand cmd = new SqlCommand())

                {

                    //0201-通过属性 指定连接对象

                    cmd.Connection = conn;

                    conn.Open();

                    cmd.CommandText = "insert into UserInfo (EmpId, StuName, StuAge, Delflag, ClassNo) values (122,'张2三',23,0,1)";

                    Console.WriteLine("受影响行数{0}", cmd.ExecuteNonQuery());

                }

            #endregion

            }

            Console.Read();

        }

    }

}