i have used this code, but i always get msgbox as 0.
What am i doing wrong.
vb Code:
SqlStr = "SELECT Count(memberid) FROM members WHERE membername Like '*" & Me.TxtFind.Text & "*'" Using Conn As New OleDb.OleDbConnection(My.Settings.DMSConnectionString) Using Cmd As New OleDb.OleDbCommand(SqlStr, Conn) Conn.Open() MessageBox.Show(Cmd.ExecuteNonQuery().ToString) Conn.Close() End Using End Using





Reply With Quote