public void loadDataFromIndependentFileAndRefreshData()
{
/*Steps :
1.Read the data from the file
2.Store the data in a dynamic List
3.Delete all the data form the table OR drop table and re-create it
4.Upload the list data to original database
5.Reload the data of node and line
6.Refresh the chart
*/
//--This reads the value of data form db lets use list for storing the data
string chartTableName = "tbl_chart_detail";
string nodeTableName = "tbl_node_value";
string lineTableName = "tbl_line_value";
string tableNameDevice = "tbl_device_info_for_node";//currentNodeTableFromDB;
string tableForComfortZoneSetting = "tbl_chart_comfort_zone_setting";
string tableForCF_Detail = "tbl_comfort_zone_detail";
OpenFileDialog O_Dialog = new OpenFileDialog();
O_Dialog.Title = "Open s3db File";
O_Dialog.Filter = "s3db files|*.s3db";
O_Dialog.InitialDirectory = @"C:\";
string FilePathWithName = "";
if (O_Dialog.ShowDialog() == DialogResult.OK)
{
//--This is where we are going to add all the code we require
FilePathWithName = O_Dialog.FileName;//Now we have the file name
}
if(FilePathWithName != "")
{
//--Then we are going to read/write to db
string pathToFile = @"Data Source=" + FilePathWithName + ";Version=3;";
//--Now lets read the data value
}
}