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: 1719 | Replies: 7
Thread Tools Search this Thread



Tag cloud for VB.NET
.net .net2008 2005 2008 access account application array arrays basic bing button buttons c# center check checkbox code convert crystalreport data database datagrid datagridview date dissertation dissertations dropdownlist excel fade file-dialog filter ftp generatetags google gridview hardcopy images inline input insert intel internet listview mobile monitor ms net networking objects output panel passingparameters picturebox port position print printing problem project read remove save searchbox searchvb.net select serial server shutdown soap sorting survey syntax table tcp temperature text textbox timer timespan toolbox trim update user validation vb vb.net vb.netformclosing()eventpictureboxmessagebox vb2008 vbnet view visual visualbasic visualbasic.net visualstudio2008 web webbrowser winforms wpf year
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC