>Can anyone share any code snippets that show how to use a CURSOR ADAPTER to insert records into a SQL Server database ?? Thank you.

Ernie,
by example:
you have 'firms.dbo' in SQL Server database with structure:
mycode int(4) identity(yes)
myname nvarchar(30)

and CA with:

selectcmd
select Firms.myName from Firms

KeyFieldList:
mycode

UpdateNameList:
myName firms.myname

UpdatableFieldList:
myName

In init of form

this.DataEnvironment.AddObject("Firms","Firms")
this.DataEnvironment.Firms.CursorFill()

In add record button

INSERT INTO Firms (Name) VALUES ("the firm's name")

HTH