Convert a DataGridView Cell Value into a DateTime
krieg
I've been searching for some time now for this answer:
I've got a datagridview that has a cell with dates, and I need to make the value in that cell a DateTime value that can go with my DateTimePicker
So far I've done this, but it's not working, it gives me a System.FormatException (apparently it can't recognize the string as a DateTime, which sounds about right)
This is the code in question:
int index = ReservationDataGridView.SelectedRows[0].Index;
string date = ReservationDataGridView[0, 1].Value.ToString();
DateTime test = DateTime.ParseExact(date, "dd/MM/yyyy - hh:mm tt", System.Globalization.CultureInfo.InvariantCulture);
MessageBox.Show(test.ToString()
This is how my DateTimePicker is formatted:
ReservationDateTimePicker.Format = DateTimePickerFormat.Custom;
ReservationDateTimePicker.CustomFormat = "dd/MM/yyyy - hh:mm tt";
And this is how the dates look in the DataGridView:
Any ideas on how I can convert the DataGridView's Date value into a DateTime that will fit into a DateTimePicker with that formaT?
Mitch Wheat
Rather than take the string representation of the DateTime value from the DataGridview cell, instead retrieve the actual DateTime value from the DataDridview's datasource.
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
- Prev: Parse iOS SDK: Dynamic cell height for PFQueryTableViewController based on results from Query
- Next: My functions are either not declared properly or in the right place, "use strict".
Related
Related Related
- 1
How to show the complete DateTime value in a Datagridview cell when it is exactly midnight?
- 2
DataGridView Cell Value Changing
- 3
DataGridView Cell Value Changing
- 4
Hiding a value in a datagridview cell
- 5
Change DataGridView Cell Value Programmatically
- 6
change cell in datagridview to empty value
- 7
How to change value of one cell onchange of other cell value in DataGridview
- 8
Convert value to datetime
- 9
Convert the datetime value to floor
- 10
Convert the datetime value to floor
- 11
DataGridView update Cell Value while typing
- 12
Change datagridview cell value in edit mode
- 13
Restoring Previous cell value in c# datagridview
- 14
How to get image value of Datagridview Image Cell
- 15
C# retrieve cell value from datagridview
- 16
How to get a value of a cell in datagridview devexpress
- 17
Get DataGridView cell value in nested For Loops
- 18
Pass empty cell value from datagridview
- 19
Failed to convert parameter value -- Updating changes to a DataGridView
- 20
Convert an integer value to datetime in sqldf
- 21
Convert Cookie string in DateTime value
- 22
How to convert ticker value to datetime?
- 23
Datagrid change a cell value if it's default(dateTime)
- 24
Datagrid: Post String value into the Cell of a DateTime column
- 25
Issue in getting the value from datagridview cell to put into decimal
- 26
DataGridView Event to Catch When Cell Value Has Been Changed by User
- 27
How do I track the old value in a datagridview cell?
- 28
How to get cell value from DataGridView in VB.Net?
- 29
DataGridView Cell value not available for validation when inserting a new row
Comments