update dataset with join-statement

hi...

i've a dataset with a table which is filled from more than one table (join-statement). when updating the dataset i get an error that it isn't possible to update datasets with more than one basis-tables.

i've also tried to use a view (defined on sql-server) but .net also knows that there are more than one table involved.

has anybody know how i can handle this problem?

thanks
robert

Sure, just physically call the stored procedure (or inline sql) in your event sink. I'm assuming you are using a datagrid and populating its contents via the join statement.