How to Place Values Containing Commas in integer

helo guys, i am so new in VB.net..now i have a problems..i have sent before it but have no reply..so my problem is how to place the values containing commas when i print it, example

in my database =100000 but when i print i want 100,000

before it i have use this code

.Selection.TypeText(Text:=Cert.ToString("N"))
but the output when i print is 100,000.00. so i dun want .00 come out. i hope anyelse out there can give me the solution..tq a lots

ALl you have to do is select what you want out of the string:

VB Code:

Dim num As String = "100,000,000.00"
 
num = Microsoft.VisualBasic.Left(num, Len(num)-2)

Phreak

"in my database =100000 but when i print i want 100,000"

Then use the .Format method of the .Net String class.

VB Code:

Dim s As Decimal = 10330000.15D
MessageBox.Show(String.Format("{0:#,###}", s))