private void OnUpdateButton_Clicked(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection(CS);

        con.Open();
        SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM POS WHERE Bill_No=@Billno", con);

        da.SelectCommand.Parameters.AddWithValue("@Billno", txt_EnterBillNoPOS.Text);
        DataTable result = new DataTable();

        da.Fill(result);    //Fill your Table with data

        //Here you pass the data via Constructor
        var thirdForm = new ThirdForm(result);

        thirdForm.Show();
    }
示例#2
0
文件: Form1.cs 项目: dimashmundiak/DB
        private void button10_Click(object sender, EventArgs e)
        {
            var thirdQuery = new ThirdForm();

            thirdQuery.ShowDialog();
        }
示例#3
0
        public static Shapes chooseFormToGenerateElements()
        {
            while (true)
            {
                Console.WriteLine("Please, choose form to generate elements(from 1 to 14) or \"500\" to finish program: ");
                int numberOfForm = Int32.Parse(Console.ReadLine());
                UserInterfaceHelpers.checkIfWantToExitTheProgram(numberOfForm);
                if (UserInterfaceHelpers.checkTheCorrectInputNumberOfForm(numberOfForm, Config.NumberOfForms))
                {
                    switch (numberOfForm)
                    {
                    case (int)NumberOfForms.FirstForm:
                    {
                        FirstForm form = new FirstForm();
                        return(form);
                    }

                    case (int)NumberOfForms.SecondForm:
                    {
                        SecondForm form = new SecondForm();
                        return(form);
                    }

                    case (int)NumberOfForms.ThirdForm:
                    {
                        ThirdForm form = new ThirdForm();
                        return(form);
                    }

                    case (int)NumberOfForms.FourthForm:
                    {
                        FourthForm form = new FourthForm();
                        return(form);
                    }

                    case (int)NumberOfForms.FifthForm:
                    {
                        FifthForm form = new FifthForm();
                        return(form);
                    }

                    case (int)NumberOfForms.SixthForm:
                    {
                        SixthForm form = new SixthForm();
                        return(form);
                    }

                    case (int)NumberOfForms.SeventhForm:
                    {
                        SeventhForm form = new SeventhForm();
                        return(form);
                    }

                    case (int)NumberOfForms.EighthForm:
                    {
                        EighthForm form = new EighthForm();
                        return(form);
                    }

                    case (int)NumberOfForms.NinthForm:
                    {
                        NinthForm form = new NinthForm();
                        return(form);
                    }

                    case (int)NumberOfForms.TenthForm:
                    {
                        TenthForm form = new TenthForm();
                        return(form);
                    }

                    case (int)NumberOfForms.EleventhForm:
                    {
                        EleventhForm form = new EleventhForm();
                        return(form);
                    }

                    case (int)NumberOfForms.TwelfthForm:
                    {
                        TwelfthForm form = new TwelfthForm();
                        return(form);
                    }

                    case (int)NumberOfForms.ThirteenthForm:
                    {
                        ThirteenthForm form = new ThirteenthForm();
                        return(form);
                    }

                    case (int)NumberOfForms.FourteenthForm:
                    {
                        FourteenthForm form = new FourteenthForm();
                        return(form);
                    }
                    }
                }
                else
                {
                    continue;;
                }
            }
        }