Sql Command command Type=2 status=0) The Row Updated event returns this output: event args: (command=System. Sql Command command Type=2 records Affected=1 row=System. EDIT: INSERT INTO Users (Username, Firstname, Lastname, Role Id, Receive Role Alerts, Status Id, Password, Fingerprint, Authenticity Check, Created By User Id, Creation Date, Modified By User Id, Modification Date) SELECT @Username AS Expr1, @Firstname AS Expr2, @Lastname AS Expr3, @Role Id AS Expr4, @Receive Role Alerts AS Expr5, @Status Id AS Expr6, @Password AS Expr7, @Fingerprint AS Expr8, @Authenticity Check AS Expr9, @Created By User Id AS Expr10, @Creation Date AS Expr11, @Modified By User Id AS Expr12, @Modification Date AS Expr13 WHERE (NOT EXISTS (SELECT Username, Firstname, Lastname, Role Id, Receive Role Alerts, Status Id, Password, Fingerprint, Authenticity Check, Created By User Id, Creation Date, Modified By User Id, Modification Date FROM Users AS Users_1 WHERE (Username = @Username))); Thank you for your quick reply.
Even though learning a new data access model may at first be daunting, it will also help you build modern, distributed applications.Row Updated = new Sql Row Updated Event Handler(da_Row Updated); Data Set ds = new Data Set(); // ... I am posting this question after reading other similar questions about my problem but not really understanding how I can use the information.Historically, Microsoft has provided support for accessing data in a variety of relational and nonrelational data stores by shipping APIs that existing VB developers have become quite familiar with over the years including VBSQL, ODBC, DAO, RDO, OLE DB, and ADO.Although this continued evolution meant that VB developers had to learn new techniques along the way, the benefits of learning the models meant a unified relational data access model (ODBC), increased simplicity (DAO), increased performance (RDO), and increased reach to nonrelational sources (ADO).