//on page load the job number drop down contain all job from the database
 protected void fillDdljobNo2()
 { // on page load the Drop down list is populated with all job numbers from the database
     JobNumbers myJob = new JobNumbers();
     SqlDataReader drJob = myJob.GetJobNo();
     DDLjobNos.DataSource = drJob;
     DDLjobNos.DataTextField = "job_number";
     DDLjobNos.DataValueField = "job_Number";
     DDLjobNos.DataBind();
 }
Beispiel #2
0
        }// closes the fillorders

        /* on page load the Drop down list is populated with all job numbers from the database
         * Uses the same method as the job number drop downn in bookout goods
         */
        protected void fillDdljobNo3()
        {
            JobNumbers    myJob = new JobNumbers();
            SqlDataReader drJob = myJob.GetJobNo();

            DDLjobNos.DataSource     = drJob;
            DDLjobNos.DataTextField  = "job_number";
            DDLjobNos.DataValueField = "job_Number";
            DDLjobNos.DataBind();
            DDLjobNos.Items.Insert(0, new ListItem(String.Empty, String.Empty));
        }