sql插入数据

 

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

namespace sql插入数据
{
    class Program
    {
        static void Main(string[] args)
        {
            //数据库字符串
            string str = "Data Source=.;Initial Catalog=mysql;Integrated Security=True";
           //sql语句
            string sql = "insert into student values(5,'aaa','sss','ddd')";
            //连接数据库
            SqlConnection con = new SqlConnection(str);
            con.Open();
            //执行sql命令
            SqlCommand cmd = new SqlCommand(sql,con);
           //判断是否执行了sql
            int n = -1;
            n = cmd.ExecuteNonQuery();
            if (n>0)
            {
                Console.WriteLine("执行完毕！受影响行数为："+n);
            }
            else
            {
                Console.WriteLine("执行失败！");
            }
            Console.ReadKey();
            //关闭数据库
            con.Dispose();
            cmd.Dispose();
        }
    }
}