c# datatables Comnination...

Accepted 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.

0

what is mean by How To set Datatable...

Now you can bind that variable as datasource to any gridview or deopdownm

0

But Var xxx How To set Datatable...

0

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.Name,A1.password,B1.description

from A As A1

Inner Join B As B1 ON A1.Name = B1.Name

Hope it will help.

0