Clash Royale CLAN TAG#URR8PPP

How to fill all listItems on dropDownList - ASP

I want to insert the database of hotels names from the sql,
in each one of the ListItem. (trying so much time).

ListItem

This is the cs code:

<asp:DropDownList id="hotels" runat="server" >
<asp:ListItem Text="hotel1"></asp:ListItem>
<asp:ListItem Text="hotel2"></asp:ListItem>
<asp:ListItem Text="hotel3"></asp:ListItem>
<asp:ListItem Text="hotel4"></asp:ListItem>
<asp:ListItem Text="hotel5"></asp:ListItem>
<asp:ListItem Text="hotel6"></asp:ListItem>
</asp:DropDownList>


and this is the aspx code: which is where I made a huge mistakes.

public partial class Home : System.Web.UI.Page

protected void Page_Load(object sender, EventArgs e)


string hotel = hotels.Text;// mistake ? or to add ?)
SqlConnection sqlCon;
sqlCon = new SqlConnection(@"Data Source=ELAD_SSDSQLEXPRESS;Initial Catalog=Travels;Integrated Security=True");
SqlCommand Command;
Command = new SqlCommand("SELECT Hotels.Destiny FROM Travels WHERE Hotel = @hotel", sqlCon);
Command.Parameters.Add(new SqlParameter("hotel", hotel));

DataTable dt = new DataTable();
SqlDataAdapter adapter = new SqlDataAdapter(Command);
adapter.Fill(dt);


for (dt.Rows.Count > 0)

hotels.Text = dt.Rows.Count;// MISTAKE





How should I fill each itemList?

itemList

I know to send it through Server.Transfer("Hotels.aspx");

Server.Transfer("Hotels.aspx");

hotels.DataSource = dt; hotels.DataBind();

1 Answer
1

I assume the listitems are just placeholders? I'd take them out. Then:

foreach (System.Data.DataRow dr in dt.Rows)

hotels.Items.Add(new System.Web.UI.WebControls.ListItem(dr["Destiny"]));



Appologies if this is not 100% correct as I've edited from a working copy. But you get the idea.

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.