C#: Execute A Query & Return A Reader

cornerblue (CornerBLUE, Inc.) — Thu, 19 Jul 2007 22:02:34 GMT



public static SqlDataReader GetReader(string Query)

{

	string ConnectionString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["CONNECTION_STRING_NAME"].ConnectionString;

	SqlConnection con = new SqlConnection(ConnectionString);

	SqlCommand command = new SqlCommand();



	command.Connection = con;

	command.Connection.Open();

	command.CommandText = Query;

	return command.ExecuteReader();

}

ADO.NET - Succinctly populating a DataTable

hjnntaao (hjnntaao) — Tue, 05 Sep 2006 01:12:55 GMT

From code supporting article at http://msdn.microsoft.com/msdnmag/issues/06/08/DesignPatterns/default.aspx





    public class DatabaseGateway

    {

        public DataTable QueryForDataTable(string expression)

        {

            using (IDatabaseConnection connection = new DatabaseConnection())

            {

                DataTable table = new DataTable();



                using (IDataReader reader = connection.CreateCommandFor(expression).ExecuteReader())

                {

                    table.Load(reader);

                }



                return table;

            }

        }

    }



    public class DatabaseConnection : IDatabaseConnection

    {

        public IDbCommand CreateCommandFor(string dynamicSqlExpression)

        {

            IDbCommand command = underlyingConnection.CreateCommand();

            command.CommandType = CommandType.Text;

            command.CommandText = dynamicSqlExpression;

            return command;

        }



        public void Dispose()

        {

            underlyingConnection.Close();

            underlyingConnection.Dispose();

            underlyingConnection = null;

        }





        // ...

    }

DZone Snippets: sqldatareader code

C#: Execute A Query & Return A Reader

ADO.NET - Succinctly populating a DataTable