Table adapter

[hadi]

Hi,
When I try to add a query to a Tableadapter in a Typed Dataset , I
get
this message : "command text returns data with schema different from
that of main query". Till this part is ok, but when I try to use the
TableAdapter in the program to execute the query, because some
columns
of the dataTable are not filled up using the desired query and those
columns are primary keys, an error message is generated.

How can I fix this problem to get different queries, with different
schemas from one TableAdapter? Hope you can help.

Thank you very much.

 

[Nicholas Paldino [.NET/C# MVP]]

hadi,

Why do you want to use the same table adapter? Since the designer
generates most of the code, if you have a specific need to use a table
adapter with a specific subset of the attributes on a table, why not just
create a new query which uses only those attributes?