|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
 |
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
|
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
Dev Articles Community Forums Sponsor:
|
|
|
|
#1
May 31st, 2005, 04:33 AM
|
|||
|
|||
|
HOW to count records in database??
in my database each doctor has multiple slips (one to many)..i want to cout the total
number of slips for each doctor and display it in the datagrid...in a culomn called "Uncompleted Slips".. so it will display the total number of slips near the doctor name How can i do that?? SQL Server 2000
|
|
#2
June 17th, 2005, 06:57 AM
|
|||
|
|||
|
i think u can use following query for that
select count(slips) from <table name> where doctorname=' specify name ' Quote:
|
|
#3
June 30th, 2005, 07:42 AM
|
|||
|
|||
|
One way (most efficient? I dunno) to do this is query, like the reply above, load it into a dataset. Then use myDS.count (I think that's it, not sure of specifics, but I know there is an attribute of a dataset called count that tells how many records have been loaded into it.)
|
|
| Viewing: Dev Articles Community Forums > Programming > .NET Development > HOW to count records in database?? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
