//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(); }
}// 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)); }