|
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).
|
|
|
|
|
Hello CP, I'm making a login screen that automaticaly full-screens on startup, and what I would like to know is:
- how do I get the resolution the OS is using?
- how can I center my objects in the form depending on that resolution?
For example, my computer is using 1920x1080, the form obviously is only about 200x200 big, and when I full-screen it on startup the objects that I placed there are obviously going to be on the wrong places. What I wanted is to center the objects just like it is on the Win7 login screen.
Thanks in advance.
|
|
|
|
|
See the documetation on the Screen class[^].
But, you can set the forms StartPosition property to FormStartPosition.CenterScreen before you ShowDialog the form and it'll be done for you.
|
|
|
|
|
- you can get the resolution through:
Screen.PrimaryScreen.WorkingArea.Width and Screen.PrimaryScreen.WorkingArea.Height
As for the second question, there are two ways to do it -
1) Create a base form which is what you have now, then inherit it for the different sizes and adjust the position of the controls in the designer (this is what I do)
2) Manually calculate the position of each control based on the width and height of the resolution of the monitor against the default resolution you have designed for.
David
|
|
|
|
|
In a C# 2008 solution file, there are 4 project files that interact with each other. While I am in the project file called 'app1', I want to be able to obtain the values in another project file called 'samples'.
When I am in debug looking at the locals window, I can see the value I want to obtain is in the following location: samples.PackageMetadata.SubCustomerNumber.
However I am getting the error: An object reference is required for the non-static field, method, or property 'samples.PackageMetadata.SubCustomerNumber.get'.
Thus can you show me code and tell me what I need to do so that I can obtain the 'SubCustomerNumber' value I need for an error message?
|
|
|
|
|
From that? Probably not.
How about you share the code fragment which shows the problem?
If you get an email telling you that you can catch Swine Flu from tinned pork then just delete it. It's Spam.
|
|
|
|
|
I get SqlTransaction.Zombie exception in production(In .NET Windows application not ASP.NET application). I got answer in below article how and when the exception is thrown. In production one server application available which perform DB operation and there could be more than one client applications to interact with server.
http://blogs.msdn.com/b/dataaccesstechnologies/archive/2010/08/24/zombie-check-on-transaction-error-this-sqltransaction-has-completed-it-is-no-longer-usable.aspx
In the article, it is given that connection is explicitly closed. My question is in real world application what are the possibilities to close the connection (in few cases only it occurs in production)? I would like to hear the possible scenarios to reproduce it.
One of the servers is getting stopped due to the Exception. Please do help.
Is there possibility for SPs to close the connection unexpectedly? If so, please do describe. Thanks in advance.
|
|
|
|
|
Member 3137078 wrote: In production one server application available which perform DB operation and
there could be more than one client applications to interact with server.
In the normal usage of the word that has nothing to do with this.
Member 3137078 wrote: My question is in real world application what are the possibilities to close the
connection (in few cases only it occurs in production)?
As the link said - because in ONE application the connection is being shared between multiple threads.
Member 3137078 wrote: One of the servers is getting stopped due to the Exception. Please do help.
Then your code is wrong. The solution is fix it.
1. You are sharing connections between threads - stop doing that.
2. You are allowing sql exceptions to bubble up to the top instead of catch them and reporting them. So fix that.
Member 3137078 wrote: Is there possibility for SPs to close the connection unexpectedly
"SP"? But the answer to your question is probably no - at least in the context of this exception. Your code is closing it.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
