ASP.NET Discussion Boards

ASPnoob10-Jul-07 20:31

10-Jul-07 20:31

Hi, I'm trying to read a blob from my database table but ran into a little problem that I can't seem to solve. The following code is used in the page load and the button_click section of the code behind. I got the exception

"Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index"

when I tried to view it in the browser.

<br />
Dim i As Integer<br />
For i = 0 To ListBox2.Items.Count - 1<br />
If ListBox2.Items(i).Selected Then<br />
Dim myCon As New OdbcConnection<br />
<br />
myCon = New OdbcConnection("Driver={MySQL ODBC 3.51 Driver};Server=myServer;Database=myDB;User=myUserassword=myPass;Option=3;")<br />
Dim cmd As New OdbcCommand("SELECT * FROM myTable where Professions = '"& ListBox2.Items(i).Text &"' ")<br />
<br />
myCon.Open()<br />
<br />
cmd.Connection = myCon<br />
<br />
Dim ds As New DataSet<br />
<br />
Dim ad As New OdbcDataAdapter(cmd)<br />
<br />
ad.Fill(ds)<br />
<br />
Me.ListBox2.DataSource = ds<br />
<br />
Me.ListBox2.DataTextField = "Professions"<br />
<br />
Me.ListBox2.DataBind()<br />
End If<br />
Next<br />

I searched online for possible causes of this error but, none of the causes that I found has anything to do with my situation. Please take a look to see what I might of missed, thank you in advance for your help.

-- modified at 3:46 Wednesday 11th July, 2007

Re: Index was out of range

Rhys Gravell10-Jul-07 20:46

Rhys Gravell

10-Jul-07 20:46

Where are you making this call in code? Is this Single or Multi select?

Have a look at MSDN[^], and the ListBox class, specifically the OnSelectedIndexChanged event and the SelectedIndex, SelectedItem and SelectedValue properties, ListBox members[^].

Rhys

"The trouble with having an open mind, of course, is that people will insist on coming along and trying to put things in it"

They say a little knowledge is a dangerous thing, but it's not one half so bad as a lot of ignorance."
Terry Pratchett

Re: Index was out of range

valerian.precop10-Jul-07 20:48

valerian.precop

10-Jul-07 20:48

I'm not sure exactly but you might take a look at
"SELECT * FROM myTable where Professions = 'ListBox2.Items(i).Text' "
shouldn't these be something like
"SELECT * FROM myTable where Professions = '" + ListBox2.Items(i).Text + "' "

(I used string concatenation from c# I'm not so good with VB Smile | :)

)

Tell me if it worked... Smile | :)

Just call me Valy... Smile | :)

Re: Index was out of range

ASPnoob10-Jul-07 20:55

ASPnoob

10-Jul-07 20:55

That mistake was already spotted when I last post a message a day ago but I forgot to change it when I paste the code in the message box. Unfortunately thats not the problem but thanks for your help. This call is made in the page load and in the button1_click sections of the code behind. The listbox is in multi-select mode.

Re: Index was out of range

Imran Khan Pathan10-Jul-07 20:56

Imran Khan Pathan

10-Jul-07 20:56

Hi
What u want to do here?

Your code is totally wrong.

Best Regard
Pathan

GOD HELP THOSE WHO HELP THEMSELVES

Re: Index was out of range

ASPnoob10-Jul-07 21:15

ASPnoob

10-Jul-07 21:15

I am trying to read blobs from a field in a database table. The blobs hold resumes and each resume can have one or many corresponding professions in the Professions field. I am trying to enable users to look up resumes forcertain professions by choosing one or many professions in the listbox. The Select statement selects my table where the text of the listitem chosen by the users match the profession in the Professions field.

Re: Index was out of range

Imran Khan Pathan10-Jul-07 21:33

Imran Khan Pathan

10-Jul-07 21:33

on which event u call this code?

Best Regard

Pathan

GOD HELP THOSE WHO HELP THEMSELVES

Re: Index was out of range

valerian.precop10-Jul-07 21:11

valerian.precop

10-Jul-07 21:11

Imran Khan Pathan is right... I didn't see it the first time but you are doing something like these

You have a "for" that walks through the listBox2 elements and sees which is selected...then you make a query in the database (inside that "for") and you bind the result of the query with the same listBox2...these alters the containt of the listBox2 and the for is not working anymore (ListBox2.Items.Count is not the same after you have done the binding in the "for" statement and also the ListBox2.Items are changed)

Just call me Valy... Smile | :)

Re: Index was out of range

Guffa10-Jul-07 21:12

Guffa

10-Jul-07 21:12

You are changing the items of the list box while you are looping through the items.

---
single minded; short sighted; long gone;

Re: Index was out of range

ASPnoob10-Jul-07 21:44

ASPnoob

10-Jul-07 21:44

I've used the for loop to determine the list item selected by the user. Then I used the select statement to select the profession that is equal to the text of the list item that was selected. If I change the contents of listbox2 during each iteration of the loop when I bind the data to listbox2, then does that mean I can't use the for loop like I did? Should I bind the data out side of the for loop? I'm going to try and change the sequence of my code, but please give me some suggestions on how to remedy this code.

