How I fill the DataTable with data from the mysql db with datetime columns?

[dhvrm]

hi i want get data from a mysql database and I have the problem that I son't can fill my DataTable with the MySQlDataAdapter :/ \[code\]public static DataTable GetAllAccountingDataTable(string connectionstring) { using (con = new MySqlConnection(connectionstring)) { string sql = "SELECT Username,AcctStartTime,AcctStopTime,FramedIPAddress FROM radacct"; MySqlCommand command = new MySqlCommand(sql, con); MySqlDataAdapter adapter = new MySqlDataAdapter(command); DataTable tb = new DataTable(); adapter.Fill(tb); // here is the error con.Open(); command.ExecuteReader(); return tb; } }\[/code\]\[quote\] error: Unable to convert MySQL date/time value to System.DateTime\[/quote\]the types of my columns in the mysql database:\[code\]Username : varcharAcctStartTime : datetimeAcctStopTime : datetimeFramedIPAddres : varchar\[/code\]what can I do?