One table twice in a dataset

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi

How can I have the same table, twice in my dataset with separate underlying
select/update/insert/delete sql commands?

Thanks

Regards
 
How can I have the same table, twice in my dataset with separate
underlying select/update/insert/delete sql commands?
Click to expand...

The table is not where the commands are stored. Commands are stored on the
DataAdapter. You can interchange which DataAdapter you update the DataSet
with all you want. This does not require you to have more than one
instance of the same table.

Is there some other reason you wanted two of the same table?

--
Michael Lang, MCSD
See my .NET open source projects
http://sourceforge.net/projects/colcodegen (simple code generator)
http://sourceforge.net/projects/dbobjecter (database app code generator)
http://sourceforge.net/projects/genadonet ("generic" ADO.NET)
 
Not sure I understand what you want to accomplish, but you could alias the
table and columns, or fire the same select but different update commands.

Let me know what you are tryign to ultimately accomplish and I can be of
more help.

Cheers,

Bill
 
Hi

I have a contacts table which have both clients & suppliers contacts. A
'company type' filed says which. I want to bind the client form with only
client contacts and suppliers form to suppliers contacts, both from the same
contacts table.

Thanks

Regards
 
Back
Top