Member Avatar for rbeach1955

I have an aspx page that has a listview. Within the listview I have a column named BADGEID. When inserting the BADGEID as a textbox with the below code, everything works properly:

<asp:TextBox ID="BADGE" runat="server" Text='<%# Bind("BadgeID") %>'

I need this to be a DropDownList and I changed the textbox above to the below:

<asp:DropDownList ID="BADGE" runat="server" DataSourceID="SqlDataSource2" DataTextField="BADGE" DataValueField="BADGE" />

The listbox contains the items I need but when I send the information, the item selected in the DropDownList is not sent to the database.

Please let me know what I am missing or doing wrong. This is the first aspx with a DropDownList I have ever created.

  • 3 Contributors
  • 4 Replies
  • 113 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by vgulavni
Member Avatar for pinkygirl

To save values selected from a DropDownList, you must use SelectedItem. This is how you use it:-

string insertCommand="insert into TableName values ('"+BADGE.SelectedItem.Text.ToString()+"')";

SqlCommand commandObject=new SqlCommand(insertCommand, connectionObject);

commandObject.ExecuteNonQuery();

Don't worry, we are all learners.

Edited by pinkygirl because: n/a
Member Avatar for rbeach1955

Thanks for all you help!!!

Member Avatar for pinkygirl

no problem

Member Avatar for vgulavni

Which error you got? please give the details of error you are getting.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.