I am inserting Data into sql server db and use ADODB Command to execute the sql query.
"command.Execute(out rowsAffected, ref missing, (int)ExecuteOptionEnum.adExecuteNoRecords)"
and add the the affected rows into recordset using this cmd :
"recordSet.Open(command, missing, CursorTypeEnum.adOpenStatic, LockTypeEnum.adLockReadOnly)"
the command is executed without error even the data is added to recordset but the data is not actually inserted(commited) to database.
no issue with connection string.
please suggest for this
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)