用SqlConnection对象操作数据

最新推荐文章于 2021-11-19 09:58:41 发布

沧海一波

最新推荐文章于 2021-11-19 09:58:41 发布

阅读量3.2k

点赞数 4

文章标签： sql string server cmd table insert

--添加数据
            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();