How to assign a variable value to datetimepicker in c#

Question

How to assign a variable value to datetimepicker in c#

Siraj SYED 1

i have a MS SQL table which has 28th field as car_transaction date it is saved as yyyy-MM-DD , i want to assign the value from this field to a variable called "mcompdate" , and after assigning, in the second form i want to take the value of mcompdate in the second form2 to datetimepicker cddate , please advise as i have tried all the given solution in the net and my source code is confusing i am not sharing the source code , i just need a portion of this solution

Thanks in advance
Siraj SYED

Karen Payne MVP 35,586 Reputation points Volunteer Moderator

2022-07-31T22:17:24.813+00:00

For the record, dates don't have a format until it's done in a query or formatted in code. In regards to assigning to mcomplete, that is dependent on a handful of ways to read data e.g. EF Core, DataAdapter, TableAdapter etc. In regards to form2, pass the value in an overloaded form constructor is the easy way.
Jack J Jun 25,296 Reputation points

2022-08-01T06:55:38.97+00:00

@Siraj SYED , Welcome to Microsoft Q&A, what is your second form for the mcompdate? I noted that you didn't share the source code, then could you provide the code just related to datetimepicker?
Siraj SYED 1 Reputation point

2022-08-07T14:41:00.793+00:00

Thank you Jack , i got the solution
Siraj SYED 1 Reputation point

2022-08-07T14:43:49.77+00:00

Please ignore my first reply.
My Question is i have a DateTimepicker (Short Format ) i want to assign value from a variable to DatetimePickers ? please help

My Email sirajsyd@réalisations .com
Bruce (SqlWork.com) 77,686 Reputation points Volunteer Moderator

2022-08-07T14:53:15.96+00:00

You convert the variable to a DateTime and use thiis to assign the DateTimerPicker.Value
Siraj SYED 1 Reputation point

2022-08-07T15:06:25.073+00:00

let me rephrase my question

Q1) datetimepicker1.Value = (DateTime)reader1["car_trndate"];
Error :
System.ArgumentOutOfRangeException: 'Value of '1/1/0001 12:00:00 AM' is not valid for 'Value'. 'Value' should be between 'MinDate' and 'MaxDate'.
Parameter name: Value'

Q2) How to assign a value from variable declared as "Public static DateTime mcompdate " to Form DataTimePicker
Code : datetimepicker1.Value = mcompdate; --- gives Error
AgaveJoe 30,126 Reputation points

2022-08-07T15:47:23.29+00:00

The error in your first question is usually due to the column (car_trndate) being empty or zero in the database. You should always check a value before trying to cast a value to a type. You did not share the table schema so it's hard to determine what you're doing. For example, In MySQL a date is defined as a Date or DateTime type which is really just a number. The format, yyyy-MM-DD, is a human readable string representation of a date.

Use the Visual Studio debugger to find the value of car_trndate and tell us what it is.

11.2.2 The DATE, DATETIME, and TIMESTAMP Types

It's hard to answer question two because you have not told us what kind of application you're building and you did not tell us what the error is.

Keep in mind, the community can only guess what logical mistakes you are making without sample code that reproduces this issue. You should be able to create a minimal example.

Your answer

Karen Payne MVP 35,586 Reputation points Volunteer Moderator

2022-07-31T22:17:24.813+00:00

For the record, dates don't have a format until it's done in a query or formatted in code. In regards to assigning to mcomplete, that is dependent on a handful of ways to read data e.g. EF Core, DataAdapter, TableAdapter etc. In regards to form2, pass the value in an overloaded form constructor is the easy way.
Jack J Jun 25,296 Reputation points

2022-08-01T06:55:38.97+00:00

@Siraj SYED , Welcome to Microsoft Q&A, what is your second form for the mcompdate? I noted that you didn't share the source code, then could you provide the code just related to datetimepicker?
Siraj SYED 1 Reputation point

2022-08-07T14:41:00.793+00:00

Thank you Jack , i got the solution
Siraj SYED 1 Reputation point

2022-08-07T14:43:49.77+00:00

Please ignore my first reply.
My Question is i have a DateTimepicker (Short Format ) i want to assign value from a variable to DatetimePickers ? please help

My Email sirajsyd@réalisations .com
Bruce (SqlWork.com) 77,686 Reputation points Volunteer Moderator

2022-08-07T14:53:15.96+00:00

You convert the variable to a DateTime and use thiis to assign the DateTimerPicker.Value
Siraj SYED 1 Reputation point

2022-08-07T15:06:25.073+00:00

let me rephrase my question

Q1) datetimepicker1.Value = (DateTime)reader1["car_trndate"];
Error :
System.ArgumentOutOfRangeException: 'Value of '1/1/0001 12:00:00 AM' is not valid for 'Value'. 'Value' should be between 'MinDate' and 'MaxDate'.
Parameter name: Value'

Q2) How to assign a value from variable declared as "Public static DateTime mcompdate " to Form DataTimePicker
Code : datetimepicker1.Value = mcompdate; --- gives Error
AgaveJoe 30,126 Reputation points

2022-08-07T15:47:23.29+00:00

The error in your first question is usually due to the column (car_trndate) being empty or zero in the database. You should always check a value before trying to cast a value to a type. You did not share the table schema so it's hard to determine what you're doing. For example, In MySQL a date is defined as a Date or DateTime type which is really just a number. The format, yyyy-MM-DD, is a human readable string representation of a date.

Use the Visual Studio debugger to find the value of car_trndate and tell us what it is.

11.2.2 The DATE, DATETIME, and TIMESTAMP Types

It's hard to answer question two because you have not told us what kind of application you're building and you did not tell us what the error is.

Keep in mind, the community can only guess what logical mistakes you are making without sample code that reproduces this issue. You should be able to create a minimal example.

Share via

How to assign a variable value to datetimepicker in c#

Your answer