public void PullDataFromDB()
{
//Reading data from the database
//--Clearing the list data..
listForDataFromDB.Clear();
//--Database detials
string databasePath = Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location);
string databaseFile = databasePath + @"\db_psychrometric_project.s3db";
string connString = @"Data Source=" + databaseFile + ";Version=3;";
using (SQLiteConnection connection = new SQLiteConnection(connString))
{
connection.Open();
SQLiteDataReader reader = null;
string queryString = "SELECT * from tbl_air_handler_details";
SQLiteCommand command = new SQLiteCommand(queryString, connection);
//SqlDataAdapter dataAdapter = new SqlDataAdapter(queryString, connection.ConnectionString); //connection.ConnectionString is the connection string
//SqlCommandBuilder commandBuilder = new SqlCommandBuilder(dataAdapter);
//DataSet ds = new DataSet();
//dataAdapter.Fill(ds);
//dataGridView1.DataSource = ds.Tables[0];
reader = command.ExecuteReader();
while (reader.Read())
{
listForDataFromDB.Add(new listDataType
{
id = int.Parse(reader["id"].ToString()),
name = reader["name"].ToString(),
node_table = reader["node_table"].ToString(),
line_table = reader["line_table"].ToString(),
});
}
}//close of using..
}