[RESOLVED] [2005] Unable to delete record

[aldrean]

MyConnection.Open()
                Dim delStr As String = "DELETE FROM PATIENTS WHERE PatientID='" & tboxPatientID.Text & "'"
                MyCommand = New OleDbCommand(delStr, MyConnection)
                MyCommand.ExecuteNonQuery()
                MyConnection.Close()

I am using this as my code for my delete button.PatientID was an autonumber field in my access database and apparently the application was giving me a "Data type mismatch in criteria expression" exception.When I replaced the string as " DELETE FROM PATIENTS WHERE LastName='" & tboxLastName.Text & "'", the code was doing fine, but of course it will delete all records with the same lastName.What could be a possible solution here?thanks...

[noshaba]

u need to check datatype of patient_id if its not of string type then u need to convert it like wise
suppose if its integer then need to some thing like this

Dim delStr As String = "DELETE FROM PATIENTS WHERE PatientID=" & val(tboxPatientID.Text) & ""

[aldrean]

thanks man for your promptness....