vb.net custom datatable class

Question

I would like to create a custom datatable class in which the datarow class property "Item" is overloaded so that it returns a trimmed value.

How do I start? Maybe an example?

Class MyDatatable
Inherits DataTable

Public Overloads Property Item(ByVal columnIndex As Integer) As Object
Get

End Get
Set(value As Object)

End Set
End Property

End Class

Thx!

Create a new class that inherits DataTable and contains an Item property. — Devin Burke
– Devin Burke, Commented Jul 19, 2012 at 6:53
I don't know enought about DataTable to help you directly. But maybe you'll have to loop all items and trim them, or have the database query return a trimmed version of the string. — the_lotus
– the_lotus, Commented Jul 19, 2012 at 15:19

LarsTech · Accepted Answer · 2012-07-19 12:39:35Z

1

There isn't much to overload since the DataTable doesn't have an Item property. What you really want to do is inherit from DataRow, but that doesn't work because it has a required initializer (DataRowBuilder) that is inaccessible.

Maybe something like this:

Public Class MyDataTable
  Inherits DataTable

  Public Function Item(ByVal rowIndex As Integer, _
                       ByVal columnIndex As Integer) As Object
    Return MyBase.Rows(rowIndex)(columnIndex).ToString().Trim
  End Function

End Class

It's missing some obvious error checking. Not very practical either, since a cell could hold a lot more types than just strings.

answered Jul 19, 2012 at 12:39

LarsTech

81.9k14 gold badges161 silver badges237 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

ʃʈɑɲ Over a year ago

Hi LarsTech, thanks for this. The datatype in the cells will always be returned as string (IBM iSeries AS400) so not very error prone. Because the DataRowBuilder is inaccessable preventing to initialize DataRow class I think I'll have to mark your answer as definitive. =) grtz

Collectives™ on Stack Overflow

vb.net custom datatable class

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related