c# datatables Comnination...

Question

First Datatable Contains:
Name Password
abc 123
xyz 456
zxc 963

Second datatable Contains:
Name Description
abc aaaaaa
xyz bbbbbb
zxc ccccccc

So I want Output as:
Name Password Description
abc 123 aaaaaa
xyz 465 bbbbbb
zxc 963 ccccccc

Help Me..

Sukesh Marla · Answer

Use following syntax var xxx = from t1 in dt.AsEnumerable() join t2 in dt2.AsEnumerable() on t1.Field (A) equals t2.Field (A) select new { A = t1.Field (A) B = t1.Field (B) C = t2.Field (C) }; and check this is correct answer if it helped.

Sukesh Marla · Answer

what is mean by How To set Datatable... Now you can bind that variable as datasource to any gridview or deopdownm

Gopal Mahadak · Answer

But Var xxx How To set Datatable...

Pradip Pandey · Answer

Hi Gopal Suppose your first table name is A & second table name is B then use this query to get the desired result Select A1.NameA1.passwordB1.description from A As A1 Inner Join B As B1 ON A1.Name = B1.Name Hope it will help.