Click here to Skip to main content
15,901,205 members
Home / Discussions / C#
   

C#

 
GeneralRe: RadioButton Pin
DdoubleD16-Aug-09 17:17
DdoubleD16-Aug-09 17:17 
GeneralRe: RadioButton Pin
DdoubleD16-Aug-09 17:20
DdoubleD16-Aug-09 17:20 
GeneralRe: RadioButton Pin
DdoubleD16-Aug-09 17:44
DdoubleD16-Aug-09 17:44 
GeneralRe: RadioButton Pin
daffy_200316-Aug-09 18:16
daffy_200316-Aug-09 18:16 
AnswerRe: RadioButton Pin
Blue_Boy16-Aug-09 16:14
Blue_Boy16-Aug-09 16:14 
GeneralRe: RadioButton Pin
daffy_200316-Aug-09 16:55
daffy_200316-Aug-09 16:55 
AnswerRe: RadioButton Pin
hosseinsinohe16-Aug-09 21:26
hosseinsinohe16-Aug-09 21:26 
QuestionLocal Database cached with C# Pin
Jacob Dixon16-Aug-09 14:40
Jacob Dixon16-Aug-09 14:40 
I have a question that I am unsure of the answers and its possible that the Local Database cache is something I am looking for.

I have created an Inventory Application for all of our items at our agency. This is over 5000 items. When adding or modifying an item, I have it pull Distinct values from the Manufacturer, Model, Vendor, etc. The reason for this is so it will be easier to standardize everything using Autocomplete. We have orders from many manufacturers and the way it is now, there is some items in there as:

HP, or Hewlett Packard, or Hewlett Packard Co., etc.

Using autocomplete will popup an example that you can choose from so hopefully you will select Hewlett Packard to standard it better and make it easier for reports.

As you can tell, the problem is the amount of data it pulls to populate the comboboxes. That is a lot of data to pull from a SQL server even if it is a stored procedure and only pulling Distinct values.

Is there a way to possible cache this information once on the application load and use it over and over? I am only worried about caching it on the application loading (locally) or maybe even once a week.

Any ideas would be grateful. Thank you!
AnswerRe: Local Database cached with C# Pin
Luc Pattyn16-Aug-09 14:46
sitebuilderLuc Pattyn16-Aug-09 14:46 
GeneralRe: Local Database cached with C# Pin
Jacob Dixon16-Aug-09 14:50
Jacob Dixon16-Aug-09 14:50 
GeneralRe: Local Database cached with C# Pin
Jacob Dixon16-Aug-09 14:52
Jacob Dixon16-Aug-09 14:52 
GeneralRe: Local Database cached with C# Pin
Luc Pattyn16-Aug-09 15:01
sitebuilderLuc Pattyn16-Aug-09 15:01 
GeneralRe: Local Database cached with C# Pin
Jacob Dixon16-Aug-09 15:02
Jacob Dixon16-Aug-09 15:02 
GeneralRe: Local Database cached with C# Pin
Jacob Dixon16-Aug-09 14:59
Jacob Dixon16-Aug-09 14:59 
GeneralRe: Local Database cached with C# Pin
Luc Pattyn16-Aug-09 15:08
sitebuilderLuc Pattyn16-Aug-09 15:08 
AnswerRe: Local Database cached with C# Pin
Mycroft Holmes16-Aug-09 16:40
professionalMycroft Holmes16-Aug-09 16:40 
QuestionA question related to Computers connection using C# Pin
CoderForEver16-Aug-09 10:11
CoderForEver16-Aug-09 10:11 
AnswerRe: A question related to Computers connection using C# Pin
Saksida Bojan16-Aug-09 11:03
Saksida Bojan16-Aug-09 11:03 
GeneralRe: A question related to Computers connection using C# Pin
CoderForEver16-Aug-09 21:54
CoderForEver16-Aug-09 21:54 
GeneralRe: A question related to Computers connection using C# Pin
Saksida Bojan16-Aug-09 23:43
Saksida Bojan16-Aug-09 23:43 
GeneralRe: A question related to Computers connection using C# Pin
Henry Minute17-Aug-09 0:59
Henry Minute17-Aug-09 0:59 
GeneralRe: A question related to Computers connection using C# Pin
CoderForEver17-Aug-09 8:33
CoderForEver17-Aug-09 8:33 
QuestionMore marshaling woes :-( Pin
DaveyM6916-Aug-09 8:48
professionalDaveyM6916-Aug-09 8:48 
AnswerRe: More marshaling woes :-( Pin
Luc Pattyn16-Aug-09 8:58
sitebuilderLuc Pattyn16-Aug-09 8:58 
GeneralRe: More marshaling woes :-( Pin
DaveyM6916-Aug-09 9:51
professionalDaveyM6916-Aug-09 9:51 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.