Datasource accdb database SQL between two dates ???

Question

0.00/5 (No votes)

See more:

Hello
I have windowsform in C# made in Visual Studio 2010, datasource is ACCESS 2007 accdb database. I have report with two datetime pickers which I joined F_date and T_ date but SQL doesnt work, specifically @F_date And @T_date.
it seems that @ doesnt work with accdb source file
because when I made new table without accdb as datasource then it works
I need help with the sql
down here is the sql that I am talking about, I bold the problem

SQL

SELECT RB, Bankomat, Datum_otvaranja, Vreme_prijave, ProView_vreme, Naziv_dogadjaja, Preduzeta_mera, Napomena FROM dnevni_izvestaj
WHERE Datum_otvaranja BETWEEN @F_date And @T_date

[Edited]Code is blocked in "pre" tags[/Edited]

Posted 6-Feb-11 2:28am

shonezi

Updated 6-Feb-11 2:40am

RaviRanjanKr

v2

Add a Solution

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)

Eddy Vluggen · Accepted Answer · 2011-02-06T02:43:00

Solution 1

Are you querying over Odbc or OleDb? If so, then you should use a question-mark as a parameter-indication.

See the section Working with Parameter Placeholders
[^] :)

Posted 6-Feb-11 2:43am

Eddy Vluggen

Comments

shonezi 6-Feb-11 9:07am

It's OleDb connection, so how does the code should look like?

Henry Minute 6-Feb-11 9:20am

For OleDb you are supposed to use positional parameters
WHERE Datum_otvaranja BETWEEN ? And ?

Because they are positional you must be very careful to add your parameters in the correct order.
This page has an example
http://weblogs.asp.net/cibrax/archive/2006/09/28/Parameterized-Queries-_2800_Oracle_2C00_-SQLServer_2C00_-OleDb_2900_.aspx (The last example.

Eddy Vluggen 6-Feb-11 9:36am

As described on that page. Is there anything unclear in the documentation?

shonezi 6-Feb-11 9:38am

I will look on it later, and let you know. thanks a lot

shonezi 6-Feb-11 16:50pm

I have trouble with this parameter queries cause code from above is in dataset from which report was made

Eddy Vluggen 6-Feb-11 16:54pm

Datatables provide their own select-method;
http://msdn.microsoft.com/en-us/library/det4aw50.aspx

shonezi 7-Feb-11 3:39am

I am still in a jam, maybe I didn't explain it well, this is what I want: I have a table called dnevni_izvestaj, in that table I have a date column called Datum_otvaranja, this table is OLE DB from access 2007 as datasource. I have a form with reportviewer, two datetimepickers and a button, I have dataset with imported table dnevni_izvestaj on it. I choose dates from those datetimepickers and then clicking on button to open report based on chosen dates. sql is in dataset and I am stcuk, I am a newbie in visual studio, but I worked in access although no help with access sql in visual :)

shonezi 7-Feb-11 5:29am

OK I did this

SELECT RB, Bankomat, Datum_otvaranja, Vreme_prijave, ProView_vreme, Naziv_dogadjaja, Preduzeta_mera, Napomena FROM dnevni_izvestaj
WHERE Datum_otvaranja BETWEEN ? And ?

and I got what I wanted but I just need to put code on the button to generate report and I am in a jam

shonezi 7-Feb-11 12:50pm

I got it

SELECT RB, Bankomat, Datum_otvaranja, Vreme_prijave, ProView_vreme, Naziv_dogadjaja, Preduzeta_mera, Napomena FROM dnevni_izvestaj
WHERE Datum_otvaranja BETWEEN ? And ?

and I joined code on datetimepicker

DateTime Datum_otvaranja = dateTimePicker1.Value;
DateTime Datum_otvaranja1 = dateTimePicker2.Value;

because in SQL I have put question mark ? that made Datum_otvaranja and Datum_otvaranja1

anyway , it works, thanks a lot mate

Eddy Vluggen 7-Feb-11 13:08pm

Aight, well done :D

I'm just home, am not allowed to post much from work, but been following the updates. I was formulating a new post in the train, loved to see the 'I got it' - and without much help. My compliments :)