Unable to cast object of type 'System.Int32' to type 'System.Data.DataRowView'

Question

I need to retrieve the "id" from datasource of the selected item, but it always throws the same error mentionned in the title. Here is my code

        Dim DMV As DataRowView = LbMCat.SelectedValue 'Here occurs the error
    SelectedMainCat = DMV.Item("id") 

    'Filling the SUB Categories part / same code used to fill Main categories
    Dim DataAdapterCats As New MySqlDataAdapter("SELECT * From catS where maincat = '" & SelectedMainCat & "';", MySqlConnection)
    Dim dsSc As New DataSet
    DataAdapterCats.Fill(dsSc, "SubCategories")
    Dim SDataTable As DataTable = dsSc.Tables(0)
    LbSCat.DataSource = SDataTable
    LbSCat.DisplayMember = "title"
    LbSCat.ValueMember = "id"

score 2 · Accepted Answer · answered Jul 12 '13 at 06:44

2

Do as below

Dim DMV As DataRowView = TryCast(LbMCat.SelectedItem, DataRowView)

If DMV IsNot Nothing Then
    SelectedMainCat = DMV.Item("id")
End If

answered Jul 12 '13 at 06:44

Damith

62,401
13
102
153

score 0 · Answer 2 · edited Jul 12 '13 at 07:57

0

Try to Direct Cast the value :

(DirectCast(LbmCat.SelectedItem, DataRowView)("ID").ToString())

See it here. It may help

edited Jul 12 '13 at 07:57

Rajeev Bera

2,021
1
16
30

answered Jul 12 '13 at 04:47

VB.NET LEARNER

711
5
11

Same error, Unable to cast object of type 'System.Int32' to type 'System.Data.DataRowView'. – Chaibi Alaa Jul 12 '13 at 04:50

score 0 · Answer 3 · answered Jul 12 '13 at 06:20

0

what if you check is the selected value is not integer??

If Not TypeOf (LbMCat.SelectedValue) Is Integer Then
    Dim DMV As DataRowView = LbMCat.SelectedValue 'Here occurs the error
    SelectedMainCat = DMV.Item("id")     
End If

answered Jul 12 '13 at 06:20

Bibek Gautam

581
8
30

Unable to cast object of type 'System.Int32' to type 'System.Data.DataRowView'

3 Answers3