Bind SQLiteDataReader to GridView in ASP.NET
- by Charles Gargent
Hi,
this is all rather new to me, but I have searched for a good while and cant find any idea why I cant get this to work, dr looks like it is populated but I get this nullreferenceexeception when I try to bind to the gridview
Thanks
code
SQLiteConnection cnn = new SQLiteConnection(@"Data Source=c:\log.db");
cnn.Open();
SQLiteCommand cmd = new SQLiteCommand(@"SELECT * FROM evtlog", cnn);
SQLiteDataReader dr = cmd.ExecuteReader();
GridView1.DataSource = dr;
GridView1.DataBind();
dr.Close();
cnn.Close();
Codebehind
<asp:ContentPlaceHolder ID="MainContent" runat="server">
<asp:GridView ID="GridView1" runat="server">
</asp:GridView>
</asp:ContentPlaceHolder>
error
Object reference not set to an
instance of an object.
at
WPKG_Report.SiteMaster.Button1_Click(Object
sender, EventArgs e) in
C:\Projects\Report\Site.Master.cs:line 32 at
System.Web.UI.WebControls.Button.OnClick(EventArgs
e) at
System.Web.UI.WebControls.Button.RaisePostBackEvent(String
eventArgument) at
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String
eventArgument) at
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument)
at
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection
postData) at
System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean
includeStagesAfterAsyncPoint)
