Member Avatar for coder91

I have various database tables, one that holds the options within a drop down list - each selection has a value assigned to it. One of the options is "other" which has the value -1 assigned to it. The other table takes the data from a form that the user has completed and stores it in a different database table. However instead of saving the data entered when the user selects "other" it records -1 instead. Any ideas how i can fix this?

  • 5 Contributors
  • 4 Replies
  • 105 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by crazydevelopervish
Member Avatar for pritaeas

What do you want to save instead of -1?

Member Avatar for JorgeM

However instead of saving the data entered when the user selects "other" it records -1 instead

Which data are you referring to? If the user selects "other", is the user typing in the information into a text box? Maybe your INSERT INTO statement is not using the text box data.

Member Avatar for nakor77

are you using the SelectedValue property or the SelectedItem.Text property?

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.