How Can Search Between To Date By dateTimePicker1

Question

0.00/5 (No votes)

See more:

string sqlstr3 =
"select rnh.ReceiptNote_id, rnh.Customer_id,rnh.Customer_Name,rnh.Receipt_Type,rnd.Product_Id,rnd.Product_name
,rnd.Quantity,rnd.Price,rnh.Receipt_Date from Receipt_NoteDetalisTBL as rnd
inner join Receipt_NoteHeadTBL as rnh on rnh.ReceiptNote_id=rnd.Fk_ReceiptNote_id
inner join StoresTBL as st on st.Store_id=rnh.Store_id
inner join Products_TBL as pt on pt.Product_id=rnd.Product_Id
WHERE rnd.Product_Id = @Product_Id and rnh.Receipt_Date between

@dateTimePicker1.Value.ToString("yyyy-MM-dd")
and @dateTimePicker1.Value.ToString("yyyy-MM-dd") ";

using (SqlDataAdapter dr3 = new SqlDataAdapter(sqlstr3, CS))
{
dr3.SelectCommand.Parameters.AddWithValue("@Product_Id", txtProductId.Text );
dr3.Fill(dt3);
dataGridView1.DataSource = dt3;
}

Posted 25-Apr-15 20:20pm

Member 11280947

Add a Solution

Comments

Richard MacCutchan 26-Apr-15 3:08am

Don't use strings for dates, use proper DateTime fields.

Member 11280947 26-Apr-15 3:25am

How

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)

OriginalGriff · Answer 1 · 2015-04-25T21:35:00

Solution 1

Try:

SQL

... WHERE rnd.Product_Id = @Product_Id and rnh.Receipt_Date between @DT1 AND @DT2";

using (SqlDataAdapter dr3 = new SqlDataAdapter(sqlstr3, CS))
{
dr3.SelectCommand.Parameters.AddWithValue("@Product_Id", txtProductId.Text );
dr3.SelectCommand.Parameters.AddWithValue("@DT1", @dateTimePicker1.Value);
dr3.SelectCommand.Parameters.AddWithValue("@DT2", @dateTimePicker1.Value);

Posted 25-Apr-15 21:35pm

OriginalGriff

Comments

Member 11280947 26-Apr-15 3:58am

When Select The day it give me The sacuund day
like if select day 9 it give me 10
How can select specific Day

OriginalGriff 26-Apr-15 4:02am

Do you want to try explaining that to someone who can't see your screen? :laugh:
Perhaps an example of the data you store, the values you pass, the results you get, and the results you expect?

Member 11280947 26-Apr-15 5:58am

I don't Understand

Member 11280947 26-Apr-15 6:06am

WHERE rnd.Product_Id = @Product_Id and rnh.Receipt_Date >= @DT1 AND <= @DT2";
how Can do that

OriginalGriff 26-Apr-15 6:09am

Either use BETWEEN as in my example, or
WHERE rnd.Product_Id = @Product_Id and rnh.Receipt_Date >= @DT1 AND rnh.Receipt_Date <= @DT2"

Member 11280947 26-Apr-15 6:14am

OK but way when i need to select date i mast select day before