数据库操作

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