public partial class sqlHelper
{

public static readonly string CONN_STRING = ConfigurationSettings.AppSettings["SqlConnectionString"];


public static SqlDataReader RetrieveRowsWithDataReader(string strsql)

{
 
SqlConnection conn = new SqlConnection(CONN_STRING);
  conn.Open();
 
 
try
 
{
 
SqlCommand cmd = new SqlCommand(strsql, conn);
 
SqlDataReader drResult = cmd.ExecuteReader(CommandBehavior.CloseConnection);
  cmd.Parameters.Clear();
 
return drResult;
  }

catch
 
{
 
conn.Close();
 
throw;
  }
}
}