This is a migrated thread and some comments may be shown as answers.

DataGrid Example with Linq and SQL Server

1 Answer 201 Views

General Discussions

This is a migrated thread and some comments may be shown as answers.

Piyush Goriya asked on 22 Jul 2009, 08:43 AM

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;

1 Answer, 1 is accepted