Count number, vb.net

Please support our VB.NET advertiser: Intel Parallel Studio Home
Reply

•
•
Join Date: Oct 2008
Posts: 1
Reputation: Mashimar is an unknown quantity at this point 
Solved Threads: 0
Mashimar Mashimar is offline Offline
Newbie Poster

Count number, vb.net

 
0
  #1
Nov 20th, 2008
I have a big table contain a mobile numbers, I need to count each mobile number, how many time it was entered to my table?
Reply With Quote Quick reply to this message  
•
•
Join Date: Aug 2008
Posts: 710
Reputation: Teme64 will become famous soon enough Teme64 will become famous soon enough 
Solved Threads: 115
Teme64's Avatar
Teme64 Teme64 is offline Offline
Master Poster

Re: Count number, vb.net

 
0
  #2
Nov 21st, 2008
You're talking about DB table, right?

Assuming you have mobile phone numbers in a "unified format", this SQL statement returns unique numbers and their count:
VB.NET Syntax (Toggle Plain Text) 
  1. SELECT DISTINCT(<MobileNumberField>), COUNT(<MobileNumberField>) AS MobileNumberCount FROM <tablename> GROUP BY <MobileNumberField>
Just replace field and table names before you use that.
Teme64 @ Windows Developer Blog
Reply With Quote Quick reply to this message  
•
•
Join Date: May 2008
Posts: 144
Reputation: sierrainfo is an unknown quantity at this point 
Solved Threads: 9
sierrainfo sierrainfo is offline Offline
Junior Poster

Re: Count number, vb.net

 
0
  #3
Nov 21st, 2008
SELECT DISTINCT(MobileNumber), COUNT(MobileNumber) AS RecordCount FROM MobileTable GROUP BY MobileNumber
SierraInfo
Reply With Quote Quick reply to this message  
•
•
Join Date: Jan 2009
Posts: 3
Reputation: dyadarling is an unknown quantity at this point 
Solved Threads: 0
dyadarling dyadarling is offline Offline
Newbie Poster

Re: Count number, vb.net

 
0
  #4
Jan 12th, 2009
plz...m relly need a immediate coding..
plz sumbody solve my probs..
i want to subtract my current quantity stock went m enter any amount at a textbox...
currentquantity = fullquantity - amount(type in the textbox)
then save to database
can sumbody help mee..plzzz
Reply With Quote Quick reply to this message  
•
•
Join Date: Aug 2008
Posts: 710
Reputation: Teme64 will become famous soon enough Teme64 will become famous soon enough 
Solved Threads: 115
Teme64's Avatar
Teme64 Teme64 is offline Offline
Master Poster

Re: Count number, vb.net

 
0
  #5
Jan 12th, 2009
Start a new thread for your question and you will get an answer for it.
Teme64 @ Windows Developer Blog
Reply With Quote Quick reply to this message  
•
•
Join Date: Jan 2009
Posts: 3
Reputation: dyadarling is an unknown quantity at this point 
Solved Threads: 0
dyadarling dyadarling is offline Offline
Newbie Poster

Re: Count number, vb.net

 
0
  #6
Jan 12th, 2009
i need a coding for those calculation...
help plzzz...
Reply With Quote Quick reply to this message  
•
•
Join Date: Mar 2006
Posts: 122
Reputation: manal is an unknown quantity at this point 
Solved Threads: 17
manal's Avatar
manal manal is offline Offline
Junior Poster

Re: Count number, vb.net

 
0
  #7
Jan 12th, 2009
•
•
•
•
plz...m relly need a immediate coding..
plz sumbody solve my probs..
i want to subtract my current quantity stock went m enter any amount at a textbox...
currentquantity = fullquantity - amount(type in the textbox)
then save to database
can sumbody help mee..plzzz
As Teme64 said open new thread with appropriate title and you will get more help
However,
•
•
•
•
currentquantity = fullquantity - amount(type in the textbox)
VB.NET Syntax (Toggle Plain Text) 
  1. Dim currentquantity, fullquantity As Double
  2.         currentquantity = fullquantity - CDbl(TextBox1.Text)
this is what I understand from your question

and see this link to know how to add row to Database
Last edited by manal; Jan 12th, 2009 at 2:04 pm.
"give only what u willing to receive "
Reply With Quote Quick reply to this message  
•
•
Join Date: Jan 2009
Posts: 3
Reputation: dyadarling is an unknown quantity at this point 
Solved Threads: 0
dyadarling dyadarling is offline Offline
Newbie Poster

Re: Count number, vb.net

 
0
  #8
Jan 12th, 2009
actually currentqtty n fullqtty is a field from a stock table dbase...
i'll insert any amount(textbox) at the form and went i click button save
in stock table,in currentqtty field will reduce from fullqtty..
i don need to add row in dbase...
Reply With Quote Quick reply to this message  
Reply

Quick Reply to Thread
This thread is more than three months old.
Perhaps start a new thread instead?
•
•
•
•
•
•
•
•
Message:
•
•
•
•



Similar Threads
Other Threads in the VB.NET Forum


Views: 1722 | Replies: 7
Thread Tools Search this Thread



Tag cloud for VB.NET
"crystal .net .net2005 30minutes 2005 2008 access application arithmetic array basic binary bing button buttons c# center check code combobox component connectionstring convert crystalreport data database databasesearch datagrid datagridview design dissertation dissertations dissertationthesis dll dropdownlist error excel file-dialog folder ftp google hardcopy highlighting image images inline listview login math mobile ms navigate net networking opacity output peertopeervideostreaming picturebox picturebox1 plugin port print printing problem problemwithinstallation project reports" save savedialog searchbox serial server soap sorting sql string syntax tcp text textbox timer toolbox trim updown upload usercontrol vb vb.net vb.netcode vb.nettoolboxvisualbasic2008sidebar vb2008 vbnet view visual visualbasic visualbasic.net visualstudio visualstudio2008 web wpf
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC