hi all,

i want to display 5 fields in a datagrid

but in that 2 fields come from table1 and 3 fields come from table2

but i configured the dataadapter, so that i have the 5 fields

and the dataset also displays the 5 fileds(also the values which i inserted after join)

but the confusion is how will i set the select statement for the sqldataadapter?

which table name shall i give to fill the adapater?

is there anyway to solve this problem?

i think the problem is clear to you all



thanks in advance

Just create a SQL statement that joins table 1 and table 2 and all 5 fields will be returned in a single resultset.

"The one language all programmers understand is profanity."