Help with Error

Hi Everyone,

I have this piece of code that keeps throwing an error. I have no idea why it is throwing this error. The error being thrown is:

Object not set to instance of an object

Code:

---


            DbConnection conn = myFactory.CreateConnection();
            conn.ConnectionString = connectionString;
            using (conn)
            {
                conn.Open();
                DbCommand cmd = conn.CreateCommand();
                cmd.CommandText = sqlStatement;
                cmd.CommandType = CommandType.Text;
                DbDataReader reader = cmd.ExecuteReader();
                myTable.Load(reader);
               
            }
            return myTable;

---

Thanks for all the help

-zd

on what line is it throwing this error?

mytable.Load(reader)
thanks

Thanks Everyone for all the help. I figured it out. The Data table that I was passing into this method had been set to null previously. I had to "new" it up.

Thanks Atheist for the help.

:)

-zd

If your problem has been solved you should mark the thread as resolved;)

Can I also recommend that instead of this:

C# Code:

DbConnection conn = myFactory.CreateConnection();
conn.ConnectionString = connectionString;
using (conn)
{

you do this:

C# Code:

using (DbConnection conn = myFactory.CreateConnection())
{
    conn.ConnectionString = connectionString;