create LINQ to database in the .NET Compact Framework 3.5





0/5 (0 vote)
Let see an example of using the database in LINQ and C#.netcf We will using classCustomer Here'ssome sample
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 ;
}
}
}