Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Best way to handle cursors..?
Message
De
14/01/2013 12:40:43
 
Information générale
Forum:
ASP.NET
Catégorie:
Autre
Versions des environnements
Environment:
VB 9.0
OS:
Windows 7
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Desktop
Divers
Thread ID:
01562212
Message ID:
01562466
Vues:
47
J'aime (1)
>>LINQ is a riddle to me.

And to me. I learned altar boy Latin with more ease than I learned LINQ and I think the former turned out to be more useful.
Mea culpa!




>At the risk of coming over somewhat thick, I still don't have a clear view of your specs. That being said, I guess that in VFP you would use sql to compute aggregate statististics, sorting and filtering on single tables (i.e. no joins). You'll find that that functionality is available with datatable, and as I said it's conceptually the closest to what you (I?) are used to. If worse comes to worse you can always scan the datatable sequentially (Hope they don't kick you out of UT for this kind blasphemy :) ). As I said if you know a recordset in ADO or DAO, well datatable is pretty close to it.
>
>LINQ is a riddle to me. Each time I (try to) use it I wonder what they thought was wrong with sql. I'm sure it's sooo much more powerful, but for the vanilla vb programmer it's a challenge.
>
>I may be wrong, but E/F is more for accessing the DB.
>
>
>
>
>>As an example, one of the cursors tracks content balancing for the test. We need X number of this type, Y number of that type, etc, up to a max number. After each question is 'used', the counter for that questions type gets updated by 1, and the property value for that type gets recalculated. That property value then gets used to other calculations to select the next question
>>
>>
>>
>>
>>>Not sure about E/F and I think it's part of .net, so I'm not sure you need approval.
>>>
>>>That being said, the closest to updatable cursors in VB.net are datatables. In fact it it's the closest I can think of to recordsets in ado. Not sure (again!) what you mean by "cursors that need to be updated between each questions displayed". As far as I know you cannot use dt in sql's like you could cursors; but you can Linq (good luck with that :) ). And you can (I think) bind datatables to datagridviews.
>>>
>>>Hope (doubt :)) this helps.
>>>
>>>Marc
>>>
>>>
>>>
>>>>With an up to 2 years approval process for new software, bringing in any kind of Framework is kinda out.
>>>>
>>>>
>>>>>Use Entity Framework and create an instance of the entity.
>>>>>
>>>>>
>>>>>>Hey All
>>>>>>
>>>>>>I'm in the process of translating/converting a VFP application to VB.Net and while I find a lot of my VB coming back to me, I've also found that how I used to do thing have changed, which is ok.
>>>>>>
>>>>>>However, I'm finding so many ways of handling cursors that's it's a little confusion-making.
>>>>>>
>>>>>>What I need to be able to do is create 2 update-able cursors that need to be updated between each question displayed. What's the best way to do this now?
>>>>>>
>>>>>>Dorris
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform