public static SqlDataReader queryreader(string sql, params SqlParameter[] sqlParameters)
{
SqlConnection sqlConnection = new SqlConnection(strConn);
using (SqlCommand sqlCommand = new SqlCommand(sql, sqlConnection))
{
if (sqlParameters != null && sqlParameters.Count() > 0)
sqlCommand.Parameters.AddRange(sqlParameters);
sqlConnection.Open();
return sqlCommand.ExecuteReader(CommandBehavior.CloseConnection);
}
}
查询