Jon: this is my code so far:
public partial class frmMain : Form
{
DBDataContext db = null; // DBDataContext defined in DBDataContext.cs
public frmMain()
{
InitializeComponent();
string cnStr = <connection string// actual string snipped
DBDataContext db = new DBDataContext(cnStr);
}
private void btnList_Click(object sender, EventArgs e)
{
var act_types =
from a in db.Activities
from t in db.Types
where a.Activity_Type == t.Type_Id
orderby a.Activity_Date
select new
{
a.Activity_Date,
t.Type_Desc,
a.Activity_Distance,
a.Activity_Duration,
a.Activity_Route
};
dgvList.DataSource = act_types;
}
}
The query worked perfectly when it was part of frmMain
"Jon Skeet [C# MVP]" wrote:
Paolo <Pa***@discussions.microsoft.comwrote:
I'm getting an error "Object reference not set to an instance of an object."
with line number shown as <### as i try to popuate a DataGridView:
private void btnList_Click(object sender, EventArgs e)
{
var act_types = <###
from a in db.Activities
from t in db.Types
where a.Activity_Type == t.Type_Id
orderby a.Activity_Date
select new
{
a.Activity_Date,
t.Type_Desc,
a.Activity_Distance,
a.Activity_Duration,
a.Activity_Route
};
dgvList.DataSource = act_types; // DataGridView
}
This model appears identical to many examples I've seen so what am I missing?
Where are you getting db from, and is it definitely non-null?
--
Jon Skeet - <sk***@pobox.com>
Web site: http://www.pobox.com/~skeet
Blog: http://www.msmvps.com/jon.skeet
C# in Depth: http://csharpindepth.com