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);
}
