Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
View to Select Union
Message
De
24/10/2003 14:07:43
 
 
À
24/10/2003 13:53:46
Information générale
Forum:
ASP.NET
Catégorie:
Bases de données
Divers
Thread ID:
00842327
Message ID:
00842354
Vues:
28
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform