public System.Data.DataTable Query(string psSQL) { System.Data.DataTable loDataReturn = null; System.Data.DataSet loDS = new System.Data.DataSet(); SQLiteConnection loSql_con; SQLiteDataAdapter loSQLAdapter; loSql_con = getConnection(); loSQLAdapter = new SQLiteDataAdapter(psSQL, loSql_con); loDS.Reset(); loSQLAdapter.Fill(loDS); loDataReturn = loDS.Tables[0]; loDS.Tables.Remove(loDataReturn); loDS.Clear(); loDS.Dispose(); loSql_con.Close(); loSql_con.Dispose(); loSQLAdapter.Dispose(); return(loDataReturn); }
public static System.Data.DataTable RetrieveProfiles() { System.Data.DataSet dataSet = new System.Data.DataSet(); System.Data.DataTable dataTable = new System.Data.DataTable(); System.Data.DataRow[] dataRows = null; SQLiteDataAdapter dataAdapter = null; try { using (SQLiteConnection sqlite_conn = new SQLiteConnection()) { string sql_query = @" SELECT FIRST_NAME as 'First Name', LAST_NAME as 'Last Name', COMPANY as Company, JOB_TITLE as 'Job Title', YEARLY_INCOME as 'Yearly Income', STATE as State, NOTES as Notes FROM main.Profile;"; sqlite_conn.ConnectionString = "Data Source=BudgetTracker.db;Version=3;"; sqlite_conn.Open(); using (SQLiteCommand sqlCommand = sqlite_conn.CreateCommand()) { dataAdapter = new SQLiteDataAdapter(sql_query, sqlite_conn); dataSet.Reset(); dataAdapter.Fill(dataSet); dataTable = dataSet.Tables[0]; dataRows = dataTable.Select(); } sqlite_conn.Close(); } } catch (Exception ex) { MessageBox.Show(ex.Message); dataRows = null; } return(dataTable); }