Esempio n. 1
0
        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");
        }
Esempio n. 2
0
        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);
        }
Esempio n. 3
0
        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");
        }