Textbox FormatNumber and Mysql - VB.Net

Question

Textbox FormatNumber and Mysql - VB.Net

danis flo 1

Hi..
I have some problem..
this is my Textbox format ...

price one > TextBox2.Text = Format(Val(TextBox2.Text), "###,###")
price two > TextBox3.Text = FormatCurrency(Val(TextBox3.Text)
price three > TextBox4.Text = FormatNumber(Val(TextBox4.Text))

but in my database, I use INT data type (p_one,p_two,p_three)

is it possible when I enter 1,000 in textbox and in database 1000 too, with INT data type?

LesHay 7,146 Reputation points

2022-10-16T14:24:59.137+00:00
Hi
Are you just posting imaginary information?
You show the TextBox values completely unrelated to the values in the DataGridView! You also show an imaginary Sum which is completely unrelated to anything else!

A strange format - is it from an old VB2 or VB4 application? Maybe you are using an old reference book?
Which version of VB.NET are you using?

Here is an example showing one way to format a number. All using the same initial value 1234.2345678

Public Class Form1 Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load Dim v As Double = 1234.2345678 TextBox1.Text = v.ToString() TextBox2.Text = v.ToString("0") TextBox3.Text = v.ToString("0.00") TextBox4.Text = v.ToString("0.0000") End Sub End Class

Your answer

LesHay 7,146 Reputation points

2022-10-16T14:24:59.137+00:00

Hi
Are you just posting imaginary information?
You show the TextBox values completely unrelated to the values in the DataGridView! You also show an imaginary Sum which is completely unrelated to anything else!

A strange format - is it from an old VB2 or VB4 application? Maybe you are using an old reference book?
Which version of VB.NET are you using?

Here is an example showing one way to format a number. All using the same initial value 1234.2345678

Public Class Form1 Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load Dim v As Double = 1234.2345678 TextBox1.Text = v.ToString() TextBox2.Text = v.ToString("0") TextBox3.Text = v.ToString("0.00") TextBox4.Text = v.ToString("0.0000") End Sub End Class

Share via

Textbox FormatNumber and Mysql - VB.Net

Your answer