|
There are many paths to a solution and you should not consider using Process or Reflection if you are writing all the code.
Another thought to go with Dave's is to split the library into sections and have the smaller apps only include the parts they need.
Definitely give it more thought before writing anything.
|
|
|
|
|
If you want P1 and the like to be plugins, i.e. you can add or remove them at runtime and have the application work out which ones are present, then you need to do something like this, though there are frameworks that could possibly help you with it.
If you are just trying to create a multi-part application, you should statically link the assemblies together at compile time, by setting P1, P2 etc as references in your top level application (either in your IDE or by using /r:P1.dll etc on the command line to csc). Think about whether they even need to be separate projects/assemblies; unless you're planning to reuse some of the components in another application, there's not really any need for them to be.
|
|
|
|
|
I have added a excel spreadsheet with 2 columns. Could anyone be kind enough to point me in the direct of how to loop through each of the cells in the first column, or even provide the code to do it.
Thanks in advance.
|
|
|
|
|
|
I want to point the best alternative in my experience is to use NPOI library you dont need excel installed.
There are several examples in the codeplex site.
AUS Enrique Ferreyra
(Pachu)
|
|
|
|
|
You should have sent this reply to the original questioner, rather than to me.
One of these days I'm going to think of a really clever signature.
|
|
|
|
|
Thanks for that. Do you have any links relating to the syntax for referencing the resource file itself?
|
|
|
|
|
What do you mean by "resource file"? Your question asked about accessing Excel columns.
One of these days I'm going to think of a really clever signature.
|
|
|
|
|
|
Sorry, I don't know how you would access the content from there, you would probably need to write it to disk first. However, since resources are constant data I see no benefit in putting an Excel formatted file into your resources, it would be much easier to convert it to XML or similar.
One of these days I'm going to think of a really clever signature.
|
|
|
|
|
It's a data of data that I use to do lookups on. I was doing this project in Access, but am now using Visual Studio. I was only putting the data in an Excel spreadsheet because I thought it would be easier to access.
For this type of information (2 columns (lookup A, bring back B), can you suggest an alternative method of storing the data within the solution for retrieval?
You mentioned XML - would that be suitable?
|
|
|
|
|
The first question you need to answer is: what is this data for, and why is it necessary to hold it in a resource, rather than as a constant table in the program? If you are certain that this is the best way to store it then you should choose a storage medium that is easy to access from within the program. You could use XML, a text or binary stream etc. It all depends on how much data and what you need to use it for.
One of these days I'm going to think of a really clever signature.
|
|
|
|
|
As for the data I have, it's around 2000 x 2 "cells".
As I'm unfamiliar with how to approach this, a resource file was just one option. Currently I'm having the user select my original database, and then importing the table to a datatable via OLEDB.
Whilst this works, ideally I'd like the data embedded so I don't have to distribute a database with the actual application.
|
|
|
|
|
If it is constant data then it should be embedded into the program rather than held as an external database, that just adds unnecessary work.
One of these days I'm going to think of a really clever signature.
|
|
|
|
|
Ok, thank you. 
If anyone can propose the best way of doing this, I'd be most grateful, as I know nothing on the subject. Many thanks.
|
|
|
|
|
Member 9704153 wrote: I know nothing on the subject.
What subject are you referring to? As I understand it you have some constant data that your program needs to use as it runs, so all you need to do is add some sort of constant array, class, structure or collection that contains all the data.
One of these days I'm going to think of a really clever signature.
|
|
|
|
|
Do you mean hard code the table into the C# code?
|
|
|
|
|
Well, as I said before that is one way of doing it. But, you really need to go back to my earlier question where I suggested you look more closely at what this data is for and why you need it in your program. You have not really given a very clear description of what problem you are trying to solve, apart from saying you have 2000 x 2 values of some sort, which you are trying to access in your code. What are these values and what are you trying to do with them?
One of these days I'm going to think of a really clever signature.
|
|
|
|
|
The values are strings.
I'm importing a spreadsheet and converting it. For each row, I need to add a number relating to a value in one of the row's cells. This number is what I am looking up.
|
|
|
|
|
So we are back to manipulating a spreadsheet ... then use the Interop reference I gave you in the first response to access and update it.
One of these days I'm going to think of a really clever signature.
|
|
|
|
|
Sadly it's not just as simple as manipulating a spreadsheet. The data is manipulated, but rows are chopped up and re-arranged, which is what I'm doing with C#/datatables. Looking up these values is just a small part of the whole solution.
|
|
|
|
|
Richard MacCutchan wrote: I don't know how you would access the content from there,
Assembly.GetManifestResourceStream?
Bob Dole The internet is a great way to get on the net.
 2.0.82.7292 SP6a
|
|
|
|
|
Probably yes, but the issue is a bit more than that.
One of these days I'm going to think of a really clever signature.
|
|
|
|
|
Hi,
Using ASP.Net - I want to copy the data from a table into a predefined csv template file.
The csv file has two header rows. One header row defines how many rows are in the file.
The second header row is the actual data from one table in sql server. A format is specified below.
Can I use BCP command in sql server, have that specified in stored procedure and have the asp.net application call this stored proc.
Maybe have the data start inserting from row 4.
==============
date=01132013,rowcount=1
merchantrefcode,ordernumber,currency,total
auth01111,50122222,USD,123.90
===============
|
|
|
|
|
Why wouldn't your app just create the whole thing?
Plus, I recommend using a better date format if possible (YYYYMMDD).
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
