public void DeleteChartInfoFromChartDetailTable(string chartID)
{
//lets get the id values...
string databasePath = Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location);
string databaseFile = databasePath + @"\db_psychrometric_project.s3db";
string connString1 = @"Data Source=" + databaseFile + ";Version=3;";
//--Now lets delete the chart actual content for the tbl_..._chart_detail table
string chartDetailTableName = "tbl_" + selectedBuildingList[0].BuildingName + "_chart_detail";
using (SQLiteConnection connection = new SQLiteConnection(connString1))
{
connection.Open();
string queryString = "delete from " + chartDetailTableName + " where chartID = @id_value";
SQLiteCommand command = new SQLiteCommand(queryString, connection);
command.Parameters.AddWithValue("@id_value", chartID);
command.ExecuteNonQuery();
}//Close of using
}
