Click here to Skip to main content
15,346,335 members
Home / Discussions / C#
   

C#

 
AnswerRe: Best way to store/access data? Pin
Richard MacCutchan26-Jan-22 4:39
mveRichard MacCutchan26-Jan-22 4:39 
QuestionRe: Best way to store/access data? Pin
Richard A Knox26-Jan-22 5:58
MemberRichard A Knox26-Jan-22 5:58 
AnswerRe: Best way to store/access data? Pin
Richard MacCutchan26-Jan-22 6:09
mveRichard MacCutchan26-Jan-22 6:09 
AnswerRe: Best way to store/access data? Pin
OriginalGriff26-Jan-22 6:21
mveOriginalGriff26-Jan-22 6:21 
AnswerRe: Best way to store/access data? Pin
Gerry Schmitz26-Jan-22 6:39
mveGerry Schmitz26-Jan-22 6:39 
AnswerRe: Best way to store/access data? Pin
RobertSF26-Jan-22 7:56
professionalRobertSF26-Jan-22 7:56 
AnswerRe: Best way to store/access data? Pin
Mycroft Holmes26-Jan-22 11:39
professionalMycroft Holmes26-Jan-22 11:39 
AnswerRe: Best way to store/access data? Pin
jschell30-Jan-22 6:59
Memberjschell30-Jan-22 6:59 
Richard A Knox wrote:
I need a way to store wire sizes with the corresponding name of the wire, so that its easy to retrieve, edit or update within the program.


1. Where does the data come from in the first place. And how is that source managed right now.
2. How many exactly will there be. 10? 1000? 100,000?
3. How often do they change?

-----------------------------------
So if the above is
1/2. 10. Doesn't actually matter where they come from.
3. With 10 it will be not very often.

Solution: As suggested hard code it.

-----------------------------------
1. it is in a spreadsheet
2. There are more than 50,000
3. They add them weekly.

Solution: You will need a database. Either traditional relational or an object store.

You can create code that extracts if from the spreadsheet but I suspect that is just more work than is needed. For the first load dump the spread sheet to a file and then use a tool to load the entries into the appropriate table. That is probably easier (in some sense) using a traditional relational database.

You would also need a UI to search, update, delete, add entries and you would need to convince the people that do this now to use this instead of the spread sheet. Otherwise you will need to complicate the above process by loading the data on a scheduled basis from the spreadsheet (same process as above.)
QuestionI need some help Pin
Member 1551267725-Jan-22 12:09
MemberMember 1551267725-Jan-22 12:09 
AnswerRe: I need some help Pin
Luc Pattyn25-Jan-22 14:34
sitebuilderLuc Pattyn25-Jan-22 14:34 
AnswerRe: I need some help Pin
RobertSF25-Jan-22 17:15
professionalRobertSF25-Jan-22 17:15 
AnswerRe: I need some help Pin
OriginalGriff25-Jan-22 20:01
mveOriginalGriff25-Jan-22 20:01 
QuestionC# EPPlus How to hide range of columns Pin
Mou_kol24-Jan-22 2:01
MemberMou_kol24-Jan-22 2:01 
AnswerRe: C# EPPlus How to hide range of columns Pin
Richard Deeming24-Jan-22 2:58
mveRichard Deeming24-Jan-22 2:58 
AnswerRe: C# EPPlus How to hide range of columns Pin
Victor Nijegorodov24-Jan-22 3:50
MemberVictor Nijegorodov24-Jan-22 3:50 
QuestionHow would you describe what an IEnumerable is to a bright student of C# Pin
BillWoodruff22-Jan-22 2:34
mveBillWoodruff22-Jan-22 2:34 
AnswerRe: How would you describe what an IEnumerable is to a bright student of C# Pin
jschell23-Jan-22 7:25
Memberjschell23-Jan-22 7:25 
GeneralRe: How would you describe what an IEnumerable is to a bright student of C# Pin
Richard Deeming23-Jan-22 21:59
mveRichard Deeming23-Jan-22 21:59 
GeneralRe: How would you describe what an IEnumerable is to a bright student of C# Pin
BillWoodruff25-Jan-22 3:23
mveBillWoodruff25-Jan-22 3:23 
GeneralRe: How would you describe what an IEnumerable is to a bright student of C# Pin
jschell30-Jan-22 6:37
Memberjschell30-Jan-22 6:37 
AnswerRe: How would you describe what an IEnumerable is to a bright student of C# Pin
#realJSOP24-Jan-22 23:44
mva#realJSOP24-Jan-22 23:44 
AnswerRe: How would you describe what an IEnumerable is to a bright student of C# Pin
endo funk26-Jan-22 5:31
Memberendo funk26-Jan-22 5:31 
GeneralRe: How would you describe what an IEnumerable is to a bright student of C# Pin
Gerry Schmitz26-Jan-22 6:13
mveGerry Schmitz26-Jan-22 6:13 
GeneralRe: How would you describe what an IEnumerable is to a bright student of C# Pin
endo funk26-Jan-22 9:40
Memberendo funk26-Jan-22 9:40 
GeneralRe: How would you describe what an IEnumerable is to a bright student of C# Pin
Gerry Schmitz27-Jan-22 16:58
mveGerry Schmitz27-Jan-22 16:58 

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.