Help on databinding ?

[serge calderara]

Dear all,

I try to bind a particular column from a dataset to a listbox
What I am doing wrong in the following code ?

There is no error return but listbox is empty

Dim ds As New Data.DataSet
ds = m_DbLayer.GetReels(m_LineName)
ds.Tables(0).TableName = "REELHIST"

Dim dv As New DataView(ds.Tables(0))
Me.lstReelId.DataSource = dv
Me.lstReelId.DataMember = dv.Table.TableName
Me.lstReelId.DataBind()

thnanks for your help
regards
serge

[Eliyahu Goldin]

For the listbox set DataTextField and/or DataValueField.

Eliyahu

"serge calderara" <se************@discussions.microsoft.com> wrote in
message news:FD**********************************@microsof t.com...

Dear all,

I try to bind a particular column from a dataset to a listbox
What I am doing wrong in the following code ?

There is no error return but listbox is empty

Dim ds As New Data.DataSet
ds = m_DbLayer.GetReels(m_LineName)
ds.Tables(0).TableName = "REELHIST"

Dim dv As New DataView(ds.Tables(0))
Me.lstReelId.DataSource = dv
Me.lstReelId.DataMember = dv.Table.TableName
Me.lstReelId.DataBind()

thnanks for your help
regards
serge

[DKode]

try this instead:

Dim dv as New DataView(ds.Tables(0))
Me.lstReelld.DataSource = dv
Me.lstReelld.DisplayMember = "ItemName"
Me.lstReelld.ValueMember = "ItemID"
Me.lstReelld.DataBind()
There should be an error returned because I don't believe .DataMember
is a valid property in the ListBox control

[Peter Bromberg [C# MVP]]

ds = m_DbLayer.GetReels(m_LineName)
ds.Tables(0).TableName = "REELHIST"

Dim dv As New DataView(ds.Tables(0))
Me.lstReelId.DataSource = dv
Me.lstReelId.DataMember = dv.Table.TableName

Me.lstReelId.DataTextField = "ReelName" ' column name you want visible
Me.lstReelId.DataValueField ="ReelId" ' column you want for the value

Me.lstReelId.DataBind()
Hope that helps.
Peter

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"serge calderara" wrote:

Dear all,

I try to bind a particular column from a dataset to a listbox
What I am doing wrong in the following code ?

There is no error return but listbox is empty

Dim ds As New Data.DataSet
ds = m_DbLayer.GetReels(m_LineName)
ds.Tables(0).TableName = "REELHIST"

Dim dv As New DataView(ds.Tables(0))
Me.lstReelId.DataSource = dv
Me.lstReelId.DataMember = dv.Table.TableName
Me.lstReelId.DataBind()

thnanks for your help
regards
serge

[Karl Seguin [MVP]]

DisplayMember and ValueMember are for the WinForm listbox, not the web form
one. DataMember is if you want to bind to a specific named table inside a
dataset.

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/
"DKode" <dk****@gmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...

try this instead:

Dim dv as New DataView(ds.Tables(0))
Me.lstReelld.DataSource = dv
Me.lstReelld.DisplayMember = "ItemName"
Me.lstReelld.ValueMember = "ItemID"
Me.lstReelld.DataBind()
There should be an error returned because I don't believe .DataMember
is a valid property in the ListBox control

[DKode]

oh whoopsie,

when i posted the response i wasnt even looking at the newsgroup that
it was posted in

:)

my fault