Avatar of cyimxtck
cyimxtck
Flag for United States of America asked on

dataset and datatables bind as "System.Data.DataRowView" instead of values

The correct number of rows is always returned but the output is the same for every row: "System.Data.DataRowView"

Can someone please explain to me why this is happening?

Any help is greatly appreciated.

Thanks,

B

Here is the function.  (I know it should be a sub, I just did this for quick illustration.)

    Protected Function YesNo() As DataSet

        Dim dt As DataTable
        dt = New DataTable("ColumnVal")
        Dim Row1, Row2, Row3 As DataRow

        Try
            Dim Name As DataColumn = New DataColumn("Name")
            'Name.DataType = System.Type.GetType("System.String")
            dt.Columns.Add(Name)

            Row1 = dt.NewRow()
            Row1.Item("Name") = sel.ToString
            dt.Rows.Add(Row1)

            Row2 = dt.NewRow()
            Row2.Item("Name") = "Yes".ToString
            dt.Rows.Add(Row2)

            Row3 = dt.NewRow()
            Row3.Item("Name") = "No".ToString
            dt.Rows.Add(Row3)
        Catch

        End Try

        Dim ds As New DataSet()
        ds = New DataSet()

        ds.Tables.Add(dt)

        cbo1.DataSource = ds.Tables("ColumnVal")
        cbo1.DataBind()

        Return ds

    End Function
Visual Basic.NET

Avatar of undefined
Last Comment
cyimxtck

8/22/2022 - Mon
Priest04

Set ComboBox DisplayMember to column name.

Goran
cyimxtck

ASKER
Can you provide this example in the above code?

Thanks,

B
ASKER CERTIFIED SOLUTION
Priest04

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
cyimxtck

ASKER
perfect!  That one line can ruin your code you know...  :)
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck