943,822 Members | Top Members by Rank

Software Development > VB.NET > Count number, vb.net
Ad:
  • VB.NET Discussion Thread
  • Unsolved
  • Views: 5467
  • VB.NET RSS
Permalink
Nov 20th, 2008
0

Count number, vb.net

Expand Post »
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?
Reputation Points: 10
Solved Threads: 0
Newbie Poster
Mashimar is offline Offline
1 posts
since Oct 2008
Permalink
Nov 21st, 2008
0

Re: Count number, vb.net

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.
Reputation Points: 218
Solved Threads: 201
Veteran Poster
Teme64 is offline Offline
1,024 posts
since Aug 2008
Permalink
Nov 21st, 2008
0

Re: Count number, vb.net

SELECT DISTINCT(MobileNumber), COUNT(MobileNumber) AS RecordCount FROM MobileTable GROUP BY MobileNumber
Reputation Points: 10
Solved Threads: 9
Junior Poster
sierrainfo is offline Offline
144 posts
since May 2008
Permalink
Jan 12th, 2009
0

Re: Count number, vb.net

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
Reputation Points: 10
Solved Threads: 0
Newbie Poster
dyadarling is offline Offline
3 posts
since Jan 2009
Permalink
Jan 12th, 2009
0

Re: Count number, vb.net

Start a new thread for your question and you will get an answer for it.
Reputation Points: 218
Solved Threads: 201
Veteran Poster
Teme64 is offline Offline
1,024 posts
since Aug 2008
Permalink
Jan 12th, 2009
0

Re: Count number, vb.net

i need a coding for those calculation...
help plzzz...
Reputation Points: 10
Solved Threads: 0
Newbie Poster
dyadarling is offline Offline
3 posts
since Jan 2009
Permalink
Jan 12th, 2009
0

Re: Count number, vb.net

Quote ...
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,
Quote ...
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.
Reputation Points: 37
Solved Threads: 17
Junior Poster
manal is offline Offline
122 posts
since Mar 2006
Permalink
Jan 12th, 2009
0

Re: Count number, vb.net

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...
Reputation Points: 10
Solved Threads: 0
Newbie Poster
dyadarling is offline Offline
3 posts
since Jan 2009

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in VB.NET Forum Timeline: List open office files
Next Thread in VB.NET Forum Timeline: Common References not recognised in VS2008





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC