how to verify/check the database table that only 20 record belong to this groupname in button?

Question

0.00/5 (No votes)

See more:

i have a aspx page which contain a textbox (txtStudentName) and a drop box (dropdownlistGroupName) and a save button

student table
    StudentID StudentName GroupID
       1         ABC        1
       2         DEF        1
       3         GHI        2

Group table   
GroupID      GroupName
    1           Pear
    2           Apple
    3           Strawberry

when i click on save button it will insert in student, saying that this student belong to this groupname

but at the save button.. how am i going to check / validate that this groupname like example Apple will only have 20 student belong to Apple group, if user click on saving the 21 student, it should prompt a message saying that this Apple group is full

i not sure how to i check with the database?

so what i should i do in the button backend code?

hope someone can tell me what should i do with some sample which will be nice and easy for me understand

thanks

Posted 6-Jan-12 21:22pm

cutexxbaby

Updated 6-Jan-12 21:48pm

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Supriya Srivastav · Answer 1 · 2012-01-06T21:31:00

Solution 1

Select COUNT(*) as [No. of Students] from student where GroupID=1

Check the returned No. of students in code and flash message.

Posted 6-Jan-12 21:31pm

Supriya Srivastav

Comments

cutexxbaby 7-Jan-12 3:48am

can you give me a much clear code that i should do in the button instead of just this one line?it will be really helpful to me, thank

cutexxbaby 7-Jan-12 3:50am

like example where should i state the >20 then should a message to tell it cannot save

OriginalGriff · Answer 2 · 2012-01-06T21:32:00

Solution 2

Try:

SQL

SELECT COUNT(*) AS InGroup FROM student WHERE GroupID=2

"can you give me a much clear code that i should do in the button instead of just this one line?it will be really helpful to me, thank"

using (SqlConnection con = new SqlConnection(strConnect))
    {
    con.Open();
    using (SqlCommand com = new SqlCommand("SELECT COUNT(*) AS InGroup FROM student WHERE GroupID=2", con))
        {
        int count = com.ExecuteScalar())
        ...
        }
    }

Posted 6-Jan-12 21:32pm

OriginalGriff

Updated 6-Jan-12 22:01pm

v2

Comments

cutexxbaby 7-Jan-12 3:48am

can you give me a much clear code that i should do in the button instead of just this one line?it will be really helpful to me, thank

OriginalGriff 7-Jan-12 4:02am

Answer updated.

cutexxbaby 7-Jan-12 4:27am

so i just need to call this code in the button , then i can check if student table groupID =1 ...but where should i indicate that cannot more than 20 student have groupID ...if the 21 student is going to be save, it should prompt a message to inform user

OriginalGriff 7-Jan-12 4:40am

That bit is down to you! :laugh:
I don't know how your pages work - how would you display the "Done it" message, or any other?

cutexxbaby 7-Jan-12 5:54am

no i mean WHERE in button should i indicate that count that cannot be more than 20, or i will prompt it

OriginalGriff 7-Jan-12 6:09am

Pardon? I don't understand.
Try explaining in more detail what you are trying to do - remember I can't see your code, your pages, or anything...

cutexxbaby 7-Jan-12 8:50am

what i mean was
rmb in the button you told me to count right
So where should i indicate that if the count value is 20 , then i will prompt a message
is it in the connection code that you show me above ? before that?

OriginalGriff 7-Jan-12 9:57am

Replace the three little dots with your code.
The variable "count" will hold the number of records that are in the group.