void Add()
        {
            //create an instance of the Payment Collenction
            clsSellerShopCollection AllSellerShops = new clsSellerShopCollection();
            //validate the data on the web form
            string Error = AllSellerShops.ThisSellerShop.Valid(txtShopName.Text, txtSellerName.Text, txtEmail.Text, Convert.ToString(DDListProductName0.SelectedValue));

            //if the data is OK then add it to the object
            if (Error == "")
            {
                //get the data entered by the user
                AllSellerShops.ThisSellerShop.Email      = Convert.ToString(txtEmail.Text);
                AllSellerShops.ThisSellerShop.ShopName   = Convert.ToString(txtShopName.Text);
                AllSellerShops.ThisSellerShop.SellerName = Convert.ToString(txtSellerName.Text);
                AllSellerShops.ThisSellerShop.Rating     = Convert.ToInt32(DDListProductName0.SelectedValue);
                AllSellerShops.ThisSellerShop.DateOpened = Convert.ToDateTime(txtDateOpened.Text);

                //add the record
                AllSellerShops.Add();
            }
            else
            {
                //report an error
                lblError.Text = "There were problems with the data entered : " + Error;
            }
        }
        void Add()
        {
            //create an instance of the Inventory Collenction
            clsSellerShopCollection AllSellerShops = new clsSellerShopCollection();
            //validate the data on the web form
            string Error = AllSellerShops.ThisSellerShop.Valid(txtShopName.Text, txtSellerName.Text, txtEmail.Text, Convert.ToString(comboBoxRating.SelectedItem));

            //if the data is OK then add it to the object
            if (Error == "")
            {
                //get the data entered by the user
                AllSellerShops.ThisSellerShop.ShopName   = txtShopName.Text;
                AllSellerShops.ThisSellerShop.SellerName = txtSellerName.Text;
                AllSellerShops.ThisSellerShop.Email      = txtEmail.Text;
                AllSellerShops.ThisSellerShop.Rating     = Convert.ToInt32(comboBoxRating.SelectedItem);
                AllSellerShops.ThisSellerShop.DateOpened = Convert.ToDateTime(txtDateOpened.Text);


                //add the record
                AllSellerShops.Add();
                //all done so redirect back to the main page
                SellerShopManageForm SSM = new SellerShopManageForm();
                this.Hide();
                SSM.ShowDialog();
                this.Close();
            }
            else
            {
                //report an error
                lblError.Text = "There were problems with the data entered : " + Error;
            }
        }