private SqlDataReader GetQueryOutputReader(string sql)
{
string connstr = ConfigurationManager.ConnectionStrings["ProfilesDB"].ConnectionString;
SqlConnection dbconnection = new SqlConnection(connstr);
SqlCommand dbcommand = new SqlCommand(sql, dbconnection);
SqlDataReader dbreader = null;
dbconnection.Open();
dbcommand.CommandTimeout = 5000;
try
{
dbreader = dbcommand.ExecuteReader(CommandBehavior.CloseConnection);
}
catch (Exception ex)
{ string dd = ex.Message; }
return dbreader;
}