how can i avoid data duplicate in the database?
i mean if i add in the fields that has been already save it will still save.
i don't know how to query or filter not to add the same info.
i have the code below but it still save if i input same as already in the database.
myqry = "INSERT INTO tblInformation(Firstname,LastName,Address) " myqry = myqry + "VALUES('" & txtFirst.Text & "','" & txtLast.Text & "','" & txtAddress.Text & "')" mycmd = New OleDbCommand With mycmd .CommandText = myqry .Connection = conn .ExecuteNonQuery() End With
i want is to query first before it add the data to avoid same info.