how to set the date condition

Question

0.00/5 (No votes)

See more:

Dear Friends

I want to retrieve data from the sql database when selecting a date and itemtype but data not retrieve. without date condition its working fine. please tell me how to solve it.

query = "select sum(txtPurity) from EntryTable where txtDate='" + this.txtDate.Value.Date + "' AND cmbItemType='" + cmbItemType.Text + "'";

Posted 5-Oct-13 15:51pm

indiancodinglove

Add a Solution

Comments

Pradeep Shukla 5-Oct-13 22:09pm

The datetime field in db is of datetime type. Convert the data you are passing in datetime for comparison with the field.

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)

Abhinav S · Accepted Answer · 2013-10-05T17:57:00

Solution 1

This could be a formatting issue. Go through answers at compare two datetime using sql server[^].

Posted 5-Oct-13 17:57pm

Abhinav S

Comments

indiancodinglove 6-Oct-13 1:35am

This query is working but when I am selecting less then txtDate its not give that date data.
it gives sum of all the field not that date of data.

query = "select sum(txtPurity) from EntryTable where txtDate > convert(datetime,'06-10-2013') AND cmbItemType='" + cmbItemType.Text + "'";

indiancodinglove 6-Oct-13 2:30am

I also try this coding but not working

string query = null;
query = "select sum(txtPurity) from EntryTable where txtDate =@Date AND cmbItemType='" + cmbItemType.Text + "'";
SqlConnection conn = new SqlConnection(connstr);
SqlCommand cmd = new SqlCommand(query, conn);
cmd.Parameters.AddWithValue("@Date", txtDate.Value.Date);
conn.Open();
SqlDataReader sqlReader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
if (sqlReader.Read())
{
txtSumOfPurity.Text = sqlReader[0].ToString();
}
conn.Close();

Azee 6-Oct-13 3:44am

hey there, what is the DataType of column txtDate, Date or DateTime?

indiancodinglove 6-Oct-13 8:54am

DateTime