예제 #1
0
        void impostaarticolo()
        {
            Caricamento carica = new Caricamento();

            carica.Show();
            Application.DoEvents();
            iDB2Connection DBCONN = new iDB2Connection(Program.myConnString);

            DBCONN.Open();

            iDB2Command myCommand = new iDB2Command();

            myCommand.Connection = DBCONN;

            myCommand.CommandText = "SELECT ararti, ardsar" +
                                    " FROM $emiedati.art00f a " +
                                    " order by ardsar";

            iDB2DataReader myReader = myCommand.ExecuteReader();

            DataTable dt = new DataTable();

            dt.Load(myReader);

            CMB_Articolo.DataSource    = dt;
            CMB_Articolo.DisplayMember = "ardsar";
            CMB_Articolo.ValueMember   = "ararti";
            carica.Close();
            DBCONN.Close();
        }
예제 #2
0
        private void SceltaFornitore_Load(object sender, EventArgs e)
        {
            Caricamento carica = new Caricamento();

            carica.Show();
            Application.DoEvents();
            iDB2Connection DBCONN = new iDB2Connection(Program.myConnString);

            DBCONN.Open();

            iDB2Command myCommand = new iDB2Command();

            myCommand.Connection = DBCONN;

            myCommand.CommandText = "SELECT acscon, acrag1" +
                                    " FROM $d_emil.acf00f a " +
                                    " where actpcd = 'F'" +
                                    " order by acrag1";

            iDB2DataReader myReader = myCommand.ExecuteReader();

            DataTable dt = new DataTable();

            dt.Load(myReader);

            Cmb_Fornitore.DataSource    = dt;
            Cmb_Fornitore.DisplayMember = "acrag1";
            Cmb_Fornitore.ValueMember   = "acscon";
            carica.Close();
            DBCONN.Close();

            //primo numero libero
            lbl_ordine.Text = Convert.ToString(PrimoNumeroLibero() + 1);
        }