: I use two common method to insert, update or delete records on database, they are
: //rs is adodb.recordset
: rs!Id = text1.text
: rs!Name = .....
: //db is adodb.connection
: db.execute(<sql syntax>)
: the Qustions are :
: which one do you think the best to use???
: why you choose it??
: any other simple&powerful method to doing this??
Execute require you to create a stored procedure in SQLserver and just call it anytime and much faster than new, update. but if you do not know how to create a stored procedure then use new, update.