pa help nmn mga sir. Edit button problem..
may problem po ako sa edit button ko. Ang nangyari kasi, nagproproduce ng panibagong record ung system ko kapag ineedit ko ung record sa form ko. Ang dapat sana is irereplace lng nya ung specific data na pinalitan ko.
e2 po ung codes ko..
Private Sub btnEdit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnEdit.Click
If dgvSetting.Visible = True Then
EditSender()
fmSender.btnSSave.Text = "Update"
Else
Exit Sub
End If
End Sub
Sub EditSender()
Dim rsSSender As New ADODB.Recordset
rsSSender = New ADODB.Recordset
rsSSender.Open("SELECT * FROM sender_table WHERE sender_ID='" & dgvSetting.SelectedCells.Item(0).Value & "'", iconnect, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic)
If rsSSender.RecordCount <> 0 Then
With fmSender
.txtSLName.Text = rsSSender.Fields("sender_LName").Value
.txtSFName.Text = rsSSender.Fields("sender_FName").Value
.txtSMI.Text = rsSSender.Fields("sender_MI").Value
.txtSAddress.Text = rsSSender.Fields("sender_Address").Value
.txtSCNo.Text = rsSSender.Fields("sender_ContactNO").Value
.btnSSave.Text = "Update"
.Show(Me)
End With
Me.Enabled = False
Else
Exit Sub
End If
End Sub
PHELP Po!!! maraming salamat sa tutulong.
may problem po ako sa edit button ko. Ang nangyari kasi, nagproproduce ng panibagong record ung system ko kapag ineedit ko ung record sa form ko. Ang dapat sana is irereplace lng nya ung specific data na pinalitan ko.
e2 po ung codes ko..
Private Sub btnEdit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnEdit.Click
If dgvSetting.Visible = True Then
EditSender()
fmSender.btnSSave.Text = "Update"
Else
Exit Sub
End If
End Sub
Sub EditSender()
Dim rsSSender As New ADODB.Recordset
rsSSender = New ADODB.Recordset
rsSSender.Open("SELECT * FROM sender_table WHERE sender_ID='" & dgvSetting.SelectedCells.Item(0).Value & "'", iconnect, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic)
If rsSSender.RecordCount <> 0 Then
With fmSender
.txtSLName.Text = rsSSender.Fields("sender_LName").Value
.txtSFName.Text = rsSSender.Fields("sender_FName").Value
.txtSMI.Text = rsSSender.Fields("sender_MI").Value
.txtSAddress.Text = rsSSender.Fields("sender_Address").Value
.txtSCNo.Text = rsSSender.Fields("sender_ContactNO").Value
.btnSSave.Text = "Update"
.Show(Me)
End With
Me.Enabled = False
Else
Exit Sub
End If
End Sub
PHELP Po!!! maraming salamat sa tutulong.