Re: Index was out of range

Rhys Gravell10-Jul-07 21:50

Rhys Gravell

10-Jul-07 21:50

Try here...[^]

Re: Index was out of range

Imran Khan Pathan10-Jul-07 22:03

Imran Khan Pathan

10-Jul-07 22:03

Try this code

But dont call this function on Page Load Event if ur ListBox2'items are empty.

Dim i As Integer<br />
<br />
Dim myCon As New OdbcConnection<br />
<br />
myCon = New OdbcConnection("Driver={MySQL ODBC 3.51 Driver};Server=myServer;Database=myDB;User=myUserassword=myPass;Option=3;")<br />
<br />
For i = 0 To ListBox2.Items.Count - 1<br />
If ListBox2.Items(i).Selected Then<br />
<br />
Dim cmd As New OdbcCommand("SELECT * FROM myTable where Professions = '"& ListBox2.Items(i).Text &"' ")<br />
<br />
End If<br />
<br />
Next<br />
<br />
<br />
myCon.Open()<br />
<br />
cmd.Connection = myCon<br />
<br />
Dim ds As New DataSet<br />
<br />
Dim ad As New OdbcDataAdapter(cmd)<br />
<br />
ad.Fill(ds)<br />
<br />
Me.ListBox2.DataSource = ds<br />
<br />
Me.ListBox2.DataTextField = "Professions"<br />
<br />
Me.ListBox2.DataBind()<br />
<br />
<br />
Best Regard<br />

Pathan

GOD HELP THOSE WHO HELP THEMSELVES

just asking for compatibility....

moomoooomoo10-Jul-07 20:29

moomoooomoo

10-Jul-07 20:29

does crystal of asp.net 2003, dont have any problems if uploaded on a windows 2000/2003 server???

start a new beginning in every ending; thats what life for......

refresh the page asp.net2.0+c#

regin10-Jul-07 20:28

regin

10-Jul-07 20:28

i have datalist in that i used item templates as linkbutton and a datalist.. i used to click on the linkbutton to show the item template datalist..but i hav to referesh the page on each click on the linkbuton...hw can i do that?\
plz help me..
thanks

Re: refresh the page asp.net2.0+c#

N a v a n e e t h10-Jul-07 20:52

N a v a n e e t h

10-Jul-07 20:52

regimol wrote:
i used item templates as linkbutton and a datalist.

Do you mean one more datalist inside ?

regimol wrote:
.but i hav to referesh the page on each click on the linkbuton...hw can i do that

Now how you are showing datalist ?

My Website | Ask smart questions

Re: refresh the page asp.net2.0+c#

regin10-Jul-07 20:57

regin

10-Jul-07 20:57

yes...
its like..
all employee-id,s in thed link button.
all employee details in the data list..
but if i click on emp-1 hav to show the details of that emplyee.n tn click on emp2 have to refresh that page n shoe only emplyee 2 details...

Re: refresh the page asp.net2.0+c#

Imran Khan Pathan10-Jul-07 21:05

Imran Khan Pathan

10-Jul-07 21:05

First Bind all data on page load event
After that U can call javascript fnuction to show or hide inner datalist on click of LinkButton

Best Regard

Pathan

GOD HELP THOSE WHO HELP THEMSELVES

Re: refresh the page asp.net2.0+c#

regin10-Jul-07 21:15

regin

10-Jul-07 21:15

or hw can i do like this community?if i click on one qu it'll pop out..n if click once again it'll popup??

Re: refresh the page asp.net2.0+c#

Imran Khan Pathan10-Jul-07 21:25

Imran Khan Pathan

10-Jul-07 21:25

Take datalist in div tag and apply style="display:none;"

Javascript function

function visibility(divId)
{
if(document.GetElementById('divId').style.display=="none")
document.GetElementById('divId').style.display="block"
else
document.GetElementById('divId').style.display="none"
}

Best regard
Pathan

GOD HELP THOSE WHO HELP THEMSELVES

conversion in vb6 to vb.net [modified]

king2010-Jul-07 20:14

king20

10-Jul-07 20:14

I have some problem to convert vb6 to vb.net.. I m using the convertor "Transking".How to add the vb project in Transking. and how to get complete asp.net project.. Pls reply soon plz plz..............

Raja

-- modified at 5:01 Wednesday 11th July, 2007

Re: conversion in vb6 to vb.net

Paul Conrad13-Jul-07 12:20

Paul Conrad

13-Jul-07 12:20

What specific problem are you having?

"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus

about event fire

SwaSubhaVijju10-Jul-07 19:19

SwaSubhaVijju

10-Jul-07 19:19

hi.
i am in interview of machine test...
help me please.
i need event in datagrid
when we clicking cell of datagrid using mouse then that particular cell color has to be chaged.
how can i do........
can anyone help me.......
thanking u..

Re: about event fire

sidbaruah10-Jul-07 19:22

sidbaruah

10-Jul-07 19:22

just on mouse click or is that a button????

I was born dumb!!
Laugh | :laugh: