Help with Error

[zdavis]

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

 
            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

[Atheist]

on what line is it throwing this error?

[zdavis]

mytable.Load(reader)
thanks

[zdavis]

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

[Atheist]

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

[jmcilhinney]

Can I also recommend that instead of this:

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

you do this:

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