private void listBox1_SelectedIndexChanged(object sender, EventArgs e)
        {
            batchModel ob = (batchModel)listBox1.SelectedItem;

            IDtext.Text         = "" + ob.Batchid;
            batchYeartext.Text  = "" + ob.Batchyear;
            batchShifttext.Text = ob.batchShift;
            grpDecText.Text     = ob.Grpdesc;
        }
        private void batchcomboBox1_SelectedIndexChanged(object sender, EventArgs e)
        {
            listBox1.Items.Clear();

            batchModel ob    = (batchModel)batchcomboBox1.SelectedItem;
            ArrayList  alist = DatabaseModel.getStudentsReg(ob.Batchid);


            IEnumerator en = alist.GetEnumerator();

            while (en.MoveNext())
            {
                listBox1.Items.Add(en.Current);
            }
        }
示例#3
0
        public static ArrayList getBatch(int progid)
        {
            ArrayList    alist = new ArrayList();
            string       query = "select * from batch where prog_id=" + progid;
            OleDbCommand com   = new OleDbCommand(query, con);

            con.Open();
            OleDbDataReader read = com.ExecuteReader();


            while (read.Read())
            {
                batchModel rec = new batchModel();
                rec.Batchid    = read.GetInt32(0);
                rec.Progid     = read.GetInt32(1);
                rec.Batchyear  = read.GetInt32(2);
                rec.batchShift = read.GetString(3);
                rec.Grpdesc    = read.GetString(4);

                alist.Add(rec);
            }
            con.Close();
            return(alist);
        }