连接表并在linq中显示结果un datagridview [英] join tables and show result un datagridview in linq

问题描述

ALTER PROCEDURE dbo.StoredProcedure4
    @se nvarchar(10)
AS
    select * from Table1 join Table2 on 1=1
    where id=@se
    RETURN

我有这个查询.
当我键入此代码时:
var db = new datacontext();
db.insert_table1(textbox1.text，textbox2.text);
db.insert_table2(textbox3.text);
datagridview.datacourse = db.StoredProcedure4(textbox.text);
不要显示插入到tabales中的数据；

i have this query.
when i type this code:
var db=new datacontext();
db.insert_table1(textbox1.text,textbox2.text);
db.insert_table2(textbox3.text);
datagridview.datacourse=db.StoredProcedure4(textbox.text);
don''t show data that before inserted to tabales;

推荐答案

您好，
试试这个:

Hi,
Try this:

var custOrders =
    from o in db.Orders
    from c in db.Customers
    where c.CustomerID == "ALFKI"
    where c.CustomerID == o.CustomerID
    select new {c.ContactName, o.ShipName} 

那么您可以将custOrders绑定到您的DataGridView.

希望对您有帮助，
干杯

then you can bind custOrders to your DataGridView.

I hope it helps,
Cheers

这篇关于连接表并在linq中显示结果un datagridview的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！