Click here to Skip to main content
15,499,802 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: copy object attributes [modified] Pin
Dave Kreskowiak16-May-07 7:24
mveDave Kreskowiak16-May-07 7:24 
QuestionDevelop Audio Video Conferencing System Pin
Rupesh Kumar Swami16-May-07 6:46
MemberRupesh Kumar Swami16-May-07 6:46 
AnswerRe: Develop Audio Video Conferencing System Pin
Dave Kreskowiak16-May-07 7:14
mveDave Kreskowiak16-May-07 7:14 
Questioncount number of rows in table Pin
peteyshrew16-May-07 4:40
Memberpeteyshrew16-May-07 4:40 
AnswerRe: count number of rows in table Pin
kubben16-May-07 5:01
Memberkubben16-May-07 5:01 
GeneralRe: count number of rows in table Pin
peteyshrew16-May-07 5:19
Memberpeteyshrew16-May-07 5:19 
GeneralRe: count number of rows in table Pin
peteyshrew16-May-07 5:34
Memberpeteyshrew16-May-07 5:34 
GeneralRe: count number of rows in table Pin
Dave Kreskowiak16-May-07 5:39
mveDave Kreskowiak16-May-07 5:39 
This depends on the datatype of the "Sex" column and what data is in it. What you have will work, so long as the column is one of the character types and only contains F or M. If there are spaces in the data or other garbage that shouldn't be there, your query is going to have a difficult time picking out the correct rows.

Provided the table was setup correctly and the data was validated before it was written to the table, something like this should work:
SELECT COUNT(Sex) FROM Pupils WHERE Sex='F'



A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
     2006, 2007


Questionsyntax error Pin
peteyshrew16-May-07 4:05
Memberpeteyshrew16-May-07 4:05 
AnswerRe: syntax error Pin
andyharman16-May-07 4:53
professionalandyharman16-May-07 4:53 
GeneralRe: syntax error Pin
peteyshrew16-May-07 5:19
Memberpeteyshrew16-May-07 5:19 
QuestionInsert Stored Procedure taking values from vb Help Pin
Vimalsoft(Pty) Ltd16-May-07 4:00
professionalVimalsoft(Pty) Ltd16-May-07 4:00 
AnswerRe: Insert Stored Procedure taking values from vb Help Pin
Dave Kreskowiak16-May-07 5:11
mveDave Kreskowiak16-May-07 5:11 
GeneralRe: Insert Stored Procedure taking values from vb Help Pin
Vimalsoft(Pty) Ltd16-May-07 5:19
professionalVimalsoft(Pty) Ltd16-May-07 5:19 
GeneralRe: Insert Stored Procedure taking values from vb Help [modified] Pin
Vimalsoft(Pty) Ltd16-May-07 5:19
professionalVimalsoft(Pty) Ltd16-May-07 5:19 
GeneralRe: Insert Stored Procedure taking values from vb Help Pin
Dave Kreskowiak16-May-07 5:31
mveDave Kreskowiak16-May-07 5:31 
Questionhow do i edit a selected row or record in sql database through datagrid during runtime? Pin
sathyan_829416-May-07 3:51
Membersathyan_829416-May-07 3:51 
AnswerRe: how do i edit a selected row or record in sql database through datagrid during runtime? Pin
Dave Kreskowiak16-May-07 5:29
mveDave Kreskowiak16-May-07 5:29 
AnswerRe: how do i edit a selected row or record in sql database through datagrid during runtime? Pin
Xandip16-May-07 19:32
MemberXandip16-May-07 19:32 
Questionfitting application screen resolution and size Pin
balakpn16-May-07 3:44
Memberbalakpn16-May-07 3:44 
AnswerRe: fitting application screen resolution and size Pin
Dave Kreskowiak16-May-07 5:26
mveDave Kreskowiak16-May-07 5:26 
GeneralRe: fitting application screen resolution and size Pin
balakpn16-May-07 21:42
Memberbalakpn16-May-07 21:42 
GeneralRe: fitting application screen resolution and size Pin
Dave Kreskowiak17-May-07 3:44
mveDave Kreskowiak17-May-07 3:44 
QuestionHow to convert HTML to Doc, pdf, rtf Pin
Kumaran21cen16-May-07 2:54
MemberKumaran21cen16-May-07 2:54 
AnswerRe: How to convert HTML to Doc, pdf, rtf Pin
andyharman16-May-07 4:59
professionalandyharman16-May-07 4:59 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.