Select max id in datatable

[MTmace]

How would I select the max value of a datatable?

intMaxID = Me.dsLossNotice.Tables("NameAddress").Select(???)

 

[jmcilhinney]

You would need to use the DefaultView to Sort the rows and then take the first:

myDataTable.DefaultView.Sort = "ID DESC"

intMaxID = myDataTable.DefaultView(0)("ID")

 

[ManicCW]

You can use query "SELECT MAX(TableName.ID) FROM TableName"