cmd.ExecuteNonQuery()、cmd.ExecuteScalar()、cmd.ExecuteReader()

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