Beispiel #1
0
        private void button6_Click(object sender, EventArgs e)
        {
            createbill1 ss = new createbill1(v);

            ss.Show();
            this.Hide();
        }
Beispiel #2
0
        public Form1(int s)
        {
            v = s;

            InitializeComponent();

            try
            {
                string path = " ";
                // this is the path that you are checking.
                if (v == 1)
                {
                    path = @"C:\Program Files (x86)\YatinPatel\BillingSoft. Setup\data LB.xlsx";
                }

                else
                {
                    path = @"C:\Program Files (x86)\YatinPatel\BillingSoft. Setup\data RP.xlsx";
                }



                con = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + ";Extended Properties=Excel 12.0");


                da = new OleDbDataAdapter("select * from [sheet1$]", con);

                da.Fill(data);

                if (v == 1)
                {
                    path = @"C:\Program Files (x86)\YatinPatel\BillingSoft. Setup\BILL LB.xlsm";
                }
                else
                {
                    path = @"C:\Program Files (x86)\YatinPatel\BillingSoft. Setup\BILL RP.xlsm";
                }

                openFileDialog2.FileName = path;
            }

            catch (Exception ex)
            {
                MessageBox.Show("can't load select meanullay");
            }



            this.Hide();

            createbill1 ss = new createbill1(openFileDialog2.FileName.ToString(), data, text1, text2, text3, text4, v);

            ss.Show();
        }