How Do I Obtain The Data From Access In Data Gridview By Passing A Query With Where Conditions

Question

0.00/5 (No votes)

See more:

I am using Access 2007 database with C# windows application I create a query to find the party names from the table payment_voucher using like and i also want to find the vouchers by entering voucher amount

My query is like following

select voucher_date as VCDate,voucher_code as VoucherNo,receiver_name as PartyName,expense_head_name as Purpose,voucher_amount as Amount from payment_voucher where voucher_code='" + txt_vc_number.Text + "' or receiver_name Like '" + txt_party_name.Text + "' or voucher_amount='" + amt + "'

But it does not shows the record to me if i entered R in party name text box and it also shows error when i entered amount in a amount text box

it shows the error that

Data type mismatch in criteria expression.

Please help me remove this error

Posted 4-Oct-14 21:03pm

Omkar Hendre

Updated 4-Oct-14 21:05pm

v2

Add a Solution

Comments

Richard MacCutchan 5-Oct-14 3:28am

You can fix it yourself by creating proper parameterized queries, rather than using the lazy way. Which is also wide open to SQL injection attacks. As you create each parameter you can validate the inputs and convert them to the proper types where necessary.

Omkar Hendre 5-Oct-14 3:33am

sorry sir i am new to development filed so i don't know how to validate the files and convert them but i will search for it and try to implement this thanks for big suggestions

Omkar Hendre 5-Oct-14 3:43am

sir i try to execute the above query in every manner but does not give any records can you please help me to solve my problem

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)

Mehdi Gholam · Accepted Answer · 2014-10-04T21:48:00

Solution 1

Try removing the single quote around the amt variable:

C#

select voucher_date as VCDate,voucher_code as VoucherNo,receiver_name as PartyName,expense_head_name as Purpose,voucher_amount as Amount from payment_voucher where voucher_code='" + txt_vc_number.Text + "' or receiver_name Like '" + txt_party_name.Text + "' or voucher_amount=" + amt + "

Posted 4-Oct-14 21:48pm

Mehdi Gholam

Comments

Omkar Hendre 5-Oct-14 3:59am

Yes sir i remove it but like is not working

Mehdi Gholam 5-Oct-14 4:03am

If you want to search inside a value with like you should use % before and after the variable -> like '%" + txt_party_name.Text + "%'

Omkar Hendre 5-Oct-14 4:10am

wait i check it and let you know and thanks for helping me

Omkar Hendre 5-Oct-14 4:11am

Great it works fine but if i want to check for starting letter then what i should do

Omkar Hendre 5-Oct-14 4:12am

i got it

Omkar Hendre 5-Oct-14 4:12am

Thank You So Much Sir Thanks A Lot

Omkar Hendre 5-Oct-14 4:14am

Sir i have one more query can you please help me