prblem related to query

Question

0.00/5 (No votes)

See more:

Hello friends,
I am making report and I have one issue such that when we selecting employee from combobox and run the report then it must show particular employee.
And when I select nothing and run report then all employee from database must be display on report.so what kind of query I should write.

Posted 29-Dec-12 22:52pm

Tejas11C

Add a Solution

3 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)

Dheerendra Dwivedi · Answer 1 · 2012-12-30T16:31:00

Solution 3

for particular Employee you write where condition in if clause and when you want to all employee information you code normal select query in else clause.............

Posted 30-Dec-12 16:31pm

Dheerendra Dwivedi

Jibesh · Answer 2 · 2012-12-29T23:43:00

Solution 2

you havent mentioned any code so we have fair idea of your data's. but with that knowledge a sample query may be help you to get going.

you need to write a select query with where condition to filter out the matching employee name. if filter is empty select all.
eg:

SQL

select * from employeeTable; // this query will return all the rows inside the table employeeTable

select * from employeeTable where EmployeeName = txtFromCombo; // this will return row that matching the EmployeeName equals to the value txtFromCombo where txtFromCombo is a string.

Posted 29-Dec-12 23:43pm

Jibesh

Comments

Tejas11C 30-Dec-12 5:54am

no i want two query to be executed at a time(when i select employee it filters that particular employee but if i don't select any employee then it automatically generates reports of all employees means like a if else statements) and i want to write this query in table adapter in visual studio

Jibesh 30-Dec-12 6:00am

are you using any stored procedure?

Jibesh 30-Dec-12 6:45am

you can use the If else statement in your stored procedure if your using a SP otherwise you need to build a two queries. I dont think that you can have single query with and without where condition.

Ronjon1 · Answer 3 · 2012-12-29T23:25:00

Solution 1

//you can get the combo value in this way

SQL

if (combo.Text  != "Please Select" && combo.Text  != "All"){
MessageBox.Show("Employee Id is "+ cboItemName.SelectedValue.ToString());
}
else
{
MessageBox.Show("No Employee Select");
}
</pre>

May this help you

Posted 29-Dec-12 23:25pm

Ronjon1

Comments

Jibesh 30-Dec-12 5:43am

This is not the right solution for the OPs question. OP is asking about how to prepare the query and not to select the combo.

Ronjon1 30-Dec-12 6:00am

what do you mean i just tell him, how can he get the id from combo box ....

Jibesh 30-Dec-12 6:03am

Yes. but thats not what he is asking for. read his question.
'problem related to query' and '... what kind of query i should write'