public TestDatabasedbmlDataContext Data { get; set; }
public
TestApplication()
{
InitializeComponent();
Data = new
TestDatabasedbmlDataContext();
}
public void GetData(int a)
{
//Select
All Records
var
queryAllCustomers = from cust in Data .tbl_Customers
select cust;
dataGridView1.DataSource =
queryAllCustomers;
//Using
Where
var
querCustomersyWhere = from cust in Data.tbl_Customers
where cust.CustomerID == 1
orderby cust.CustomerName ascending
select
cust;
//Using
Order by
var
queryCustomersOrderBy = from cust in Data.tbl_Customers
where cust.CustomerID == 1
orderby cust.CustomerName ascending
select cust;
//Using
Group by
var
queryCustomersGroupBy = from cust in
Data.tbl_Customers
group cust by
cust.CustomerName into custGroup
where custGroup.Count() > 2
orderby custGroup.Key
select custGroup;
}
//Retrieve
Data using SP
public void Getdata()
{
var
returnUser = (from c in
Data.SP_GetCustomerRecords(1)
select new tbl_Customer
{
CustomerID =
c.CustomerID,
CustomerName
= c.CustomerName,
Address =
c.Address,
Sex = c.Sex,
TelephoneNo =
c.TelephoneNo
}).ToList<tbl_Customer>();
}
public void InsertData()
{
int?
CustomerID=-1;
//int
CustomerID=-1;
Data.SP_InsertCustomerRecords(ref CustomerID, "John",
"Address", "Male", "0988999");
}
n4� lm�V.�--grid-align:none;text-autospace:none'>
public void GetData(int a)
{
//Select
All Records
var
queryAllCustomers = from cust in Data .tbl_Customers
select cust;
dataGridView1.DataSource =
queryAllCustomers;
//Using
Where
var
querCustomersyWhere = from cust in Data.tbl_Customers
where cust.CustomerID == 1
orderby cust.CustomerName ascending
select
cust;
//Using
Order by
var
queryCustomersOrderBy = from cust in Data.tbl_Customers
where cust.CustomerID == 1
orderby cust.CustomerName ascending
select cust;
//Using
Group by
var
queryCustomersGroupBy = from cust in
Data.tbl_Customers
group cust by
cust.CustomerName into custGroup
where custGroup.Count() > 2
orderby custGroup.Key
select custGroup;
}
//Retrieve
Data using SP
public void Getdata()
{
var
returnUser = (from c in
Data.SP_GetCustomerRecords(1)
select new tbl_Customer
{
CustomerID =
c.CustomerID,
CustomerName
= c.CustomerName,
Address =
c.Address,
Sex = c.Sex,
TelephoneNo =
c.TelephoneNo
}).ToList<tbl_Customer>();
}
