Link to home
Start Free TrialLog in
Avatar of cyimxtck
cyimxtckFlag 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
Avatar of Priest04
Priest04
Flag of Serbia image

Set ComboBox DisplayMember to column name.

Goran
Avatar of cyimxtck

ASKER

Can you provide this example in the above code?

Thanks,

B
ASKER CERTIFIED SOLUTION
Avatar of Priest04
Priest04
Flag of Serbia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
perfect!  That one line can ruin your code you know...  :)