public DataTable SelectDatabase(string query)
{
try
{
con = new SQLiteConnection(connection);
con.Open();
adapter = new SQLiteDataAdapter(query, con);
DataTable dtb = new DataTable();
adapter.Fill(dtb);
con.Close();
return dtb;
}
catch (Exception ex)
{
MessageBox.Show("Error\n"+connection + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return null;
}
}