Retrieving date and time value from Database

Question

0.00/5 (No votes)

See more:

Dear All I've a search form, from where i want to retrieve saved date and time values. I've two dateandimepickers which enable a user to select two different date and time from one coloumn of database. I've used BETWEEN FUNCTION but when i am running it, it gives me an error "Conversion failed". Because the date is saved in 2012/01/02 format and DATEANDTIMEPICKER Format is Wednesday April 2012! How can i retrieve it please?

Here is the code :

C#

SqlDataAdapter commm = new SqlDataAdapter("Select * from Donor where [Planned Start Date] Between '"+ dtpSBPlannedStartDate.Checked+"' And '"+ dateTimePicker1.Checked +"' ", con);
                DataSet dsss = new DataSet();
                
                commm.Fill(dsss, "Donor");
                if (dsss.Tables["Donor"].Rows.Count != 0)
                {
                    dataGridView1.DataSource = dsss.Tables["Donor"];
                }
                else
                {
                    MessageBox.Show("Record Not Found..........");
                }

Posted 10-Apr-12 21:32pm

NaserDostdar

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)

OriginalGriff · Answer 1 · 2012-04-10T21:49:00

Solution 2

Um. You do realise that the DateTimePicker.Checked[^] property is a bool, not a DateTime? Perhaps you want the Value property? And to pass it with a Parametrized query?

Posted 10-Apr-12 21:49pm

OriginalGriff

swapnilKumbhar · Answer 2 · 2012-04-10T21:49:00

Try this...
string DateTo=null,DateFrom=null;
private void SetDateFormat()
{
DateTimePicker1.CustomFormat="yyyy/MM/dd";
DateTimePicker1.Format=DateTimePickerFormat.Custom;
DateTo=DateTimePicker1.Text;
DateTimePicker1.Format=DateTimePickerFormat.Long;//Set Format as per your needs

DateTimePicker2.CustomFormat="yyyy/MM/dd";
DateTimePicker2.Format=DateTimePickerFormat.Custom;
DateFrom=DateTimePicker2.Text;
DateTimePicker2.Format=DateTimePickerFormat.Long;//Set Format as per your needs
}

then Call this Fuction Before Query..like this

YourFunction()
{
SetDateFormat();
string query="Select * from Table_Name where DateTable_name BETWEEN '"+ DateTo +"' AND '"+ DateFrom +"'";
.
.
}

Hope this helps you..

Nilesh Patil Kolhapur · Answer 3 · 2012-04-10T22:13:00

Solution 3

hi check [Planned Start Date] column have datatype DateTime or smalldatetime
if not then change it to smalldatetime

best Luck
Happy Coding

Posted 10-Apr-12 22:13pm

Nilesh Patil Kolhapur