cmd.ExecuteNonQuery()对象是对insert,update,delete语句返回受影响的行数,如:delete from tablename
cmd.ExecuteScalar()对象是对select语句返回统计结果数,如:select count(*) from tablename
cmd.ExecuteReader()对象是对select语句返回单条数据信息,如:select * from tablename where id='1'
同样也可以通过实例化SqlDataAdapter,返回dataset/datatable ,如:select * form tablename