Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Lookup from a view
Message
De
13/01/2005 15:55:30
 
 
À
13/01/2005 15:32:17
Information générale
Forum:
ASP.NET
Catégorie:
Bases de données
Divers
Thread ID:
00976908
Message ID:
00976934
Vues:
32
This message has been marked as the solution to the initial question of the thread.
Try this...
// Create a primary key...analagous to index on <col1 + col2>...except that the combination MUST be unique
MyTable.PrimaryKey =new DataColumn[] {MyTable.Columns["Key"], 
                                   MyTable.Columns["Module"]};

// do a find, return a single datarow if successful
DataRow DrLookup = MyTable.Rows.Find(lcKey + lcModule);
if(DrLookup!=null) {
   switch(tLanguage) {
         case 1:
             lcString = DrLookup["French"];
             break;
         case 2:
             lcString = DrLookup["English"];
             break;
         }
}
I realize that's in C#...I think for the most part if you replace the [] with (), that should either work or be very close.

Let me know if that helps...
Kevin
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform