CODEWITHSUNDEEP
vb.netdatatable
lerne8423
lerne8423

Reputation: 31

Dataset with Datatable

I am trying to check if my dictionary contains values in my dataset.datatable and if its quantities in the second column of the dataset are less than or greater than the quantities in my datatable. I tried using the SELECT method but it doesn’t seem to work, I get the error BC30469 reference to non-shared member requires object reference? I was just trying to do a simple search in the table first to see if I can even do that..... apparently not. Thanks for the help!

 Dim row As DataRow = DataSet.DataTable.Select("ColumnName1 = 'value3'")
    If Not row Is Nothing Then
        searchedValue = row.Item("ColumnName2")
    End If

Upvotes: 1

Views: 114

Answers (1)

Christoph
Christoph

Reputation: 3642

You could get a dictionary to compare with the one you already have like this (assuming your key is a string and the amount an Int32 and that your dataset contains only one table):

Dim myDBDict As Dictionary(Of String, Int32) =
    From e In myDataSet.Tables(0).Rows.Cast(Of DataRow).ToDictionary(Of String, Int32)(
        Function(e) e.Field(Of String)("MyIDColumn"),
        Function(e) e.Field(Of Int32)("myAmountColumn"))

Upvotes: 1

Related Questions