Insert Data Into Table with GridView or Calling Function

[troydixon]

Hello,
I am new at this, and have been trying to insert data into a table by using the footer of a gridview (which I dont like) or by using a detials view on the same page that is doing the following:

1) gets query string from url and filters records (works great) via a Details View
2) shows notes that have been added to the record shown in the details view using a grid view, and it filters the data by looking at the ID that is selected in the detailsview. (so Gridview filters by the detiailsview1.s electedvalue) Which works great..
3) I want to add a note that is related to the record by NoteID, so I added another Details view that has insert enabled and as long as I manually type the "DealID" which is not the PK for the table, I can add the note to the record. BUT if I create template controls out of the second detailsview and call a function that gets the selected value of the 1st details view (which populated the textbox correctly) and I hit Insert, nothing happens.

Using VB in visual Studio 2005
I have defaulted the view to insert mode.

Here is the code I use for getting the value to populate the Textbox (Ive tried both GetDeaalID() and GetNoteID() methods defined here which populates the control in the insert mode, but nothing happens when I enter text and click insert on the web form.):

Partial Class CallCenter_Defa ult
Inherits System.Web.UI.P age

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArg s) Handles Me.Load

Dim Username As String = " "
Session("Userna me") = Request.ServerV ariables("Auth_ user")
Label1.Text = Session("Userna me")


End Sub

Protected Function GetDealID()
Dim sDealID As String = ""
sDealID = Request.QuerySt ring("vendor_ID ")
Return sDealID
End Function

Protected Function GetViewID()
Dim sViewID As String = ""
sViewID = DetailsView1.Se lectedValue
Return sViewID
End Function

End Class


_______________ _______________ ________

And Here is the snippet from my DetailsView:

<asp:DetailsVie w ID="DetailsView 4" runat="server" AutoGenerateRow s="False" DataKeyNames="N oteID"
DataSourceID="S qlDataSource1" Height="50px" Width="125px">
<Fields>
<asp:TemplateFi eld HeaderText="Dea lID" SortExpression= "DealID">
<EditItemTempla te>
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("DealID") %>'></asp:TextBox>
</EditItemTemplat e>
<InsertItemTemp late>
<asp:TextBox ID="TextBox1" runat="server" Text='<%# GetViewID() %>'></asp:TextBox>
</InsertItemTempl ate>
<ItemTemplate >
<asp:Label ID="Label1" runat="server" Text='<%# Bind("DealID") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateFie ld>
<asp:BoundFie ld DataField="logi n" HeaderText="log in" SortExpression= "login" />
<asp:BoundFie ld DataField="Note " HeaderText="Not e" SortExpression= "Note" />
<asp:CommandFie ld ShowInsertButto n="True" />
</Fields>
</asp:DetailsView >


_______________ _______________ _______________ ________

Here is My Datasource Code:

<asp:SqlDataSou rce ID="SqlDataSour ce1" runat="server" ConnectionStrin g="<%$ ConnectionStrin gs:PCVSQLTestCo nnectionString %>"
DeleteCommand=" DELETE FROM [Notes] WHERE [NoteID] = @NoteID" InsertCommand=" INSERT INTO [Notes] ([DealID], [login], [Note]) VALUES (@DealID, @login, @Note)"
SelectCommand=" SELECT [DealID], [NoteID], [login], [Note] FROM [Notes] WHERE ([DealID] = @DealID)"
UpdateCommand=" UPDATE [Notes] SET [DealID] = @DealID, [login] = @login, [Note] = @Note WHERE [NoteID] = @NoteID">
<DeleteParamete rs>
<asp:Paramete r Name="NoteID" Type="Int32" />
</DeleteParameter s>
<UpdateParamete rs>
<asp:Paramete r Name="DealID" Type="Decimal" />
<asp:Paramete r Name="login" Type="String" />
<asp:Paramete r Name="Note" Type="String" />
<asp:Paramete r Name="NoteID" Type="Int32" />
</UpdateParameter s>
<SelectParamete rs>
<asp:ControlPar ameter ControlID="Deta ilsView1" Name="DealID" PropertyName="S electedValue"
Type="Decimal" />
</SelectParameter s>
<InsertParamete rs>
<asp:Paramete r Name="DealID" Type="Decimal" />
<asp:Paramete r Name="login" Type="String" />
<asp:Paramete r Name="Note" Type="String" />
</InsertParameter s>
</asp:SqlDataSour ce>