private void txtSearch_TextChanged(object sender, EventArgs e) { string sn = " N'%" + txtSearch.Text + "%' "; sql = "Select StaffID,StaffName From tbStaff Where StaffName Like " + sn + "Order By StaffName"; op.BindListBox(LstStaff, sql, "StaffName", "StaffID"); if (LstStaff.Items.Count == 0) { op.ClearControls(txtID, txtName, cboGender, txtAddress, cboPosition, txtSalary, cboStopWork); txtPhone.Clear(); txtHiredDate.Value = DateTime.Today; fp = Path.GetDirectoryName(Application.ExecutablePath); fp = fp + "/Photo/Staff.jpg"; binpic = System.IO.File.ReadAllBytes(fp); ms = new MemoryStream(binpic); Photo.Image = Image.FromStream(ms); } else { LstStaff.SetSelected(0, true); string id = LstStaff.SelectedValue.ToString(); sql = "Select *From tbStaff Where StaffID=" + id; op.DisplayInformation(sql, txtID, txtName, cboGender, txtBirtDate, txtPhone, txtAddress, cboPosition, txtSalary, txtHiredDate, cboStopWork); double sal = Double.Parse(txtSalary.Text); txtSalary.Text = String.Format("{0:C}", sal); status = "Old"; btnSave.Enabled = true; ShowPhoto(id); } }
private void FormStaff_Load(object sender, EventArgs e) { op.SetConnection("D8JZPCQ2", "dbStock"); //string sql = "Insert into tbCustomer(CusName,CusPhone,CusAddress)" + // "Values ('Kim Thida','(095)993-488','Phnom penh')"; //op.RunSql(sql); string sql = "Select Distinct StaffPosition from tbStaff"; op.PutDataIntoComboBox(sql, cboPosition); sql = "select StaffID,StaffName from tbStaff order by StaffName"; op.BindListBox(LstStaff, sql, "StaffName", "StaffID"); btnNew.Focus(); btnSave.Enabled = false; this.KeyPreview = true; if (LstStaff.Items.Count > 0) { LstStaff.SetSelected(0, true); string id = LstStaff.SelectedValue.ToString(); sql = "select *from tbStaff where StaffID=" + id; op.DisplayInformation(sql, txtID, txtName, cboGender, txtBirtDate, txtPhone, txtAddress, cboPosition, txtSalary, txtHiredDate, cboStopWork); double sal = Double.Parse(txtSalary.Text); txtSalary.Text = String.Format("{0:C}", sal); status = "Old"; btnSave.Enabled = true; ShowPhoto(id); } }
void DisplayStaff() { //create an instance of the staff collection clsStaffCollection Staff = new clsStaffCollection(); //set the source to the list of staff in the collection LstStaff.DataSource = Staff.StaffList; //get the primary key LstStaff.DataValueField = "StaffNo"; //set the data field to display LstStaff.DataTextField = "FirstName"; //bind data to the list LstStaff.DataBind(); }