Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP inlist() in c#
Message
De
27/01/2013 08:16:03
 
 
Information générale
Forum:
ASP.NET
Catégorie:
Code, syntaxe and commandes
Divers
Thread ID:
01320903
Message ID:
01564296
Vues:
48
>>>>Declaring the type for the generic in the function call also works:
closeDrawers.InList< short >(2, 4)
>>>
>>>Do you know if there is something similar to VFP Case statement in C# where we can analyze different conditions?
>>>
>>>Say,
>>>
>>>I just wrote this part:
>>>
>>>
>>> if (startTime > defaultDate && endTime > defaultDate)
>>>                                    {
>>>                                        whereClause.AppendLine(" AND date_time between @StartTime and @EndTime");
>>>                                        sqlCommand.Parameters.Add("@StartTime", SqlDbType.DateTime).Value = startTime;
>>>                                        sqlCommand.Parameters.Add("@EndTime", SqlDbType.DateTime).Value = endTime;
>>>                                    }
>>>
>>>I need 2 more cases for only startTime defined or only endTime defined. If I will use if I again need to check both variables.
>>>
>>>Wondering if there is something in C# that makes this decision choice easier. I believe there is nothing in C# that is like VFP case where we can test various expressions - quick Google search also confirms it.
>>
>>The closest you can get is to use if/else if /else if/else
>>
>>
>>
>> if (startTime > defaultDate && endTime > defaultDate)
>> {
>>               whereClause.AppendLine(" AND date_time between @StartTime and @EndTime");
>>                sqlCommand.Parameters.Add("@StartTime", SqlDbType.DateTime).Value = startTime;
>>                 sqlCommand.Parameters.Add("@EndTime", SqlDbType.DateTime).Value = endTime;
>>  } 
>>else     if (startTime > defaultDate && endTime > defaultDate)
>> {
>>               whereClause.AppendLine(" AND date_time between @StartTime and @EndTime");
>>                sqlCommand.Parameters.Add("@StartTime", SqlDbType.DateTime).Value = startTime;
>>                 sqlCommand.Parameters.Add("@EndTime", SqlDbType.DateTime).Value = endTime;
>>  } 
>>
>>else     if (startTime > defaultDate && endTime > defaultDate)
>> {
>>               whereClause.AppendLine(" AND date_time between @StartTime and @EndTime");
>>                sqlCommand.Parameters.Add("@StartTime", SqlDbType.DateTime).Value = startTime;
>>                 sqlCommand.Parameters.Add("@EndTime", SqlDbType.DateTime).Value = endTime;
>>  } 
>>else   
>> {
>>               whereClause.AppendLine(" AND date_time between @StartTime and @EndTime");
>>                sqlCommand.Parameters.Add("@StartTime", SqlDbType.DateTime).Value = startTime;
>>                 sqlCommand.Parameters.Add("@EndTime", SqlDbType.DateTime).Value = endTime;
>>  } 
>>
>>
>>>
>
>Yes, that's what I used - just wished there was something else in C# I can use.

See my other message on how to use Switch
Gregory
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform