Click here to Skip to main content
15,921,837 members
Home / Discussions / C#
   

C#

 
QuestionHow to working with database, Strongly Typed ? Pin
hdv21218-Apr-08 1:30
hdv21218-Apr-08 1:30 
AnswerRe: How to working with database, Strongly Typed ? Pin
Pete O'Hanlon18-Apr-08 2:33
mvePete O'Hanlon18-Apr-08 2:33 
GeneralRe: How to working with database, Strongly Typed ? Pin
hdv21218-Apr-08 3:37
hdv21218-Apr-08 3:37 
GeneralRe: How to working with database, Strongly Typed ? Pin
ChrisKo18-Apr-08 5:10
ChrisKo18-Apr-08 5:10 
GeneralRe: How to working with database, Strongly Typed ? Pin
hdv21218-Apr-08 6:36
hdv21218-Apr-08 6:36 
GeneralSqlConnection, extract server & database values Pin
laserbaronen18-Apr-08 1:04
laserbaronen18-Apr-08 1:04 
AnswerRe: SqlConnection, extract server & database values [SOLVED] Pin
laserbaronen18-Apr-08 1:10
laserbaronen18-Apr-08 1:10 
GeneralUnkown abt return type Pin
EvilInside18-Apr-08 0:27
EvilInside18-Apr-08 0:27 
GeneralRe: Unkown abt return type Pin
Christian Graus18-Apr-08 0:32
protectorChristian Graus18-Apr-08 0:32 
QuestionDataAdapter.Update method ?? Pin
Hum Dum18-Apr-08 0:24
Hum Dum18-Apr-08 0:24 
AnswerRe: DataAdapter.Update method ?? Pin
J4amieC18-Apr-08 1:03
J4amieC18-Apr-08 1:03 
QuestionDo you know a good thumbnail component? Pin
Yianni18-Apr-08 0:21
Yianni18-Apr-08 0:21 
Generalhelp with variance and gradients of pixels Pin
diddy3417-Apr-08 23:29
diddy3417-Apr-08 23:29 
GeneralRe: help with variance and gradients of pixels Pin
Christian Graus18-Apr-08 0:33
protectorChristian Graus18-Apr-08 0:33 
QuestionRunning windows form remotely Pin
ONeil Tomlinson17-Apr-08 22:49
ONeil Tomlinson17-Apr-08 22:49 
GeneralRe: Running windows form remotely Pin
darkelv17-Apr-08 23:58
darkelv17-Apr-08 23:58 
GeneralRe: Running windows form remotely Pin
ONeil Tomlinson18-Apr-08 2:13
ONeil Tomlinson18-Apr-08 2:13 
GeneralOledbDataAdapter.fill gives a blank line when used to import some excel files Pin
Rey999917-Apr-08 22:32
Rey999917-Apr-08 22:32 
Hello everyone.

I have a little application which accepts an excel file, performs a formal check on it (nothing special, it just tries to see if there's a number or a string where they should be) and then inserts the records in a database.

This application loads the excel file, puts all the data in a datatable, then performs the formal check.
To do so, I use an instance of OleDbDataAdapter and call the Fill(table) method to fill up a table.

What is startling me the most is that with some Excel files, if I erase the last row manually (e.g. in MSExcel, clicking in the cells and pressing DEL), the row is not completely erased, so the datatable resulting from the Fill() operation has one last row empty, which is causing the formal check to fail - thus preventing the file to be loaded, since it works in an all-or-nothing basis (one rows fail, the whole file is discarded).
The thing that is driving my crazy is that this happens only on SOME excel files! Even using the same Excel installation on the very same machine, some files will show this behaviour, some others won't.

Has anything similar ever happened to some of you? I cannot really get a grasp of this.
Thanks in advance

Rey9999

~~~ From Milano to The Hague, easy as it goes ~~~

GeneralRe: OledbDataAdapter.fill gives a blank line when used to import some excel files Pin
Rob Smiley18-Apr-08 10:24
Rob Smiley18-Apr-08 10:24 
GeneralRe: OledbDataAdapter.fill gives a blank line when used to import some excel files Pin
Rey999920-Apr-08 21:04
Rey999920-Apr-08 21:04 
GeneralInValidCastException Pin
Programm3r17-Apr-08 22:25
Programm3r17-Apr-08 22:25 
QuestionSubsitute for SortedList Pin
Programm3r17-Apr-08 22:43
Programm3r17-Apr-08 22:43 
AnswerRe: Subsitute for SortedList Pin
Programm3r17-Apr-08 22:50
Programm3r17-Apr-08 22:50 
AnswerRe: Subsitute for SortedList Pin
Simon P Stevens18-Apr-08 3:38
Simon P Stevens18-Apr-08 3:38 
GeneralDisplay Barcode Images in Crystal report 10 Pin
nhss17-Apr-08 22:12
nhss17-Apr-08 22:12 

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.