|
|
.Net Framework
|
3.5
|
Visual Studio version |
2008
|
Programming Language
|
C#
|
|
|
PROJECT DESCRIPTION
Only an example of using Linq to SQL with the Datagrid control
DataClasses1DataContext db = new DataClasses1DataContext();
var query = from p in db.Mst_Reconcilations
where p.Pat_Last_Name.StartsWith("A") && p.Pat_First_Name.StartsWith("C")
select new CustomerOrderResult
{
ID = p.ID,
AccNo = p.Acc_No,
CharNo = p.Chg_No,
FName = p.Pat_First_Name,
LName = p.Pat_Last_Name,
DOS = p.DOS
};
dataGridView1.DataSource = query;
dataGridView1.Columns[0].Visible =
false;