i want to retrieve date field and other field from my mysql database using c# and want to show in datagridview, all field retrieve easily but exception genrated in date retriving.
//my query
string query = "SELECT accountName,_da te,typeName,bal ance FROM accounts acc, accounttypes act WHERE acc.type_id=act .type_id";