private void LoadData()
{
setConnection();
sql_con.Open();
sql_cmd = sql_con.CreateCommand();
string CommandText = "SELECT Rents.Name, Rents.Brand_Model_Plate_Number, Rents.rental_date,Rents.return_date,Car.rate,Payment.charges FROM Rents INNER JOIN Car ON Rents.rental_id = Car.car_id INNER JOIN Payment ON Rents.rental_id = Payment.payment_id; ";
DB = new SQLiteDataAdapter(CommandText, sql_con);
DS.Reset();
DB.Fill(DS);
DT = DS.Tables[0];
dgvBills.DataSource = DT;
sql_con.Close();
}
-\loads data :Only shows the column name but no data was shown