Visual Basic
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Iron Speed
Go Back   Tutorialized ForumsDesktop ProgrammingVisual Basic

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Tutorialized Forums Sponsor:
Be the architects of evolution and help create the mobile internet future. It’s your move---enter to win here!
  #1  
Old November 28th, 2007, 06:45 AM
sweta_gupta50 sweta_gupta50 is offline
Registered User
Tutorialized Newbie (0 - 499 posts)
 
Join Date: Oct 2007
Posts: 3 sweta_gupta50 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 19 m 54 sec
Reputation Power: 0
How to set the round figure value with grid control in vb6

i am creating an account application.in this application i am sending the data from ms access database to MSH Flex grid through Recordset.but some columns taking 8-10 digits after decimal poing.but i want only 2-3 digit after decimal.so what is the solution of this problem.i m using double data type for that fields.i which i m facing this problem.
my code is

'MSHDATA1.ColData.Sparse = False
RSMSHDATA.Open "select distinct nop_descp as Nature_Of_Payment,posting_date as Date_Of_Payment,cus_name AS Customer_Name, tds_rate as TDS_Rate, sch_rate as Surcharge_Rate, education_cess_rate AS Education_Cess_Rate, credited_amt as Credited_Amount,in_kind as BookEntry,tds_amt as TDS_Amount,sch_amount as SurchargeAmount,education_cess_amt as EducationCessAmount,total_amt as Total_Amount from Dd_RI WHERE com_code=" & Sel_Comp_Code & " order by cus_name", CNN, adOpenDynamic, adLockBatchOptimistic, adCmdText
'MsgBox RSMSHDATA.RecordCount
Set MSHDATA1.DataSource = RSMSHDATA
Call RESIZE_FLEXGRID_COLUMNS(MSHDATA1, 2000)
RSMSHDATA.Close

so how to set the round figure value with grid control.

Reply With Quote
Reply

Viewing: Tutorialized ForumsDesktop ProgrammingVisual Basic > How to set the round figure value with grid control in vb6


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 4 hosted by Hostway