I have the following code.How would i execute the "Delete, Insert or Update' CommandText?VB Code:
'Set SQL statements With daStaff .DeleteCommand.CommandText = "DELETE FROM Staff" 'Delete statement .InsertCommand.CommandText = "INSERT INTO Staff" 'Insert statement .UpdateCommand.CommandText = SQLUpdateStr 'Update statement End With
When i am in the code window i see .ExecuteNonQuery, .ExecuteReader and .ExecuteScalar when i type daStaff.UpdateCommand. in the dropdown list. Which one, if any would i use?




Reply With Quote