Someone

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using Travel.Vendor;
using System.Security.Permissions;
using AssetTableAdapters;
using DestinationTableAdapters;

[PrincipalPermission(SecurityAction.Demand, Role = "Vendor")]
[PrincipalPermission(SecurityAction.Demand, Role = "Admin")]
public partial class partners_resort_Location : System.Web.UI.Page
{
    Asset.AssetsRow asset;

    protected void Page_Load(object sender, EventArgs e)
    {
        // Highlight the current nav button
        HyperLink curBtn = Master.FindControl("LocationBtn") as HyperLink;
        curBtn.CssClass = "on";

        if (!IsPostBack)
        {
            LoadDestinations();
            LoadData();
        }
    }

    private void LoadData()
    {
        asset = Session["Asset"] as Asset.AssetsRow;

        if (asset == null)
            Response.Redirect("~/Default.aspx");

        AssetTitle.Text = asset.Title;

        //load the corresponding destination data
        DestinationsTableAdapter destinationAdapter = 
            new DestinationsTableAdapter();
        Destination.DestinationsRow curDestinationData =
            destinationAdapter.GetByDestinationId(asset.DestinationId)[0];

        //load the corresponding subdestination data
        SubDestinationsTableAdapter  subDestinationAdapter = 
            new SubDestinationsTableAdapter();
        Destination.SubDestinationsRow curSubDestinationData =
            subDestinationAdapter.GetBySubDestinationId(asset.SubDestinationId)[0];

        //load the corresponding asset data
        AssetDataTableAdapter assetDataAdapter = new AssetDataTableAdapter();
        Asset.AssetDataRow curAssetData = 
            assetDataAdapter.GetByAssetIdAndPublishLevel(
                (int)AssetPublishLevel.Preview, 
                asset.AssetId
            )[0]
        ;
        
        Destinations.SelectedValue = curDestinationData.Title;

//        if (asset["Destination"] != null && !asset["Destination"].Equals(string.Empty))
        if (curDestinationData.Title != "")
            LoadSubDestinations(Int32.Parse(curDestinationData.Title));
        else
            SubDestinations.Items.Insert(0, new ListItem("Please Select Destination First", string.Empty));

//        SubDestinations.SelectedValue = asset["SubDestination"];
//        Address1.Text = asset["Address1"];
//        Address2.Text = asset["Address2"];
//        Address3.Text = asset["Address3"];
        SubDestinations.SelectedValue = curSubDestinationData.Title;
        Address1.Text = curAssetData.Address1;
        Address2.Text = curAssetData.Address2;
        Address3.Text = curAssetData.Address3;

        //>> CHECK FOR UPDATED VALUES
        /*
        DestinationsModified.Text = asset.GetModified("Destination");
        SubDestinationsModified.Text = asset.GetModified("SubDestination");
        Address1Modified.Text = asset.GetModified("Address1");
        Address2Modified.Text = asset.GetModified("Address2");
        Address3Modified.Text = asset.GetModified("Address3");
        */
    }

    private void SaveData()
    {
        asset = Session["Asset"] as Asset.AssetsRow;

        if (asset == null)
            Response.Redirect("~/Default.aspx");

        //load the corresponding destination data
        DestinationsTableAdapter destinationAdapter =
            new DestinationsTableAdapter();
        Destination.DestinationsRow curDestination =
            destinationAdapter.GetByDestinationId(asset.DestinationId)[0];

        //load the corresponding subdestination data
        SubDestinationsTableAdapter subDestinationAdapter =
            new SubDestinationsTableAdapter();
        Destination.SubDestinationsRow curSubDestination =
            subDestinationAdapter.GetBySubDestinationId(asset.SubDestinationId)[0];

        //load the corresponding asset data
        AssetDataTableAdapter assetDataAdapter = new AssetDataTableAdapter();
        Asset.AssetDataRow curAssetData =
            assetDataAdapter.GetByAssetIdAndPublishLevel(
                (int)AssetPublishLevel.Preview,
                asset.AssetId
            )[0]
        ;
//        asset["Destination"] = Destinations.SelectedValue;
//        asset["SubDestination"] = SubDestinations.SelectedValue;
//        asset["Address1"] = Address1.Text.Trim();
//        asset["Address2"] = Address2.Text.Trim();
//        asset["Address3"] = Address3.Text.Trim();
        curDestination.Title = Destinations.SelectedValue;
        curSubDestination.Title = SubDestinations.SelectedValue;
        curAssetData.Address1 = Address1.Text.Trim();
        curAssetData.Address2 = Address2.Text.Trim();
        curAssetData.Address3 = Address3.Text.Trim();

        destinationAdapter.Update(curDestination);
        subDestinationAdapter.Update(curSubDestination);
        assetDataAdapter.Update(curAssetData);
//        asset.Save();
    }

    protected void Update_Click(object sender, ImageClickEventArgs e)
    {
        SaveData();
    }

    private void LoadDestinations()
    {
        DestinationsTableAdapter destinationAdapter =
            new DestinationsTableAdapter();
        Destination.DestinationsDataTable allDestinations = destinationAdapter.GetAll();

        Destinations.DataSource = allDestinations;
        Destinations.DataBind();
        Destinations.Items.Insert(0,new ListItem("Select", string.Empty));
    }

    private void LoadSubDestinations(int destinationID)
    {
        SubDestinations.Items.Clear();
        //SubDestinationCollection subDestinations = SubDestination.FetchByDestinationID(destinationID);
        
        //load the corresponding subdestination data
        SubDestinationsTableAdapter subDestinationAdapter =
            new SubDestinationsTableAdapter();

//        if (subDestinations.Count == 0)
//            SubDestinations.Items.Insert(0,new ListItem("N/A", string.Empty));
//        else
//        {
//            SubDestinations.DataSource = subDestinations;
        SubDestinations.DataSource = subDestinationAdapter;
        SubDestinations.DataBind();
        SubDestinations.Items.Insert(0,new ListItem("N/A", string.Empty));
//        }
    }

    protected void Destinations_SelectedIndexChanged(object sender, EventArgs e)
    {
        if (Destinations.SelectedValue.Equals(string.Empty))
            SubDestinations.Items.Clear();
        else
            LoadSubDestinations(Int32.Parse(Destinations.SelectedValue));
    }
}