WFA_psychometric_chart.Form_handler.insertNewDataFromDGV C# (CSharp) Method

insertNewDataFromDGV() public method

public insertNewDataFromDGV ( string name ) : void
name string
return void
        public void insertNewDataFromDGV(string name)
        {
            string newTableNodeName = "tbl_" + name + "_node";
            string newTableLineName = "tbl_" + name + "_line";
            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 sql_string = "insert into tbl_air_handler_details(name,node_table,line_table) VALUES(@name_value,@node_table_value,@line_table_value)";
                SQLiteCommand command = new SQLiteCommand(sql_string, connection);
                command.CommandType = CommandType.Text;
                command.Parameters.AddWithValue("@name_value", name);
                command.Parameters.AddWithValue("@node_table_value", newTableNodeName);
                command.Parameters.AddWithValue("@line_table_value", newTableLineName);
                //MessageBox.Show("selected value = " + cb_station_names.SelectedItem.ToString());
                command.ExecuteNonQuery();

                //--We also need to create table for particular data added..
                string sql3 = "create table "+newTableNodeName+ "(count INTEGER PRIMARY KEY AUTOINCREMENT ,id INTEGER,xValue varchar(255),yValue varchar(255),source varchar(255),name varchar(255), label varchar(255),colorValue varchar(255),showItemText varchar(255))";
                SQLiteCommand command3 = new SQLiteCommand(sql3, connection);
                command3.ExecuteNonQuery();

                string sql4 = "create table " + newTableLineName + "(count INTEGER PRIMARY KEY AUTOINCREMENT ,id INTEGER,prevNodeId varchar(255),nextNodeId varchar(255),lineColorValue varchar(255),lineSeriesId varchar(255))";
                SQLiteCommand command4 = new SQLiteCommand(sql4, connection);
                command4.ExecuteNonQuery();

            }
        }