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 [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 Page_Load(object sender, EventArgs e) { HttpCookie userCookie; userCookie = Request.Cookies["Preferences"]; if (userCookie != null || Session["login"] != null) { Button4.Text = "logout"; if (userCookie == null && Session["login"] != null) { Label1.Text = Session["login"].ToString(); } else { Label1.Text = userCookie["username"]; } } else { Button4.Text = "login"; Label1.Visible = false; } DataSet DS = new DataSet(); string strPhysicalPath = Server.MapPath("countries.xml"); DS.ReadXml(strPhysicalPath); DropDownCountry.DataTextField = "countryName"; DropDownCountry.DataSource = DS; DropDownCountry.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(); } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { test = new konrad.CourierService(); string[] st = test.getCountries(); DropDownCountry.DataSource = st; DropDownCountry.DataBind(); changeDistricts(); } }
public void Country() { cn.Open(); using (SqlCommand cmd = new SqlCommand("select CountryName,CountryId from Country", cn)) { using (SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection)) { DropDownCountry.DataSource = dr; DropDownCountry.Items.Clear(); DropDownCountry.Items.Add("Please Select Country"); DropDownCountry.DataTextField = "CountryName"; DropDownCountry.DataValueField = "CountryId"; DropDownCountry.DataBind(); } } }
protected void Page_Load(object sender, EventArgs e) { con = new SqlConnection(ConfigurationManager.AppSettings["con"]); if (Page.IsPostBack == false) { 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(); } } if (Page.IsPostBack == false) { da = new SqlDataAdapter("select distinct CountryName from CountryCityMaster order by CountryName", con); dt = new DataTable(); da.Fill(dt); if (dt.Rows.Count > 0) { DropDownCountry.DataSource = dt; DropDownCountry.DataTextField = "CountryName"; DropDownCountry.DataBind(); DropDownCountry.Items.Insert(0, "Select Country"); DropDownCountry.Items.Insert(dt.Rows.Count + 1, "Other Country"); } } if (Page.IsPostBack == false) { da = new SqlDataAdapter("select RoomCategory from RoomCategory", con); dt = new DataTable(); da.Fill(dt); if (dt.Rows.Count > 0) { DropdownCategory.DataSource = dt; DropdownCategory.DataTextField = "RoomCategory"; DropdownCategory.DataBind(); DropdownCategory.Items.Insert(0, "Select Room"); DropdownCategory.Items.Insert(dt.Rows.Count + 1, "Other Room"); } } if (Request.QueryString["P"] == "AMP") { hiderow6.Visible = false; hiderow1.Visible = true; hiderow2.Visible = true; hiderow3.Visible = true; hiderow4.Visible = true; SubmitButton.Visible = true; Button1.Visible = false; titleLabel.Text = "Insert Hotel Detail"; GridViewHotelDetails.Visible = true; } else if (Request.QueryString["P"] == "UMP") { hiderow6.Visible = true; hiderow1.Visible = false; hiderow2.Visible = false; hiderow3.Visible = false; hiderow4.Visible = false; SubmitButton.Visible = false; Button1.Visible = true; titleLabel.Text = "Search Hotel"; GridViewHotelDetails.Visible = false; } else { hiderow6.Visible = true; hiderow1.Visible = false; hiderow2.Visible = false; hiderow3.Visible = false; hiderow4.Visible = false; SubmitButton.Visible = false; Button1.Visible = true; titleLabel.Text = "Search Hotel"; GridViewHotelDetails.Visible = false; } }