WFA_psychometric_chart.Form_handler.PullDataFromDB C# (CSharp) Method

PullDataFromDB() public method

public PullDataFromDB ( ) : void
return void
        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..
        }