data access from database

Question

sir, we are very new to vb.net.I just wanted to know how to retrieve a particular column entry from the last row? please give the reply as early as possible.

saphiroth42 · Answer

one way to retrieve a particual entry from a particual column is sqlUpperLower = "Select UB, LB, Path, Form from NameDB" 'selects 4 colums in Table This is an SQL statement selecting 4 columns in a table AdaptUpperLower = New OleDbDataAdapter(sqlUpperLower, conn) This creates an OLEDB Adapter if you are using Access. This adapter creates commands which will delete, retreive, or change values in the DB Private TableUpperLower As New DataTable This creates a new datatable AdaptUpperLower.Fill(TableUpperLower) This uses the adapter to fill a that datatable (TableName.Rows(RowPosition)("NameofColumn")).ToString() where position would be the last row. Use a counter or just put in a number into RowPosition value and you will get the value in that row from that column. the .ToString casts the value in the row as a type string. That is, if the original value was a string in the database. Then assign this value to a string and you can print it or something.

data access from database

Answers (1)