GUID Issues

My database is using the membership store for all the user information. I added a tabel "Skills" with 3 fields "SkillID (GUID)" "SeekerID (GUID, This is the UserId)" and "SkillName ( Varchar(MAX))"

on the page i have a ListView setup to display the SkillName fields based on the SeekerID.

The original code was     Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

          ' Get a reference to the currently logged on user          Dim CurrentUser As MembershipUser = Membership.GetUser

          ' Determine the currently logged on user's UserId value

          Dim SeekerID As Guid = CType(CurrentUser.ProviderUserKey, Object)

     End Subthat kept returning string to GUID conversion errors, so i had to change  Dim SeekerID As Guid = CType(CurrentUser.ProviderUserKey, Object) to Dim SeekerID As Object = CType(CurrentUser.ProviderUserKey.ToString(), Object) that appears to be working now. On the same page however, I want to insert records into the table, I tried 2 options both of which have a different problem.

     Option 1: Use a textbox (ID = NewSkill) and a button with the following code on it:

          Protected Sub SetNewSkill_Click(ByVal sender As Object, ByVal e As System.EventArgs)               Dim CurrentUser As MembershipUser = Membership.GetUser

               Dim SeekerGUID As Object = CType(CurrentUser.ProviderUserKey, Object)

 

               Dim NewSkill As TextBox = CType(FindControl("NewSkill"), TextBox)               Dim connectionString As String = ConfigurationManager.ConnectionStrings("QJSdatabase").ConnectionString()

               Dim insertSql As String = "INSERT INTO Skills(SeekerID, SkillName)VALUES(@SeekerGUID, @NewSkill)"               Using myConnection As New SqlConnection(connectionString)

                    myConnection.Open()                    Dim myCommand As New SqlCommand(insertSql, myConnection)

                    myCommand.Parameters.AddWithValue("@SeekerGUID", SeekerGUID)                    myCommand.Parameters.AddWithValue("@NewSkill", NewSkill.Text.Trim())

                    myCommand.ExecuteNonQuery()

                    myConnection.Close()

               End Using

          End Sub

 

     Problem: myCommand.Parameters.AddWithValue("@NewSkill", NewSkill.Text.Trim())  gets outlined and returns the error: Object reference not set to an instance of an object

 

     Option 2: Use a DetailsView linked to a SQLDataSource on the page

           <asp:DetailsView ID="DetailsView1" runat="server" Height="50px" Width="210px"

               AutoGenerateRows="False" DataSourceID="SqlDataSource2" DefaultMode="Insert">                    <Fields>

                         <asp:BoundField DataField="SkillName" HeaderText="Add Skill:" SortExpression="SkillName" />

                         <asp:CommandField ShowInsertButton="True" />

                         <asp:TemplateField InsertVisible="False">

                              <EditItemTemplate>

                                   <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>

                              </EditItemTemplate>

                              <ItemTemplate>

                                   <asp:Label ID="Label1" runat="server"></asp:Label>

                              </ItemTemplate>

                    </asp:TemplateField>

               </Fields>

          </asp:DetailsView>

           <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:database %>"

               DeleteCommand="DELETE FROM [Skills] WHERE [SkillID] = @SkillID"                InsertCommand="INSERT INTO [Skills] ([SeekerID], [SkillName]) VALUES (@SeekerGUID, @SkillName)"

               SelectCommand="SELECT SkillName FROM [Skills]"

               UpdateCommand="UPDATE [Skills] SET [SkillName] = @SkillName WHERE [SkillID] = @SkillID">

                    <DeleteParameters>

                         <asp:Parameter Name="SkillID" Type="Object" />

                    </DeleteParameters>

                    <InsertParameters>

                         <asp:Parameter Name="SeekerGUID" Type="Object" />

                         <asp:Parameter Name="SkillName" Type="String" />

                    </InsertParameters>

                    <UpdateParameters>

                         <asp:Parameter Name="SkillName" Type="String" />

                         <asp:Parameter Name="SkillID" Type="Object" />

                    </UpdateParameters>

            </asp:SqlDataSource>

 

            http://junk.icore-studios.com/junk/Codeissues/postresumeerror.html

The @SeekerGUID is being generated by the same pageload code as the first chunk i gave (I have 2 variables SeekerID is the GUID converted to string to work with the ListView filter and SeekerGUID is the GUID)

 

Ultimatly getting either option to work would be fine. Though I think the second would be preferable because I think it'd be easier to replicate later on.

Thanks in advance for your time and any help