private void Form1_Load(object sender, EventArgs e)
{//required to define location for database here
EIndex = ToExcelC.rowcounts;
AccessDBC.connection_str = AccessDBC.Database_LOC("SMB.accdb");
//@@## nead to add database check module that if remote database not reachable close application
AccessDBC a = new AccessDBC();
CB_1.DataSource = a.GetData(null, "Capacitorsheet", CB_1.Tag.ToString());
}
private void linkLabel5_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
AccessDBC.connection_str = AccessDBC.Database_LOC("SMB.accdb");
AccessDBC a = new AccessDBC();
ToExcelC c = new ToExcelC();
DataTable tablex = new DataTable();
List <string> list = new List <string>()
{
Des14.Tag.ToString(), Des15.Tag.ToString(), Ref1.Tag.ToString()
};
tablex = a.Read_DataSet(null, table.Text, list);
c.ExportToExcel(tablex, "Flag Relays");
}