|
Message Closed
modified 2-Dec-16 0:58am.
|
|
|
|
|
Since you are talking about "upload" you will have the file data as a stream or an array of bytes - which both technically are already objects, just not ones that are directly much use to you! 
What I'd suggest is look here: c# - Read data from an Excel file - Stack Overflow[^] - the Velkumar solution uses the ExcelDataReader package and shows you how to convert a stream into a DataTable, which sounds like where you want to be.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
Thanks for ur suggestion
Let me try
I am newbie and so all are still confusing 
|
|
|
|
|
NB: If you're writing a web application, don't use Excel Interop. It's not supported:
Microsoft does not currently recommend, and does not support, Automation of Microsoft Office applications from any unattended, non-interactive client application or component (including ASP, ASP.NET, DCOM, and NT Services), because Office may exhibit unstable behavior and/or deadlock when Office is run in this environment.
Assuming you're uploading a new format file (.xlsx), any of the following libraries should do what you need:
If you need to support old format files as well (.xls), then you'll need to use NPOI[^].
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Excel work sheets / files can be saved as CSV or XML (among other things); which are, in other words, "strings".
You can store or transport Excel files anywhere if you simple treat the file (contents) as a "long string".
|
|
|
|
|
i have a rdl report which is already created. how to display in mvc application using (visualstudio)
|
|
|
|
|
|
Hi
I am developing c# application with sql notification and sqldependency.
if particular record is updated in database table in sql server,I want to get that record details in c# application
but now i am getting all records popup if one record is updated
Please help me .
Thanks and regards
N.Ramachandran
|
|
|
|
|
Member 3080470 wrote: Please help me
With what? You have not given any information about where and how this is happening in your code.
|
|
|
|
|
Hi
I am updating record in c#
table name 'Person' .Table structure
Manager_ID int
Employee_ID int
Approved bit
Manager_ID Employee_ID Approved
123 1 0
the Manager who logs in is Manager_ID
the person targeted is Employee_ID
Approved is set 1 or 0
we assume already record is inserted.
query to be Updated is given below.
Update Person set Approved=1 where Manager_ID = 123 and Employee_ID =1
now alert will go to Employee(Employee_ID =1 ,if he logs in) from Manager .
both update query and alert will occur at same time
I am using visual studio 2012 ultimate ,dot net framework 4.6 ,sql server 2008 ,c# and windows 8.1
Thanks and regards
N.Ramachandran
|
|
|
|
|
Member 3080470 wrote: but now i am getting all records popup if one record is updated
That's how it works.
You could add a timestamp to your recordset that is updated whenever something is written; that way you could ask for the changes of the last five minutes, for example. Alternative, you could calculate a quick hashcode, and compare those to see which of them changed.
Good luck 
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
Why don't you create a separate record for each update so that the live versions are not tweaks every now and then?
The sh*t I complain about
It's like there ain't a cloud in the sky and it's raining out - Eminem
~! Firewall !~
|
|
|
|
|
hi all,
i have html markup i .xslt file, then i generate from this file pdf with spire.pdf
when data is short everything is perfect, fixed footer and all goods,
but if data going big i need to divide footer end of the last page...
any ideas?
|
|
|
|
|
Jorjini wrote: any ideas?
Yes, please explain what this has to do with C#.
|
|
|
|
|
I'm writing application in C# (WPF, .net 4.5). I need library for decoding barcodes (EAN128, GS1, code 128, EAN13). Can anyone suggest me ready to use library (free or paid). My scanner connected by USB reads a barcode and sends string od chars (mostly numbers) and I need to decode it to separated PLU, LOT, BBD etc.
|
|
|
|
|
does your bar code scanner manufacturer not have any examples to start from?
Every day, thousands of innocent plants are killed by vegetarians.
Help end the violence EAT BACON
|
|
|
|
|
I think what you need to do is to start looking at what is in a barcode: GS1 isn't a barcode (it's an allocation system for barcode numbers), EAN-13 only provides an Article Number, and Code128 is a transport mechanism that allows EAN128 to contain more than just numeric values. Only EAN128 contains specific fields you can decode into PLU, Serial Number, batch codes, etc. And most of them don't bother: they just contain the Article Number.
Normally what happens is that the AN is read from the barcode, and used as a lookup to your stock database to determine what type of goods it is, what price you are selling it as, and so forth.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
I know how barcodes work. I'm working about 12 years with ERP systems that use barcodes. You're right - GS1 it's not a code - it's non-profit organization. I thought about GS1-databar.
EAN13 not only provides Article Number - it also can contain weight or price of article.
My application send string from barcode scanner and only one think I need is to get this string separated into detailed data for example batch after 10, BBD after 15/17, weight after 310x etc. I know many of AI but I need solution which knows all of possible AI and will search string from barcode and seperate data after AI. I don't want to write it from the beggining because I don't want to miss any AI etc.
|
|
|
|
|
EAN13 holds only a 13-digit article number: you are thinking about EAN13+2 and EAN13+5 which are extensions to the basic EAN13 spec - and there isn't anything which says what those additional digits must be: they do not have to be weight or price.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
We are using EAN13 that contains only 13 digits and in this 13 digits is price or weight with article number without any extra 2 or 5 digits - it's always 13 digits EAN13 code.
|
|
|
|
|
If that's true - and I don't believe it for a moment - then what you are doing is probably very dangerous in commercial terms. The only values allowed in an EAN-13 standard bar code is a single Article Number, which is assigned to a comp-any for a specific product by the appropriate national body (for a charge) in order that it is unique world-wide. All POS systems read the barcode, extract the AN, and use it for a DB lookup to identify the exact product scanned, and from that same DB get the weight, price, dimensions, manufacturer and such like. None of that is directly stored in the BC - it's all DB stored and linked to the AN received from the BC.
If you are storing weights and prices in the AN, then unless you have purchased a pretty huge block of ANs from your issuing authority, then you are probably issuing items with EAN13 BCs which identify them to the real world as toothpaste, or rubber gloves, or fresh chicken portions ...
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
This's not our standard code - we have to print it because some of our clients need such EAN13 code - this code is printed on label only if our customer wants. Clients send us specification of codes which they want from us. Clients' POS systems reads it correctly.
This is just a market need.
|
|
|
|
|
Then you will have to read your clients specification, because what you are doing is non-standard so we cannot tell you what parts of the code you need to extract, or how they are encoded...
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
I only wanted to show you that EAN13 can also contain weight or price because you wrote that EAN13 contains only article number. My question was about decoding string not only from EAN13 which are the easiest to do - most of all I need help with EAN128, Code128 where are many possibilities and AI.
|
|
|
|
|
If it's a "custom code", then it's not EAN13 or anything else "published"; so stop referring to it in that way. Call it what it is: a custom (barcode) encoding.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
