How To Check Particular Details Of Person If I Select Id In Combobox

Question

1.00/5 (2 votes)

See more:

I have done school management system project ,in this system student has to pay his fee in three terms .he had to pay his first term fees ,and he will come to pay his second term now if i select id from combo box it should display like this
"the first term fee has to be paid by ...."
how to do this(windows forms applications in c#.net,sql server2008r2 and it is desktop application )
i was try the following code but it display error

SQL

if ("select term_number from term_fee_details where admin_no='" + comboBox2.Text + "' and term_number='first term'")
                    {                        MessageBox.Show("First term fee has paid");                   }

thank you

Posted 30-Oct-14 1:20am

Member 11065510

Updated 31-Oct-14 1:23am

v3

Add a Solution

Comments

Nathan Minier 30-Oct-14 7:38am

Web Forms, MVC, something else...?

Member 11065510 30-Oct-14 7:39am

web forms

ZurdoDev 30-Oct-14 7:50am

Do you have a question?

BillWoodruff 30-Oct-14 8:29am

It looks like you are trying to figure out how to access a database when a certain ID is selected in a ComboBox. Is that what you are trying to do ?

Member 11065510 31-Oct-14 6:27am

no....but i dont know how to describe my requirement it too long

1 solution

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)

agent_kruger · Answer 1 · 2014-10-31T01:14:00

Solution 1

sir, sorry to be rude but what kind of if condition is that? just a string? and we cant help you till you decide in which platform you are building your software. i request you re-frame your question to be able to get answered.

Posted 31-Oct-14 1:14am

agent_kruger

Comments

Member 11065510 31-Oct-14 7:25am

SqlCommand firstterm = new SqlCommand("select termnumber from term_fee_details where termnumber='first term' and admin_no=('" + comboBox2.Text + "')");
if (firstterm.ExecuteNonQuery()== true)
{
MessageBox.Show("first term paid");
}
i was use this code also but it display error