hello :)
how to insert new record in grid view coming from textbox?
I tried to used the INSERT INTO -- sql query, but it didn't work..
does it have another way? please.
my current language is vb. thanks.
With mydataLupon
.DataFile = "~/Database/dbLupon.mdb"
.SelectCommand = "INSERT INTO tblLupon_C VALUES ('" & lblRegion_C.Text & "', '" & lblProvince.Text & "', '" & cmbCITYMUN.SelectedValue & "', '" & cmbBarangay.SelectedValue & "', '" & lblmyHide.Text & "', '" & txtLName.Text & "', '" & txtFName.Text & "', '" & txtmiddle.Text & "', '" & txtSuffix.Text & "', ' F ')"
.SelectCommand = "SELECT [COUNT_C], [POSITION_C], [LAST_M], [FIRST_M], [MIDDLE_M], [SUFFIX_M], [SEX_C] FROM tblLupon_C WHERE REGION_C = '" & lblRegion_C.Text & "' AND PROVINCE_C = '" & lblProvince.Text & "' AND CITYMUN_C = '" & cmbCITYMUN.SelectedValue & "' AND BARANGAY_C = '" & cmbBarangay.SelectedValue & "'"
MsgBox("saved")
End With
please answer me :)
your help will mean a lot :) thanks