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