private void linkLabel1_LinkClicked_1(object sender, LinkLabelLinkClickedEventArgs e) { AccessDBC a = new AccessDBC(); ToExcelC c = new ToExcelC(); DataTable tablex = new DataTable(); tablex = a.Read_DataSet(null, "Capacitorsheet", "*"); c.ExportToExcel(tablex, "Capacitorsheet"); }
private DataTable Load_data(string order) { AccessDBC a = new AccessDBC(); Dictionary <string, string> z = new Dictionary <string, string>(); z.Add("order", order); DataTable tb = a.Read_DataSet(z, "usersave", "*").Copy(); tb.Columns.Remove("order"); tb.Columns.Remove("ID"); return(tb); }
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"); }