String was not recognized as a valid Date Time | Date conversion problem Visual Studio C# VBA

String was not recognized as a valid DateTime.
C#, VBA, Java, SQL Server.
I am trying to convert my string formatted value to date type with format dd/MM/yyyy. I am getting the above exception in my application /website. I searched for the above error and found the following Solution.
Problem (Error) :
The error shown in question have been thrown by Convert.ToDateTime method.
Example: string dateString = @"30/06/1991";
DateTime date = Convert.ToDateTime(dateString);
In the above code, the dateString represents Date in the Day/Month/Year format.
By default, the en-US culture is used by .NET according to which the Date is in Month/Day/Year format. So, when ToDateTime method is used it throws error as 30 is out of the Month range.

Solution:
Method No. 1
To avoid this error the appropriate culture can be used as follows;
string dateString = @"30/06/1991";
DateTime date2 = Convert.ToDateTime(dateString,
System.Globalization.CultureInfo.GetCultureInfo("hi-IN").DateTimeFormat);

this Method we have explained in the tutorial video.

Method No. 2
the ParseExact method can be used with the required custom format as shown below:
string dateString = @"30/06/1991";
DateTime DOB= DateTime.ParseExact(dateString, @"d/M/yyyy",
System.Globalization.CultureInfo.InvariantCulture);

#dateTimeCoversionException
#dateTimeConvertError

Hafeez Computers Thakot
HCT
SQL date conversion | Convert Date format into DD/MM/YYYY format in SQL Server https://www.youtube.com/watch?v=WBUqTb5BidA


RDLC Tablix sum error | visual Studio | Report error C#
https://www.youtube.com/watch?v=7iDVp9aRMzk&t=25s

how to add Microsoft RDLC Report Designer in Visual Studio C#? ( RDLC file open in XML code Solved)
https://youtu.be/dXOlANST8E4

could not load file or assembly | Microsoft Report Viewer SQL Server | Visual Studio Application https://www.youtube.com/watch?v=iNKgakyXpKI&t=44s

An error occurred When attaching the database | MDF file Cannot attach SQL Server Solved https://www.youtube.com/watch?v=dHIRCE5BtKg&t=28s