20-03-19, 06:47 PM
تعديل
Dim DataAdapter As New OleDbDataAdapter("SELECT * FROM EMPLOYEDETAILS_TB WHERE EMPLOYE_SHOWHIDE =true AND EMPLOYE_CODE = @code ORDER BY EMPLOYE_ID", con)
DataAdapter.SelectCommand.Parameters.AddWithValue("@code", Me.TXTSEARCH.Text.Trim())
Dim DataAdapter As New OleDbDataAdapter("SELECT * FROM EMPLOYEDETAILS_TB WHERE EMPLOYE_SHOWHIDE =true AND EMPLOYE_CODE = @code ORDER BY EMPLOYE_ID", con)
DataAdapter.SelectCommand.Parameters.AddWithValue("@code", Me.TXTSEARCH.Text.Trim())
