Listbox Selected Value

[Big E]

I'm using ASP.Net and SQL Server.
I have a listbox looks up data from a table and fills the listbox.
I have a stored procedure that looks up the selected values and tries to
show them as selected in the listbox. My FOR NEXT LOOP gets stuck on one
record in the datatable. There are 4 records in the datatable and only the
first one is selected. It never moves past the first record.

MyCommand.Fill(dsCom, "tblCommRealtorAssociation")

dtCom = dsCom.Tables("tblCommRealtorAssociation")

Dim i As Integer

For i = 0 To dtCom.Rows.Count - 1

lstCommunities.SelectedValue =
dsCom.Tables("tblCommRealtorAssociation").Rows(0)( "CommunityID")

Next

[Adam Barker]

I think you should be referencing the variable 'i' in the Rows indexer as
follows:

Dim i As Integer

For i = 0 To dtCom.Rows.Count - 1

lstCommunities.SelectedValue =
dsCom.Tables("tblCommRealtorAssociation").Rows(i)( "CommunityID")

Next

"Big E" <no****@nospam.com> wrote in message
news:eS****************@tk2msftngp13.phx.gbl...

I'm using ASP.Net and SQL Server.
I have a listbox looks up data from a table and fills the listbox.
I have a stored procedure that looks up the selected values and tries to
show them as selected in the listbox. My FOR NEXT LOOP gets stuck on one
record in the datatable. There are 4 records in the datatable and only the
first one is selected. It never moves past the first record.

MyCommand.Fill(dsCom, "tblCommRealtorAssociation")

dtCom = dsCom.Tables("tblCommRealtorAssociation")

Dim i As Integer

For i = 0 To dtCom.Rows.Count - 1

lstCommunities.SelectedValue =
dsCom.Tables("tblCommRealtorAssociation").Rows(0)( "CommunityID")

Next

[Big E]

You are right. Thanks.
How can I set more than one selected value on a listbox. It only sets the
last one in the dataset.

Thanks.

Big E

"Adam Barker" <ms***************@q-state.co.uk> wrote in message
news:O0**************@TK2MSFTNGP12.phx.gbl...

I think you should be referencing the variable 'i' in the Rows indexer as
follows:

Dim i As Integer

For i = 0 To dtCom.Rows.Count - 1

lstCommunities.SelectedValue =
dsCom.Tables("tblCommRealtorAssociation").Rows(i)( "CommunityID")

Next

"Big E" <no****@nospam.com> wrote in message
news:eS****************@tk2msftngp13.phx.gbl...

I'm using ASP.Net and SQL Server.
I have a listbox looks up data from a table and fills the listbox.
I have a stored procedure that looks up the selected values and tries to
show them as selected in the listbox. My FOR NEXT LOOP gets stuck on one
record in the datatable. There are 4 records in the datatable and only the first one is selected. It never moves past the first record.

MyCommand.Fill(dsCom, "tblCommRealtorAssociation")

dtCom = dsCom.Tables("tblCommRealtorAssociation")

Dim i As Integer

For i = 0 To dtCom.Rows.Count - 1

lstCommunities.SelectedValue =
dsCom.Tables("tblCommRealtorAssociation").Rows(0)( "CommunityID")

Next

[Adam Barker]

Set

ListBox1.SelectionMode = ListSelectionMode.Multiple

and

ListBox1.Items[0].Selected = true

which means you may have to slightly rework your database access code.

"Big E" <no****@nospam.com> wrote in message
news:e5**************@TK2MSFTNGP10.phx.gbl...

You are right. Thanks.
How can I set more than one selected value on a listbox. It only sets the
last one in the dataset.

Thanks.

Big E

"Adam Barker" <ms***************@q-state.co.uk> wrote in message
news:O0**************@TK2MSFTNGP12.phx.gbl...

I think you should be referencing the variable 'i' in the Rows indexer as

follows:

Dim i As Integer

For i = 0 To dtCom.Rows.Count - 1

lstCommunities.SelectedValue =
dsCom.Tables("tblCommRealtorAssociation").Rows(i)( "CommunityID")

Next

"Big E" <no****@nospam.com> wrote in message
news:eS****************@tk2msftngp13.phx.gbl...

I'm using ASP.Net and SQL Server.
I have a listbox looks up data from a table and fills the listbox.
I have a stored procedure that looks up the selected values and tries to show them as selected in the listbox. My FOR NEXT LOOP gets stuck on one record in the datatable. There are 4 records in the datatable and only

the first one is selected. It never moves past the first record.

MyCommand.Fill(dsCom, "tblCommRealtorAssociation")

dtCom = dsCom.Tables("tblCommRealtorAssociation")

Dim i As Integer

For i = 0 To dtCom.Rows.Count - 1

lstCommunities.SelectedValue =
dsCom.Tables("tblCommRealtorAssociation").Rows(0)( "CommunityID")

Next