SQLExpress ASP.NET Confusion

Hello,
I am just getting reaquainted with programming and all. I work in GIS mapping and am having diffilculty using  a ASP.net internet Map site and adding records to a needed database.

I would like to be able to add records to a linked SQLExpress table when the user clicks on a map location. I adapted the following code snippet from an example that does what I would like only using an .mdb file.
CODE:

    // create connection to database
                        var connection;
                        connection = Server.CreateObject("ADODB.Connection");
                        connection.Open("Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=OutdoorsExp;Data Source=NOLOGOSQLEXPRESS;");
                        status = "Can't access 'FishSQL' table.";

                        // create recordset
                        var recordset;
                        recordset = Server.CreateObject("ADODB.Recordset");
                        recordset.CursorType = 1
                        recordset.LockType = 3;
                        recordset.Open("dbo.FishTable", connection);

                       
                        status = "Can't append new record.";

                        // append record for clicked location
                        recordset.AddNew();
                        recordset.Fields("LongitudeI").Value = xco;
                        recordset.Fields("LatitudeI").Value = yco;
                       
                        recordset.Update();
                        recordset.Close();

                        // release the .mdb file
                        connection.Close();


However, this does not add anything to the SQLEx table. What am I missing?

I am thinking that it might have something to with the primary key.

I had a table with way more columns then just lat/longs (as above) but only coded it to add data to the latitude and longitude fields. Nothing got added of course. Would have to add data to every field that doesnt allow nulls.

How do I generate a random, unique ID for a primary key on the fly and for example add it to the appropriate column.

Thanks you in adavnce for any insights.