How to count records in database

[Kosal]

Dear All

Can you help me to do as below

I need to count record in database using VB.net 2005 in the table(id, product, quentity, unitprice, sName) and form interface had one textbox when i input supplier name into textbox and click button count it show number of supplier,

please help to give me the code for this.

thanks

[DrBunchman]

Hi Kosal,

You don't say which database you use but you can use the COUNT function.

In SQL Server for example the syntax is:

 SELECT COUNT(*) FROM Table WHERE id = 123

Hope this helps,

Dr B

[r035198x]

When the button is clicked just do a select count(*) for the suppliers.
It does not have to (and should not) be linked with the entering of suppliers themselves.

Edit: Too late ...

[Kosal]

ok thanks

but i need to count supplier name not count id

[DrBunchman]

You can count whatever you like.

SELECT COUNT(*) WHERE .....

will return a count of all the records whose conditions satisfy your WHERE clause.

Dr B

[r035198x]

ok thanks

but i need to count supplier name not count id

Suppose there are only two suppliers in the table and they both have the same name, then should it show one or two?

[Kosal]

Hello sir
now it is ok
thank you for your help

[rk4088]

select count(sname) from table;