Let see an example of using the database in LINQ and C#.netcf
We will using classCustomer
Here's
some sample data:
using
System.Collections.Generic;
using
System.ComponentModel;
using
System.Data;
using
System.Drawing;
using
System.Text;
using
System.Collections;
using
System.Windows.Forms;
using
System.Data.SqlClient;
namespace
LINQ_test
{
public
partial
class
FrmTest
:
Form
{
List
<
Customer
> CustomerList;
Customer
ObjCustomer ;
ArrayList
Alist =
new
ArrayList
();
public
class
Customer
{
public
string
Code {
get
;
set
; }
public
string
Name {
get
;
set
; }
public
string
Gender {
get
;
set
; }
public
string
city {
get
;
set
; }
public
string
state {
get
;
set
; }
public
string
Type {
get
;
set
; }
}
public
Form1()
{
InitializeComponent();
CustomerList =
new
List
<
Customer
>();
SqlConnection
cn =
new
SqlConnection
(
"Data Source =System1; Initial Catalog = dbCust; User ID = sa; Password=
Pass123
"
);
if
(cn.State ==
ConnectionState
.Closed) cn.Open();
SqlCommand
objCommand = cn.CreateCommand();
objCommand.CommandType =
CommandType
.Text;
string
StrQuery =
"select * from Customer "
;
objCommand.CommandText = StrQuery;
objCommand.Prepare();
DataSet
ds =
new
DataSet
();
DataTable
dt =
new
DataTable
();
SqlDataAdapter
da =
new
SqlDataAdapter
(objCommand);
da.Fill(dt);
for
(
int
i = 0; i < dt.Rows.Count; i++)
{
ObjCustomer =
new
Customer
();
ObjCustomer.Code = dt.Rows[i][
"Code"
].ToString();
ObjCustomer.Name = dt.Rows[i][
"Name"
].ToString();
ObjCustomer.Gender = dt.Rows[i][
"Gender"
].ToString();
ObjCustomer.city = dt.Rows[i][
"city"
].ToString();
ObjCustomer.state = dt.Rows[i][
"state"
].ToString();
ObjCustomer.Type = dt.Rows[i][
"Type"
].ToString();
CustomerList.Add(ObjCustomer);
}
}
private
void
btnview_Click(
object
sender,
EventArgs
e)
{
var
Seleccustomer=
from
p
in
CustomerList
where
p.Name ==
"codeforum"
select
p;
foreach
(
var
data
in
Seleccustomer)
Alist .Add(data);
dataGrid1.DataSource = Alist ;
}
}