create LINQ to database in the .NET Compact Framework 3.5

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 ;

}

}

You must Login to comment.