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

.NET (Core and Framework)

 
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 
GeneralRe: Lotus NOtes Pin
Kevin McFarlane26-Nov-04 5:07
Kevin McFarlane26-Nov-04 5:07 
GeneralRe: Lotus NOtes Pin
rogerruiz26-Nov-04 7:39
rogerruiz26-Nov-04 7:39 
GeneralRe: Lotus NOtes Pin
Kevin McFarlane26-Nov-04 8:44
Kevin McFarlane26-Nov-04 8:44 
GeneralRe: Lotus NOtes Pin
rogerruiz26-Nov-04 8:47
rogerruiz26-Nov-04 8:47 
GeneralRe: Lotus NOtes Pin
Kevin McFarlane26-Nov-04 10:44
Kevin McFarlane26-Nov-04 10:44 
GeneralMicrosoft 2003 Toolkit Pin
sweep12322-Nov-04 5:59
sweep12322-Nov-04 5:59 
QuestionHow to manage two apps Pin
Jack_pt21-Nov-04 1:50
Jack_pt21-Nov-04 1:50 
AnswerRe: How to manage two apps Pin
DavidNohejl21-Nov-04 4:27
DavidNohejl21-Nov-04 4:27 
GeneralRe: How to manage two apps Pin
Jack_pt21-Nov-04 15:53
Jack_pt21-Nov-04 15:53 
GeneralRe: How to manage two apps Pin
Anonymous21-Nov-04 17:59
Anonymous21-Nov-04 17:59 
GeneralRe: How to manage two apps Pin
DavidNohejl22-Nov-04 1:35
DavidNohejl22-Nov-04 1:35 
AnswerRe: How to manage two apps Pin
Luis Alonso Ramos21-Nov-04 15:56
Luis Alonso Ramos21-Nov-04 15:56 
AnswerRe: How to manage two apps Pin
benjymous21-Nov-04 23:01
benjymous21-Nov-04 23:01 
GeneralRe: How to manage two apps Pin
Jack_pt22-Nov-04 2:14
Jack_pt22-Nov-04 2:14 

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.