用SqlConnection对象操作数据

--添加数据
            SqlConnection con = new SqlConnection();
            con.ConnectionString = "server=localhost;database=AdventureWorks;user=sa;pwd=123";
            con.Open();
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = con;
            string sql = "insert into   student(studentID , Name,age , address ,)    values ('10010','zhangsan','19','changsha')";
            cmd.CommandText = sql;
            cmd.CommandType = CommandType.Text;
            cmd.ExecuteNonQuery();
!--修改表
            SqlConnection con = new SqlConnection();
            con.ConnectionString = "server=localhost;database=AdventureWorks;user=sa;pwd=123";
            con.Open();
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = con;
            string sql = "update table student set Name='lisi'" where studentID=10010;
            cmd.CommandText = sql;
            cmd.CommandType = CommandType.Text;
            cmd.ExecuteNonQuery();

!--查询表    
            SqlConnection con = new SqlConnection();
            con.ConnectionString = "server=localhost;database=AdventureWorks;user=sa;pwd=123";
            con.Open();
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = con;
            string sql = "selcet * from  student";
            cmd.CommandText = sql;
            cmd.CommandType = CommandType.Text;
            cmd.ExecuteNonQuery();

!--删除表
            SqlConnection con = new SqlConnection();
            con.ConnectionString = "server=localhost;database=AdventureWorks;user=sa;pwd=123";
            con.Open();
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = con;
            string sql = "drop table student";
            cmd.CommandText = sql;
            cmd.CommandType = CommandType.Text;
            cmd.ExecuteNonQuery();

 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值