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 ;
}
}
The ASP.NET Wiki was started by Scott Hanselman in February of 2008. The idea is that folks spend a lot of time trolling the blogs, googlinglive-searching for answers to common "How To" questions. There's piles of fantastic community-created and MSFT-created content out there, but if it's not found by a search engine and the right combination of keywords, it's often lost.
The ASP.NET Wiki articles moved to CodeProject in October 2013 and will live on, loved, protected and updated by the community.