增
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
//导入工具包,负责处理sqlserver的
using System.Data.SqlClient;
namespace sql增
{
class Program
{
static void Main(string[] args)
{
// 定义一个连接字符串
string connStr = "Data Source=.;Initial Catalog=ceshi;Integrated Security=True";
//获得连接对象
SqlConnection conn = new SqlConnection(connStr);
//打开连接
conn.Open();
//需要一个执法者
//去哪里的信息,conn
//干什么,sql语句
//改
String sql = "update atm set age=1500 where id=20";
Console.WriteLine(sql);
SqlCommand cmd = new SqlCommand(sql, conn);
Console.WriteLine(cmd);
//让执法者调用增方法
int n = cmd.ExecuteNonQuery();
Console.WriteLine("受影响的行数是:" + n);
//关闭连接对象
conn.Close();
//暂停
Console.ReadKey();
}
}
}
改删
源码展示
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;
namespace ExecuteNoQuery
{
class Program
{
static void Main(string[] args)
{
string cs = "Data Source=.;Initial Catalog=yi;Persist Security Info=True;User ID=sa;Password=cnm.040513";
SqlConnection conn =new SqlConnection(cs);
//打开连接对象
conn.Open();
//主要操作
string sql="insert into sanguo values(12,'小乔',80,'其它')";
//实例化一个执法者
SqlCommand cmd = new SqlCommand(sql,conn);
//执法者调用增删改方法
int n = cmd.ExecuteNonQuery();
Console.WriteLine("受影响的行数是:"+n);
//关闭连接对象
conn.Close();
//暂停
Console.ReadKey();
}
}
}