Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 ASP.NET
 Can I Declare The Result Of My SELECT Statement In Memory?

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-06-06 : 09:24:02
Cory writes "hey, i'm currently trying to take the result from a SELECT statement in ASP.Net, then declare it in memory as to perform some functions with it. Basically, the user enters an ID number in, the SELECT statement grabs one of 3 results, then using an IF, ELSEIF statement i want to perform some calculations. How would i go at achieving this?"

JBelthoff
Posting Yak Master

173 Posts

Posted - 2006-06-06 : 10:00:47
I I understand you correctly, you want to take the results that are returned from a database query and store them some place so you can later do processing on them?

You could store your results into a Hashtable and then store those results into an arraylist.

This will allow you to process the results at a later time.

If this is not what you are asking than you will have to be more specific.



JBelthoff
• Hosts Station is a Professional Asp Hosting Provider
• Position SEO can provide your company with SEO Services at an affordable price
› As far as myself... I do this for fun!
Go to Top of Page

egmo69
Starting Member

1 Post

Posted - 2006-06-07 : 02:18:24
yes that is it. although there will only ever be one result that is returned
Go to Top of Page
   

- Advertisement -