سلام دوست عزیز
کد بهمراه نمونه پروژه رو ببین انشاالله مشکلت حل میشه
private void Form1_Load(object sender, EventArgs e)
{
var t1 = new DataSet1().t1;
var t2 = new DataSet1().t2;
t1.Rows.Add(new object[] { 1, "Mohammad Ali", "Zergani" });
t1.Rows.Add(new object[] { 2, "Danial", "Afshari" });
t2.Rows.Add(new object[] { 1, "09163236194", "0916" });
t2.Rows.Add(new object[] { 2, "09367817949", "0937" });
var result = (from _t1 in t1
join _t2 in t2
on _t1.ID equals _t2.ID_t1
select new
{
ID = _t1.ID,
Name = _t1.Name,
LastName = _t1.LastName,
Tel = _t2.Tel,
Num = _t2.Num,
}).ToList();
dataGridView1.DataSource = result;
}
دانلود نمونه