private void tbProductNumber_Leave(object sender, EventArgs e) { if (tbProductNumber.TextLength != 0) { DataTable dt = db.GetProduct(tbProductNumber.Text); if (dt.Rows.Count != 0) { tbProductName.Text = dt.Rows[0]["product_name"].ToString(); tbProductName.Enabled = false; tbProductPrice.Text = dt.Rows[0]["unit_price"].ToString(); tbProductPrice.Enabled = false; tbProductSize.Text = dt.Rows[0]["product_size"].ToString(); tbProductSize.Enabled = false; tbNote.Text = dt.Rows[0]["note"].ToString(); tbNote.Enabled = false; cbbQuantifier.Text = dt.Rows[0]["quantifier_name"].ToString(); cbbQuantifier.Enabled = false; cbType.Text = dt.Rows[0]["category_name"].ToString(); cbType.Enabled = false; return; } tbProductName.Enabled = true; tbProductName.Clear(); tbProductPrice.Enabled = true; tbProductPrice.Clear(); tbProductSize.Enabled = true; tbProductSize.Clear(); tbNote.Enabled = true; tbNote.Clear(); cbType.Enabled = true; cbType.Text = ""; cbbQuantifier.Enabled = true; cbbQuantifier.Text = ""; } }