//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 Page_Load

        //on page load the job number drop down is populated with all job numbers from the database
        protected void fillDdljobNo()
        {
            JobNumbers myJob = new JobNumbers();
            SqlDataReader drJob = myJob.GetJobNo();
            DDLjobNo.DataSource = drJob;
            DDLjobNo.DataTextField = "job_number";
            DDLjobNo.DataValueField = "job_Number";
            DDLjobNo.DataBind();
        }
Beispiel #3
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));
        }
 /*
  On page load a gridview is populated with the job number and job decription for all jobs.
  * The user can review the gridview to identify the job nuumber if unknown
  */
 protected void fillJobDesc2()
 { // populates a gridview with all job numbers
     JobNumbers myJob = new JobNumbers();
     GVjobDesc2.DataSource = myJob.GetJobNo();
     GVjobDesc2.DataBind();
 }