Click here to Skip to main content
15,915,833 members
Home / Discussions / .NET (Core and Framework)
   

.NET (Core and Framework)

 
Generalnet send HELP!! Pin
Kevinh77773-Dec-04 15:58
Kevinh77773-Dec-04 15:58 
General.net problem Pin
tom_dx3-Dec-04 14:03
tom_dx3-Dec-04 14:03 
GeneralRe: .net problem Pin
Florent Geffroy9-Dec-04 0:04
Florent Geffroy9-Dec-04 0:04 
GeneralHTTPHandler to create & write files Pin
shefali_sinha3-Dec-04 11:37
shefali_sinha3-Dec-04 11:37 
GeneralWebService.NET Pin
Anonymous3-Dec-04 6:27
Anonymous3-Dec-04 6:27 
GeneralRe: WebService.NET Pin
Dave Kreskowiak3-Dec-04 7:05
mveDave Kreskowiak3-Dec-04 7:05 
GeneralAdding Custom Options Tab in Ms Word using Add-Ins Pin
! - - < NEO > - - !2-Dec-04 20:04
suss! - - < NEO > - - !2-Dec-04 20:04 
GeneralFileSystemWatcher inconsistency, HELP!!! Pin
Alex (MCP)29-Nov-04 10:46
sussAlex (MCP)29-Nov-04 10:46 
GeneralJava Access Bridge in .Net PinPopular
ganeshvijay28-Nov-04 17:05
ganeshvijay28-Nov-04 17:05 
Generalaccessing data from a table with a relationship Pin
deepamks26-Nov-04 20:38
deepamks26-Nov-04 20:38 
GeneralRe: accessing data from a table with a relationship Pin
hermitbluedog10-Dec-04 22:29
hermitbluedog10-Dec-04 22:29 
GeneralThreads and Appdomains Pin
F.D.I26-Nov-04 3:45
F.D.I26-Nov-04 3:45 
GeneralExtracting a digital certificate from a file. Pin
sillypuppy26-Nov-04 0:01
sillypuppy26-Nov-04 0:01 
General.net datagrid column editing Pin
sxsunda25-Nov-04 19:06
susssxsunda25-Nov-04 19:06 
GeneralRequested Registry Access is Not Allowed Pin
KreativeKai24-Nov-04 9:07
professionalKreativeKai24-Nov-04 9:07 
GeneralRe: Requested Registry Access is Not Allowed Pin
The Man from U.N.C.L.E.2-Dec-04 1:46
The Man from U.N.C.L.E.2-Dec-04 1:46 
GeneralRe: Requested Registry Access is Not Allowed Pin
KreativeKai2-Dec-04 2:40
professionalKreativeKai2-Dec-04 2:40 
GeneralRe: Requested Registry Access is Not Allowed Pin
The Man from U.N.C.L.E.2-Dec-04 3:13
The Man from U.N.C.L.E.2-Dec-04 3:13 
GeneralRe: Requested Registry Access is Not Allowed Pin
The Man from U.N.C.L.E.2-Dec-04 22:37
The Man from U.N.C.L.E.2-Dec-04 22:37 
GeneralRe: Requested Registry Access is Not Allowed Pin
The Man from U.N.C.L.E.2-Dec-04 23:47
The Man from U.N.C.L.E.2-Dec-04 23:47 
GeneralRe: Requested Registry Access is Not Allowed Pin
KreativeKai9-Dec-04 8:09
professionalKreativeKai9-Dec-04 8:09 
GeneralOleDbDataReader + Excel Pin
dvd0024-Nov-04 4:49
dvd0024-Nov-04 4:49 
Hi people!

I'm using OleDbDataReader to get rows one-by-one from Excel sheet. The
code I'm using to do this:

oConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=" + name +
";Extended Properties=\"Excel 8.0;HDR=YES;IMEX=1;\"");
oConn.Open();
OleDbCommand oCmd = new OleDbCommand("SELECT * FROM [Sheet1$]",
oConn);
OleDbDataReader oReader = oCmd.ExecuteReader();

while (oReader.Read())
{
//array to store current row
object[] rowValues = new object[oReader.FieldCount];
oReader.GetValues(rowValues);
.....
}

Parameter TypeGuessRow=0. So the problem I'm getting is: values from
column with mixed types is imported with loosing their precision! For
example I have column with values {'9133.13', '87654321', '586472.12',
'a.27'}. First value imported correctly, second and third - are not.
For second I got 8.76543e+007 and for third I got 586472. Fourth value
is also correct. Firstly these cells has "Currency" format, but after
it was changed by user to "Text" without reentering values to the
cells. After this changes my problem had arised. May someone knows how
to fix it - any comments/advices/links appreciated.

QuestionGlobal CBT in .NET? Pin
Hadi Fakhreddine23-Nov-04 22:57
Hadi Fakhreddine23-Nov-04 22:57 
GeneralChanging URI's dynamically for web service clients Pin
burrifro7923-Nov-04 15:36
burrifro7923-Nov-04 15:36 
GeneralLotus NOtes Pin
rogerruiz23-Nov-04 10:01
rogerruiz23-Nov-04 10:01 

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.