cyimxtck
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("Syste m.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
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("Syste
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
ASKER
Can you provide this example in the above code?
Thanks,
B
Thanks,
B
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
perfect! That one line can ruin your code you know... :)
Goran