Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View to Select Union
Message
From
24/10/2003 14:07:43
 
 
To
24/10/2003 13:53:46
General information
Forum:
ASP.NET
Category:
Databases
Miscellaneous
Thread ID:
00842327
Message ID:
00842354
Views:
27
OK, so if I understand you correctly, your WS is returning a new set of speakers for every call to it and you want to add those all together?

How about using ImportRow to append to your table or your view? Something like this:
DataRow row;
dsMySpeakers = oWS.MyWebServiceCall();
for (int i=0; i < dsMySpeakers.Tables["Speakers"].Rows.Count; i++)
{
    row = dsMySpeakers.Tables["Speakers"].Rows[i];
    
    // If your full list of speakers is a Table
    ds.Tables["AllSpeakers"].ImportRow(row);

    // If your full list of speakers is a View
    dvAllSpeakers.Table.ImportRow(row);
}
~~Bonnie



>>Why do you need to create another View? Can't you just use the original Table (which already contains all the speakers)?
>
>This has nothing to do with the original table of our speakers. In fact, there is no table of speakers. For each meeting, up to three member UT ID can be entered for the speakers. Some may not have any speaker and others up to three. When we send the data for the meeting info by the WS, one record per meeting is being sent on a DataSet with the speakers ID where applicable. So, on the client, we need to display another list from it where a speakers archive would be built and this is where I'm looking for a UNION approach in order to get another view just for that purpose.
Bonnie Berent DeWitt
NET/C# MVP since 2003

http://geek-goddess-bonnie.blogspot.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform