WFA_psychometric_chart.Form1_main.insertNewDataFromDGV C# (CSharp) Method

        public void insertNewDataFromDGV(string name)
        {
            string buildingNameValue = selectedBuildingList[0].BuildingName;

            string nodeIdValue = "tbl_" + buildingNameValue + "_node";
            string lineIdValue = "tbl_" + buildingNameValue + "_line";
            string tableNameOfChart = "tbl_" + buildingNameValue + "_chart_detail";
            string databasePath = Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location);
            string databaseFile = databasePath + @"\db_psychrometric_project.s3db";
            string connString = @"Data Source=" + databaseFile + ";Version=3;";

            string chartIDValue = buildingNameValue + name + GetGUID();//This is the chart id value
            string chart_resp_nodes_group_ID = chartIDValue + "_node_group";
            string chart_resp_lines_group_ID = chartIDValue + "_line_group";
            string enableChartStatusVar = "true";   //--Firs first time insertion its always true
            using (SQLiteConnection connection = new SQLiteConnection(connString))
            {
                connection.Open();
                //SQLiteDataReader reader = null;
                //--Modified this value by bbk : for pulling data form alex db
                //string sql_string = "insert into  " + tableNameOfChart + " (chartID,chartName,chart_respective_nodeID,chart_respective_lineID) VALUES(@chartID_value,@nodeName_value,@nodeRespectiveID,@lineRespectiveID)";
                string sql_string = "insert into  " + tableNameOfChart + " (chartID,chartName,chart_respective_nodeID,chart_respective_lineID,enableChartStatus) VALUES(@chartID_value,@nodeName_value,@nodeRespectiveID,@lineRespectiveID,@enableChartStatus1)";
                SQLiteCommand command = new SQLiteCommand(sql_string, connection);
                command.CommandType = CommandType.Text;
                command.Parameters.AddWithValue("@chartID_value", chartIDValue);
                command.Parameters.AddWithValue("@nodeName_value", name);
                command.Parameters.AddWithValue("@nodeRespectiveID", chart_resp_nodes_group_ID);
                command.Parameters.AddWithValue("@lineRespectiveID", chart_resp_lines_group_ID);
                command.Parameters.AddWithValue("@enableChartStatus1", enableChartStatusVar);

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