-
sqlserver
plz help,
i ve connected through adodc to an sqlserver database, whenever i am at the first record of an empty table and say addnew,it adds one empty row in the table by itself along with the record specfied by me.
maybe its something with the EOFaction prop but what is it i dont know.this is the straightforward code;
Private Sub Command1_Click()
Text1.Text = ""
Text2.Text = ""
End Sub
Private Sub Command2_Click()
Adodc1.Recordset.AddNew
Adodc1.Recordset.Fields("nm") = Text1.Text
Adodc1.Recordset.Fields("marks") = Text2.Text
Adodc1.Recordset.Update
End Sub
-
never mind i got it , i dont have to empty the textboxes again .