This article might help.
Displaying Two DataTables In One DataGrid
http://www.dotnetbips.com/displayarticle.aspx?id=94
-Original Message-
From: adonis [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 30, 2003 11:26 AM
To: [EMAIL PROTECTED]
Subject: [ADVANCED-DOTNET] Merging Tables in a
]>
Reply-To: "Moderated discussion of advanced .NET topics."
<[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: [ADVANCED-DOTNET] Merging Tables in a Dataset
Date: Wed, 30 Jul 2003 12:25:38 -0400
I have created a stored procedure in Sql Server which uses a cursor and
returns mult
Why not just use a UNION in your stored procedure and just get a single
result set back?
HTH,
Matt
-Original Message-
From: adonis [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 30, 2003 11:26 AM
To: [EMAIL PROTECTED]
I have created a stored procedure in Sql Server which uses a cursor
You can either change the table names so they are the same as the table you
want to merge into, and then so the merge or create a new table with relations
that have the tables created by the stored proc calls become child rows. You
then put column expressions referring to the child table column a
I have created a stored procedure in Sql Server which uses a cursor and
returns multiple identical(schemawise) resultset. When this stored
procedure is used to populate a dataset, naturally multiple datatables are
created. I need to merge the data avaiable in these multiple tables of the
dataset in