How Do I Set Previous Date In Datetime Control

Question

4.00/5 (1 vote)

See more:

I want to retrieve previous date from database in datetime control.

what I tried is

C#

queryString = "SELECT Startdate FROM master WHERE srno="+ t +"";
while (dr.Read())
{                    
    DateTime stdate = Convert.ToDateTime(dr.GetValue(2).ToString());
    this.dtpBlockStartDate.Value = new DateTime(stdate.Year , stdate.Month , stdate.Day);
}

datetime control is displaying current date and not the date from database.

Posted 25-Aug-14 0:56am

sachees123

Updated 25-Aug-14 1:01am

Thanks7872

v2

Add a Solution

Comments

Neetin_1809 25-Aug-14 7:26am

modify Your QUeryString to TOp 1 clause and Use Order By Clause

sachees123 25-Aug-14 7:38am

getting date is not a problem, but getting it displayed in datetime control is a BIG problem. Also there are many other fields in query.

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)

Raul Iloc · Answer 1 · 2014-08-25T01:22:00

Solution 1

1.The parameter t from your command should be the date that you want, if you want yesterday should be:
DateTime t = DateTime.Now.AddDays(-1);

2.Then you should refine your reading code like this:

C#

if(dr.Read())
{
    this.dtpBlockStartDate.Value = (DateTime)dr["Startdate"]; 
}

Posted 25-Aug-14 1:22am

Raul Iloc

Kim Togo · Answer 2 · 2014-08-25T01:25:00

When you are working with date and time objects. Then do not convert it to a string.
Only convert to a string when you want to show it to the user.

If table column "Startdate" is a datetime type in MS SQL. You can use the value direct like:

C#

var sqlConnection= new SqlConnection(sqlConnectionString);
sqlConnection.Open()

var sqlCommand = sqlConnection.CreateCommand();
sqlCommand.CommandText = "SELECT Startdate FROM master WHERE srno=@srno";
sqlCommand.Parameters.AddWithValue("srno", t);

object result = sqlCommand.ExecuteScalar();

if (result != null)
{
  dtpBlockStartDate.Value = (DateTime)result;
}

Remember to use parameterized sql statement :-)
http://blog.codinghorror.com/give-me-parameterized-sql-or-give-me-death/[^]

Neetin_1809 · Answer 3 · 2014-08-25T02:16:00

Hello ,
If you DataType is DateTime & Using with C#.Try the Following Code to set a value.
There is a CustomFormat Property for the DatePicker control that is needed to be specified.

C#

dtpBlockStartDate.CustomFormat = "dd-MMM-yyyy";
dtpBlockStartDate.Value =Convert.ToDateTime(ds.Tables[0].Rows[0][0]);

ds refers to dataset & i am suposing that it is in first column.

Try To debug it .SomeWhere you might be resetting it to Currrent Date.

If any Problem Then Paste Your Complete Code
Hope It Helps You
Happy coding :-)

How Do I Set Previous Date In Datetime Control

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0