C#: Execute A Query & Return A Reader
1 2 public static SqlDataReader GetReader(string Query) 3 { 4 string ConnectionString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["CONNECTION_STRING_NAME"].ConnectionString; 5 SqlConnection con = new SqlConnection(ConnectionString); 6 SqlCommand command = new SqlCommand(); 7 8 command.Connection = con; 9 command.Connection.Open(); 10 command.CommandText = Query; 11 return command.ExecuteReader(); 12 }