i have used this code, but i always get msgbox as 0.
What am i doing wrong.

vb Code:
  1. SqlStr = "SELECT Count(memberid) FROM members WHERE membername Like '*" & Me.TxtFind.Text & "*'"
  2.                 Using Conn As New OleDb.OleDbConnection(My.Settings.DMSConnectionString)
  3.                     Using Cmd As New OleDb.OleDbCommand(SqlStr, Conn)
  4.                         Conn.Open()
  5.                         MessageBox.Show(Cmd.ExecuteNonQuery().ToString)
  6.                         Conn.Close()
  7.                     End Using
  8.                 End Using