Ad:

VB.NET Discussion Thread
Unsolved
Views: 13823

Jul 1st, 2005

Help with dropdownlist data adding?

Expand Post »

Well, I'm hoping someone can help me....

I've got a web application that queries data from a database based on selections made in previous dropdownlists. The problem is that some of the final queries return only one data item.

I'm using the onSelectedIndexChanged with autopostback enabled as my events in the lists. And thats the problem, if theres only one item in the dropdownlist, its imposible to change the index, thus I've got no event firing the next block of code I need executed...

If anyone has any idea on how to counter this problem, please help!
I thought if it were possible to add data to already manually inputted items already in the list, that'd be great, so that there's already 1 item in there before the other items are added... So that if only one item is retrieved by the from the database, there will be at least two items in there, allowing a change in the selected index...

Just how to do that though, I have no idea!

Similar Threads

Inserting multiple data with cfloop? in ColdFusion
Help with Linked Lists with digits in C++
listbox hiccup in Visual Basic 4 / 5 / 6
DropDownList items in ASP.NET
how to adding data in dataset in ASP.NET

Lemon

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Jul 2005

Permalink

Jul 5th, 2005

Re: Help with dropdownlist data adding?

Lemon,
I load my ddlboxes with a datareader. The first item has a value of 0 and I set the text to 'Select an item below' or something like that. I sometimes leave it blank. In any event, if they make a selection, the SelectedIndexChanged event fires.

Hope this helps,
earlofroberts

earlofroberts

Reputation Points: 10

Solved Threads: 1

Newbie Poster

Offline

13 posts
since May 2005

Permalink

Jul 6th, 2005

Re: Help with dropdownlist data adding?

Yep, having a default value for drop down lists is a good habit to get into I think. Try code something like this:

VB.NET Syntax (Toggle Plain Text)
Dim rdrCategory As SqlDataReader
myConnection.Open()
rdrCategory = cmdSelect.ExecuteReader(CommandBehavior.CloseConnection)
Dim liDefault As ListItem
liCategory = New ListItem([insert text for default entry here as String], [insert default value here as String])
lstCategories.Items.Add(liDefault)
Do While rdrCategory.Read()
     liCategory = New ListItem(rdrCategory("ShortName"), _
          rdrCategory("CategoryID")
     lstCategories.Items.Add(liCategory)
Loop
rdrCategory.Close()
Dim rdrCategory As SqlDataReader
myConnection.Open()
rdrCategory = cmdSelect.ExecuteReader(CommandBehavior.CloseConnection)
Dim liDefault As ListItem
liCategory = New ListItem([insert text for default entry here as String], [insert default value here as String])
lstCategories.Items.Add(liDefault)
Do While rdrCategory.Read()
     liCategory = New ListItem(rdrCategory("ShortName"), _
          rdrCategory("CategoryID")
     lstCategories.Items.Add(liCategory)
Loop
rdrCategory.Close()

npasma

Reputation Points: 14

Solved Threads: 0

Light Poster

Offline

41 posts
since Jun 2005

Permalink

Jul 8th, 2005

Re: Help with dropdownlist data adding?

Quote originally posted by Lemon ...

Well, I'm hoping someone can help me....

I've got a web application that queries data from a database based on selections made in previous dropdownlists. The problem is that some of the final queries return only one data item.

I'm using the onSelectedIndexChanged with autopostback enabled as my events in the lists. And thats the problem, if theres only one item in the dropdownlist, its imposible to change the index, thus I've got no event firing the next block of code I need executed...

If anyone has any idea on how to counter this problem, please help!
I thought if it were possible to add data to already manually inputted items already in the list, that'd be great, so that there's already 1 item in there before the other items are added... So that if only one item is retrieved by the from the database, there will be at least two items in there, allowing a change in the selected index...

Just how to do that though, I have no idea!

hi

u can make a check for only one item in the dropdownlist ,if its true make a call to the onSelectedIndexChanged with the required parameter

hope this helps u out

vrushalinz1

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

9 posts
since Jun 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in VB.NET Forum Timeline: Please Help!!!!

Next Thread in VB.NET Forum Timeline: MS Visual Basic.NET Step by Step

DaniWeb Message

Cancel Changes

User Name
Password