How to Fill Typed DataSet

Hi,

this might be a stupid question...

I've created a typed DataSet containing two tables and a
ForeignKeyConstraint. Now I want to Fill that DataSet from database using a
SELECT command retrieving rows for both tables.

However, when I use SqlDataAdapter.Fill() none or only the first table are
filled with data (depending on the Fill() overload I'm using).

Examining the Dataset I noticed that the Fill() method adds new tables to
the DataSet. How can I force Fill() to use the tables which are already
within the DataSet?

TIA,
Axel Dahmen

-----------------

This is the code I'm using:

adp=new SqlDataAdapter("SELECT * FROM Languages; SELECT * FROM
LanguagesCountries","user id=...;password=...;database=...");
_set=new TypedDataSet();
adp.Fill(_set,"Languages");

You have to add table mapping before filling in order
to overwrite default table names:

adp.TableMappings.Add("Table", your_first_table_name);
adp.TableMappings.Add("Table1", your_second_table_name);
adp.TableMappings.Add("Table2", your_third_table_name);

and so on.

Axel Dahmen wrote:
> Hi,
>
> this might be a stupid question...
>
> I've created a typed DataSet containing two tables and a
> ForeignKeyConstraint. Now I want to Fill that DataSet from database using a
> SELECT command retrieving rows for both tables.
>
> However, when I use SqlDataAdapter.Fill() none or only the first table are
> filled with data (depending on the Fill() overload I'm using).
>
> Examining the Dataset I noticed that the Fill() method adds new tables to
> the DataSet. How can I force Fill() to use the tables which are already
> within the DataSet?
>
> TIA,
> Axel Dahmen
>
> -----------------
>
> This is the code I'm using:
>
> adp=new SqlDataAdapter("SELECT * FROM Languages; SELECT * FROM
> LanguagesCountries","user id=...;password=...;database=...");
> _set=new TypedDataSet();
> adp.Fill(_set,"Languages");
>
>