have a problem converting the string to integer. tis is my SQL statement: Dim sqlStr As String = ("SELECT COUNT(*) FROM EventTable where ActionName = '" + TxtActionName.Text + "'"). i need to know the number of COUNT. i can i get the count from my sql statement and use it in my code?

 Hi , i cant under stand this statement.

Dim sqlStr As String = ("SELECT COUNT(*) FROM EventTable where ActionName = '" + TxtActionName.Text + "'").


what are u doing after this. where are u excecuting this query.
The i will tell u how to get the value