Click here to Skip to main content
15,923,852 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Auto size page controls on maximize and minimize Pin
parth.p4-Mar-08 5:10
parth.p4-Mar-08 5:10 
GeneralPanel Moving while drawing powerpacks shapes at design time also Pin
VB 8.03-Mar-08 23:28
VB 8.03-Mar-08 23:28 
QuestionVB.NET defining space characters in a string? Pin
Benny_Lava3-Mar-08 23:09
Benny_Lava3-Mar-08 23:09 
GeneralRe: VB.NET defining space characters in a string? Pin
yogesh_kumar_agarwal3-Mar-08 23:31
yogesh_kumar_agarwal3-Mar-08 23:31 
GeneralRe: VB.NET defining space characters in a string? Pin
Benny_Lava3-Mar-08 23:52
Benny_Lava3-Mar-08 23:52 
AnswerRe: VB.NET defining space characters in a string? Pin
Eslam Afifi4-Mar-08 5:13
Eslam Afifi4-Mar-08 5:13 
QuestionLogo/Icon on the Smartphone Pin
Parasmani Swamy3-Mar-08 21:48
Parasmani Swamy3-Mar-08 21:48 
QuestionCalculation VB 2005 double Insert SQL 2005 in Smallmoney field Pin
DCAUB3-Mar-08 21:39
DCAUB3-Mar-08 21:39 
Hello,

I am having the following problem when insetring in SQL 2005 from VB 2005

I have done a calculation wich result in a double variable with the name Total

In my SQL database the Total is defined as smallmoney

Need to Insert the Total into my SQL database so what i do :

SQL="Insert into Results (Total) Values ('"+ System.convert.tostring(Total)+"')"

The SQL insert is working but the Values are incorrect, something wrong with the Decimal point.

When i insert my double result that is the result of for ex. 3 * 2,5 --> 7,5 (Total) in the database there is 75,0000 in the SQL insert i insert 7,5

So i think that something is wrong with the decimal sign.

Maybe i need to insert 7.5 instead of 7,5 but how can i make that is will be correct converted so i can insert it right into SQL.

Any suggestions are very welcome.

I think that there is a simple solution but i dont see it anymore.



Thanks


DCAUB
GeneralRe: Calculation VB 2005 double Insert SQL 2005 in Smallmoney field Pin
Christian Graus3-Mar-08 22:11
protectorChristian Graus3-Mar-08 22:11 
GeneralHai Pin
Tharsan3-Mar-08 20:16
Tharsan3-Mar-08 20:16 
GeneralRe: Hai Pin
Christian Graus3-Mar-08 21:31
protectorChristian Graus3-Mar-08 21:31 
GeneralRe: Hai Pin
Dave Kreskowiak4-Mar-08 10:06
mveDave Kreskowiak4-Mar-08 10:06 
GeneralRe: Hai Pin
darkelv4-Mar-08 18:55
darkelv4-Mar-08 18:55 
GeneralRe: Hai Pin
Paul Conrad7-Mar-08 17:46
professionalPaul Conrad7-Mar-08 17:46 
GeneralRe: Hai Pin
Vimalsoft(Pty) Ltd4-Mar-08 20:59
professionalVimalsoft(Pty) Ltd4-Mar-08 20:59 
GeneralRe: Hai Pin
Paul Conrad7-Mar-08 17:45
professionalPaul Conrad7-Mar-08 17:45 
QuestionHow to Draw string Unicode ? Urgent need Pin
nimolZero3-Mar-08 18:39
nimolZero3-Mar-08 18:39 
AnswerRe: How to Draw string Unicode ? Urgent need Pin
Christian Graus3-Mar-08 19:03
protectorChristian Graus3-Mar-08 19:03 
Generalsick of using session objects Pin
uglyeyes3-Mar-08 17:54
uglyeyes3-Mar-08 17:54 
GeneralRe: sick of using session objects Pin
Christian Graus3-Mar-08 18:57
protectorChristian Graus3-Mar-08 18:57 
GeneralRe: sick of using session objects Pin
_Damian S_3-Mar-08 19:04
professional_Damian S_3-Mar-08 19:04 
GeneralRe: sick of using session objects Pin
Christian Graus3-Mar-08 19:33
protectorChristian Graus3-Mar-08 19:33 
GeneralPrinting Support on laser inkjet and on dotmatrix in vb6 Pin
r_mohd3-Mar-08 17:27
r_mohd3-Mar-08 17:27 
GeneralRe: Printing Support on laser inkjet and on dotmatrix in vb6 Pin
Christian Graus3-Mar-08 19:33
protectorChristian Graus3-Mar-08 19:33 
GeneralRe: Printing Support on laser inkjet and on dotmatrix in vb6 Pin
r_mohd3-Mar-08 23:12
r_mohd3-Mar-08 23: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.