Services
Support
Store
©2015 Intersoft Solutions. All rights reserved.
Intersoft Support Center

Bind to Custom Object

This walkthrough shows you how to create and bind WebCombo to custom object.

During this walkthrough, you will learn how to do the following:

  • Use ISDataSource.
  • Use Custom Object.
  • Use SmartTag to set DataSource.
  • Use Data Source Configuration Wizard to set the Database and table.

 Prerequisites

In order to complete this walkthrough, you will need the following:

  • Access to the Microsoft Access Northwind database.
  • Visual Studio 2005/2008/2010 Application.

 Step-By-Step Instructions

To create new web application and bind WebCombo to CustomObject

  1. Launch Visual Studio.NET 2008.
  2. Click on File menu, then select New and click Web Site.
  3. Select ASP.NET Web Site in the Template box and set Location to HTTP.
  4. Named the Web Site and click OK.
  5. Right-click on Project's name and select Add New Item.
  6. Select Intersoft AppForm in the My Templates box and named it as Walkthrough.aspx.
  7. In the Solution Explorer, right-click on App_Data and select Add Existing Item.
  8. Browse and add NorthWind.mdb in C:\Program Files\Intersoft Solutions\Data (Default installation folder).
  9. Right click on App_Code folder, choose New Folder and name the new folder DataObject.
  10. After that right click on the DataObject folder and choose Add New Item.
  11. Then set C# class and named it as MyData.cs and MyDataAccess.cs respectively.
  12. In MyData.cs, add the following code:

    C# Copy Code 
    namespace DataObject
{
    public class MyData
    {
        private int shipperID;
        private string companyName;
        private string phone;

        public int ShipperID
        {
            get { return this.shipperID; }
            set { this.shipperID = value; }
        }

        public string CompanyName
        {
            get { return this.companyName; }
            set { this.companyName = value; }
        }

        public string Phone
        {
            get { return this.phone; }
            set { this.phone = value; }
        }
    }
}

  13. In MyDataAccess.cs, add the following code:

    C# Copy Code 
    namespace DataObject
{
    [System.ComponentModel.DataObject]
    public class MyDataAccess
    {
        
        private dsNorthwind_OverwriteChangesTableAdapters.ShippersTableAdapter shipperDA = new dsNorthwind_OverwriteChangesTableAdapters.ShippersTableAdapter();

        public MyDataAccess()
        {

        }

        [System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Select, true)]
        public dsNorthwind_OverwriteChanges.ShippersDataTable GetData()
        {
            return shipperDA.GetData();
        }

        [System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Insert, true)]
        public int Insert(MyData data)
        {
            return shipperDA.Insert(data.CompanyName, data.Phone);
        }

        [System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Update, true)]
        public int Update(MyData data)
        {
            return shipperDA.Update(data.CompanyName, data.Phone, data.ShipperID);
        }

        [System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Delete, true)]
        public int Delete(MyData data)
        {
            return shipperDA.Delete(data.ShipperID);
        }
    }
}

  14. Drag WebCombo instance from ToolBar to WebForm.
  15. Click the SmartTag on the upper right of the WebCombo.
  16. Set the DataTextField and DataValueField for WebCombo.
  17. In Choose Data Source field, choose <New data source...>.



  18. In Data Source Configuration Wizard, choose ISDataSource and click OK.



  19. Set the Schema Type to CustomObject and click Next.



  20. Add new table and choose a business object like the following screenshot. Click Finish afterwards.



  21. Run the project and the combo will look like the following.

Previous Next