Loading data from Access to Datagridview

Check the actual data in the database table. Check that the dates are entered correctly without any discrepancies. And also check the time zone or regional settings on the machine where the application is running and where the database is hosted. A difference in time zone settings can affect how dates are displayed.

hi Sachin,

Thanks for your reply. Actually, the issue is when the Date is January which will yield 0, causing error. After adding the AddMonths(+1), I still get the error.

            connection = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + strAccessPath + ";Persist Security Info=False;");
            dataAdapter = new OleDbDataAdapter("SELECT * FROM BERData", connection);
            dataTable = new System.Data.DataTable();

            foreach (DataRow row in dataTable.Rows)
            {
                // Assuming the date is in a column named "Date1"
                DateTime originalDate = (DateTime)row["Date1"];
                DateTime adjustedDate = originalDate.AddMonths(+1);

                row["Date1"] = adjustedDate;
            }

            dataAdapter.Fill(dataTable); //ERROR HERE

            dataGridView1.DataSource = dataTable;

At this point, the datatable is still empty. the anomaly happened during the dataAdapter fill.

check the locale settings first, add these lines before filling the datagrid

// Set culture explicitly (e.g., for English-US)
System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US");
System.Threading.Thread.CurrentThread.CurrentUICulture = new System.Globalization.CultureInfo("en-US");

if even after the changes it doesn't work then just do what is needed

foreach (DataRow row in dataTable.Rows)
{
    // Assuming the date is in a column named "YourDateColumn"
    DateTime originalDate = (DateTime)row["YourDateColumn"];
    DateTime adjustedDate = originalDate.AddMonths(-1);

    row["YourDateColumn"] = adjustedDate;
}