Following is my code. I look forward for your help.
Dim con As ADODB.Connection
Dim rs As ADODB.Recordset
Private Sub cmdNext_Click()
Set con = New ADODB.Connection
Set rs = New ADODB.Recordset
rs.Open
rs.MoveNext
End Sub
Private Sub CmdSave_Click()
Dim save As String
Set rs = New ADODB.Recordset
save = "insert into Evaluation values('" & serial.Text & "', '" & DateString.Text & "','" & Job.Text & "', '" & Achievement.Text & "', '" & Remarks.Text & "')"
rs.Open save, con, adOpenDynamic, adLockOptimistic
serial.Text = ""
DateString.Text = ""
Job.Text = ""
Achievement.Text = ""
Remarks.Text = ""
End Sub
Private Sub CmdSearch_Click()
Dim search As String
Set rs = New ADODB.Recordset
search = "select * from Evaluation where SlNo = '" & serial.Text & "' or Date = '" & DateString.Text & "' or JobResponsibilities = '" & Job.Text & "' or Achievement = '" & Achievement.Text & "'"
rs.Open search, con, adLockOptimistic, adOpenDynamic
serial.Text = rs!SlNo
DateString.Text = rs!Date
Job.Text = rs!JobResponsibilities
Achievement.Text = rs!Achievement
Remarks.Text = rs!Remarks
End Sub
Private Sub Form_Load()
Dim constr As String
Set con = New ADODB.Connection
constr = " Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;PWD=sa;Initial Catalog=Library;Data Source=PENJOR"
con.Open constr
End Sub