protected void SubmitButton_Click(object sender, EventArgs e)
    {
        da = new SqlDataAdapter("insert into [Homestay-Resort_Details](HR_Type,HR_Stars,HR_Category,HR_Name,HR_Country,HR_City,Amount,Description)values('" + DropDownListType.SelectedItem.Text + "','" + NameDropDownList.SelectedItem.Text + "','" + DropdownCategory.SelectedItem.Text + "','" + NameTextBox.Text + "','" + DropDownCountry.SelectedItem.Text + "','" + DropDownCity.SelectedItem.Text + "'," + TextBoxAmount.Text + ",'" + DescTextBox.Text + "')", con);
        dt = new DataTable();
        da.Fill(dt);
        CmtLabel.Text = "Data Submit";
        DropDownListType.ClearSelection();
        NameDropDownList.ClearSelection();
        DropdownCategory.ClearSelection();
        NameTextBox.Text = "";
        DropDownCountry.ClearSelection();
        DropDownCity.ClearSelection();
        TextBoxAmount.Text = "";
        DescTextBox.Text   = "";
        CmtLabel.Text      = "Data Submit";


        da = new SqlDataAdapter("select * from [Homestay-Resort_Details] order by HR_ID desc", con);
        dt = new DataTable();
        da.Fill(dt);
        if (dt.Rows.Count > 0)
        {
            GridViewHomestayDetails.DataSource = dt;
            GridViewHomestayDetails.DataBind();
        }
        else
        {
            GridViewHomestayDetails.DataSource = "";
            GridViewHomestayDetails.DataBind();
        }
    }
    protected void SubmitButton_Click(object sender, EventArgs e)
    {
        da = new SqlDataAdapter("insert into Hotel_Details(H_Type,H_Stars,H_Name,H_Country,Room_Category,H_City,Amount,Description)values('" + typeDropDownList.SelectedItem.Text + "','" + StarDropDownList.SelectedItem.Text + "','" + NameTextBox.Text + "','" + DropDownCountry.SelectedItem.Text + "','" + DropdownCategory.SelectedItem.Text + "','" + DropDownCity.SelectedItem.Text + "'," + AmtTextBox.Text + ",'" + DescTextBox.Text + "')", con);
        dt = new DataTable();
        da.Fill(dt);
        cmtLabel.Text = "Data Submit";
        typeDropDownList.ClearSelection();
        StarDropDownList.ClearSelection();
        NameTextBox.Text = "";
        DropDownCountry.ClearSelection();
        DropdownCategory.ClearSelection();
        DropDownCity.ClearSelection();
        AmtTextBox.Text  = "";
        DescTextBox.Text = "";

        da = new SqlDataAdapter("select * from Hotel_Details order by H_Id desc", con);
        dt = new DataTable();
        da.Fill(dt);
        if (dt.Rows.Count > 0)
        {
            GridViewHotelDetails.DataSource = dt;
            GridViewHotelDetails.DataBind();
        }
        else
        {
            GridViewHotelDetails.DataSource = "";
            GridViewHotelDetails.DataBind();
        }
    }
    protected void SubmitButton_Click(object sender, EventArgs e)
    {
        da = new SqlDataAdapter("insert into Package_Details(P_Type,P_Category,Country,City,Days,Amount,Description)values('" + DropDownListType.SelectedItem.Text + "','" + DropdownCategory.SelectedItem.Text + "','" + DropDownCountry.SelectedItem.Text + "','" + DropDownCity.SelectedItem.Text + "','" + TextBoxDays.Text + "'," + TextBoxAmount.Text + ",'" + TextBoxDesc.Text + "')", con);
        dt = new DataTable();
        da.Fill(dt);
        Label1.Text = "Data Submit Successfully";
        DropDownCountry.ClearSelection();
        DropDownCity.ClearSelection();
        DropdownCategory.ClearSelection();
        DropDownListType.ClearSelection();
        TextBoxDays.Text   = "";
        TextBoxAmount.Text = "";
        TextBoxDesc.Text   = "";

        da = new SqlDataAdapter("select * from Package_Details order by P_Id desc", con);
        dt = new DataTable();
        da.Fill(dt);
        if (dt.Rows.Count > 0)
        {
            GridViewPackageDetails.DataSource = dt;
            GridViewPackageDetails.DataBind();
        }
        else
        {
            GridViewPackageDetails.DataSource = "";
            GridViewPackageDetails.DataBind();
        }
    }