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
Goran