Show number of database records in an label?!

[Fox]

How can i show the number of records of an Database in an label?

 

[Erel]

Label1.Text = "Number of records: " & SQL.ExecQuerySingleResult("SELECT count(*) FROM table")

 

[Fox]

Sorry Erel i mean how you can i show on wich position is the entry in the table. That was what i mean sorry for my wrong question.

 

[Erel]

Which Table?

 

[Fox]

I mean the row or colum position in the database

 

[Erel]

There is no inherent meaning for such position in a database. You can add a column that will behave as the row id and then show its value.

 

[Merlot2309]

Hello,

When I understand you correctly the following should work:

Sub ListView_ItemClick (Position As Int, Value As Object)
ToastMessageShow(Position, True)
End Sub

Counting starts at zero.
This only works for rows in a ListView.
Helen.

 

[Fox]

Yes thank you it works