Click here to Skip to main content
15,885,032 members
Home / Discussions / Visual Basic
   

Visual Basic

 
QuestionDraw a Polygon using Pen Pin
ClueLess Ar*e30-Jun-09 20:59
ClueLess Ar*e30-Jun-09 20:59 
AnswerRe: Draw a Polygon using Pen Pin
Christian Graus30-Jun-09 21:39
protectorChristian Graus30-Jun-09 21:39 
QuestionSet a keyboard hook Pin
TheMrProgrammer30-Jun-09 20:20
TheMrProgrammer30-Jun-09 20:20 
AnswerRe: Set a keyboard hook Pin
TheMrProgrammer1-Jul-09 5:36
TheMrProgrammer1-Jul-09 5:36 
QuestionHow to do a HTTP GET request Pin
fuhaizah30-Jun-09 18:37
fuhaizah30-Jun-09 18:37 
AnswerRe: How to do a HTTP GET request Pin
Christian Graus30-Jun-09 21:41
protectorChristian Graus30-Jun-09 21:41 
QuestionProblem reading CSV file into dataset. Pin
maf66630-Jun-09 11:10
maf66630-Jun-09 11:10 
AnswerRe: Problem reading CSV file into dataset. Pin
Johan Hakkesteegt1-Jul-09 2:30
Johan Hakkesteegt1-Jul-09 2:30 
This does seem strange, and I can't tell you for sure why this is happening. There a few thoughts I'd like to think out loud though:
- In you sample csv file does the PostCost field contain values without decimals or a decimal point ? Perhaps the dataAdapter converts the whole column to integer, because the first, last, or majority of rows contain values without a decimal point.
- Is something in the extended properties in the connection string causing this behavior?
- Using Select * leaves the determination of the data types entirely to chance. Using it is only useful if the contents of the files can differ. A work around for this would be to specifically name each column in the query, and if necessary use some sort of cast statement to force the data type.
- If on the other hand, your file does not contain column headers, you probably assign them in the datagrid, or dataview, or somewhere. In the same place you can almost always also determine the data type.

I hope these thoughts help you to find a solution.

Cheers, Johan

My advice is free, and you may get what you paid for.

GeneralRe: Problem reading CSV file into dataset. Pin
maf6661-Jul-09 3:20
maf6661-Jul-09 3:20 
QuestionVB.net 2005 (getModuleFileNameEx) Pin
johnl012930-Jun-09 9:41
johnl012930-Jun-09 9:41 
QuestionDeserialize PHP Encoded Data Pin
GGP130-Jun-09 9:32
GGP130-Jun-09 9:32 
AnswerRe: Deserialize PHP Encoded Data Pin
Dave Kreskowiak30-Jun-09 10:40
mveDave Kreskowiak30-Jun-09 10:40 
Questionresizing contols in a form Pin
sa_runner30-Jun-09 8:38
sa_runner30-Jun-09 8:38 
AnswerRe: resizing contols in a form Pin
Eslam Afifi30-Jun-09 9:48
Eslam Afifi30-Jun-09 9:48 
AnswerRe: resizing contols in a form Pin
Jon_Boy1-Jul-09 1:27
Jon_Boy1-Jul-09 1:27 
AnswerRe: resizing contols in a form Pin
sa_runner1-Jul-09 3:40
sa_runner1-Jul-09 3:40 
Questionhow to connect a database to VB.net with codes Pin
myperacq30-Jun-09 4:16
myperacq30-Jun-09 4:16 
AnswerRe: how to connect a database to VB.net with codes PinPopular
Tom Deketelaere30-Jun-09 4:27
professionalTom Deketelaere30-Jun-09 4:27 
GeneralRe: how to connect a database to VB.net with codes Pin
JC.KaNNaN30-Jun-09 18:20
JC.KaNNaN30-Jun-09 18:20 
QuestionDesktop background Pin
The real $M@30-Jun-09 3:35
The real $M@30-Jun-09 3:35 
AnswerRe: Desktop background Pin
Tom Deketelaere30-Jun-09 4:18
professionalTom Deketelaere30-Jun-09 4:18 
AnswerRe: Desktop background Pin
Sk9330-Jun-09 5:43
Sk9330-Jun-09 5:43 
AnswerRe: Desktop background Pin
chilinhhacker13-Jul-09 19:17
chilinhhacker13-Jul-09 19:17 
GeneralRe: Desktop background Pin
The real $M@14-Jul-09 5:25
The real $M@14-Jul-09 5:25 
Questiontv tuner and directShow Pin
gsipes30-Jun-09 3:30
gsipes30-Jun-09 3:30 

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.