填充Datagridview如何使用Linq [英] Fill Datagridview How Do I Do This But When Using Linq
本文介绍了填充Datagridview如何使用Linq的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我想这样做但我正在使用linq任何例子我是怎么做的?
public partial class Form1:Form
{
public Form1()
{
InitializeComponent();
BindGrid();
}
private void BindGrid()
{
string constring = @ 数据源=。\ SQL2005;初始目录= Northwind;用户ID = sa;密码=传递@ 123;
使用(SqlConnection con = new SqlConnection(constring))
{
使用(SqlCommand cmd = new SqlCommand( SELECT * FROM Customers,con))
{
cmd.CommandType = CommandType.Text;
使用(SqlDataAdapter sda = new SqlDataAdapter(cmd))
{
使用(DataTable dt = new DataTable())
{
sda .fill伪(DT);
dataGridView1.DataSource = dt;
}
}
}
}
}
}
解决方案
拿一个linqtosql类,然后转到Server Explorer并拖动删除表
然后转到Page_load
DataClassesDataContext db = new DataClassesDataContext();
var hp = db.tbl_test_linqs中的p选择p;
DataGridView1。 DataSource = hp;
你必须使用ADO.NET实体数据模型来使用LINQtoSQL然后你可以这样做
// 从客户表中选择数据
var db = new DatabaseEntities();
var cstmrData = 来自 c db.Customers 选择 c;
// 填充网格
dataGridView1.DataSource = cstmrData ;
I want to do like this but i am using linq any examples how i do that?
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
BindGrid();
}
private void BindGrid()
{
string constring = @"Data Source=.\SQL2005;Initial Catalog=Northwind;User id = sa;password=pass@123";
using (SqlConnection con = new SqlConnection(constring))
{
using (SqlCommand cmd = new SqlCommand("SELECT * FROM Customers", con))
{
cmd.CommandType = CommandType.Text;
using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
{
using (DataTable dt = new DataTable())
{
sda.Fill(dt);
dataGridView1.DataSource = dt;
}
}
}
}
}
}
解决方案
Take a linqtosql class then go to Server Explorer and Drag n Drop Table
Then go to Page_load
DataClassesDataContext db = new DataClassesDataContext();
var hp=from p in db.tbl_test_linqs select p;
DataGridView1.DataSource = hp;
You have to use ADO.NET Entity Data Model to use LINQtoSQL and then ou can do like
//To Select Data from Customers Table var db = new DatabaseEntities(); var cstmrData = from c in db.Customers select c; //To fill grid dataGridView1.DataSource = cstmrData;
这篇关于填充Datagridview如何使用Linq的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文