public FRM_ProductUpdateDet(string s)
        {
            ProductId = int.Parse(s);
            InitializeComponent();

            DataTable dtCat = ClassSetting.sp_allCategory();

            cmbCategory.DataSource    = dtCat;
            cmbCategory.DisplayMember = "catogary_name";
            cmbCategory.ValueMember   = "catogary_id";

            DataTable dttype = ClassSetting.sp_allTypys();

            cmbType.DataSource    = dttype;
            cmbType.DisplayMember = "typePro_name";
            cmbType.ValueMember   = "typePro_id";

            DataTable dtcolor = ClassSetting.sp_allColors();

            cmbColor.DataSource    = dtcolor;
            cmbColor.DisplayMember = "colorPro_name";
            cmbColor.ValueMember   = "colorPro_id";

            DataTable ProductDet = ClassManagment.selectOneProduct(ProductId);

            cmbCategory.Text = ProductDet.Rows[0][0].ToString();
            txtname.Text     = ProductDet.Rows[0][1].ToString();
            txtBarcode.Text  = ProductDet.Rows[0][2].ToString();
            cmbType.Text     = ProductDet.Rows[0][3].ToString();
            cmbColor.Text    = ProductDet.Rows[0][4].ToString();
        }
예제 #2
0
        public FRM_AddProduct()
        {
            InitializeComponent();
            DataTable dtCat = ClassSetting.sp_allCategory();

            cmbCategory.DataSource    = dtCat;
            cmbCategory.DisplayMember = "catogary_name";
            cmbCategory.ValueMember   = "catogary_id";

            DataTable dttype = ClassSetting.sp_allTypys();

            cmbType.DataSource    = dttype;
            cmbType.DisplayMember = "typePro_name";
            cmbType.ValueMember   = "typePro_id";

            DataTable dtcolor = ClassSetting.sp_allColors();

            cmbColor.DataSource    = dtcolor;
            cmbColor.DisplayMember = "colorPro_name";
            cmbColor.ValueMember   = "colorPro_id";
        }