datatable works in C# winform but not ASP.NET
        Posted  
        
            by Charles Gargent
        on Stack Overflow
        
        See other posts from Stack Overflow
        
            or by Charles Gargent
        
        
        
        Published on 2010-05-28T10:32:53Z
        Indexed on 
            2010/05/28
            10:41 UTC
        
        
        Read the original article
        Hit count: 341
        
Hi I have created a class that returns a datatable, when I use the class in a c# winform the dataGridView is populted corectly using the following code
dataGridView1.DataSource = dbLib.GetData();
However when I try the same thing with ASP.NET I get a
Object reference not set to an instance of an object.
using the following code
    GridView1.DataSource = dbLib.GetData();
    GridView1.DataBind();
What am I doing wrong / missing
Thanks
EDIT for the curios here is the dbLib class
public static DataTable GetData()
{
    SQLiteConnection cnn = new SQLiteConnection("Data Source=c:\\test.db");
    SQLiteCommand cmd = new SQLiteCommand("SELECT count(Message) AS Occurances, Message FROM evtlog GROUP BY Message ORDER BY Occurances DESC LIMIT 25", cnn);
    cnn.Open();
    SQLiteDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
    DataTable dt = new DataTable();
    dt.Load(dr);
    return dt;
}
© Stack Overflow or respective owner