how to insert data shown in datalist to a different table in the database C#

[urko]

hi,

I have a datalist on the page where some data is shown. What i would like is to add a linkbutton so that registered users can add this data to its favorite list.


<asp:DataList ID="DataList1" runat="server" DataSourceID="PolnitevDetail">

<ItemTemplate>
<asp:Label class="Polnitev-podatki" ID="kroglaLabel" runat="server" Text='<%# Eval("PID") %>' />
<asp:Label class="Polnitev-podatki" ID="teza_krogleLabel1" runat="server" Text='<%# Eval("ID") %>'/>
<asp:Label class="Polnitev-podatki" ID="smodnikLabel" runat="server" Text='<%# Eval("UserId") %>' />
<asp:Label class="Polnitev-podatki" ID="smodnikLabel" runat="server" Text='<%# Eval("Nabojime") %>' />
<asp:Label class="Polnitev-podatki" ID="kroglaLabel" runat="server" Text='<%# Eval("krogla") %>' />
<asp:Label class="Polnitev-podatki" ID="teza_krogleLabel1" runat="server" Text='<%# Eval("teza_krogle") %>'/>
<asp:Label class="Polnitev-podatki" ID="smodnikLabel" runat="server" Text='<%# Eval("smodnik") %>' />

</ItemTemplate>
</asp:DataList>
<asp:AccessDataSource ID="PolnitevDetail" runat="server"
DataFile="~/App_Data/Orozje-Reloading-Center.mdb"
SelectCommand="SELECT * FROM [POLNITVE_QUERY] WHERE ([PID] = ?)"
InsertCommand="INSERT INTO MOJE_PRILJUBLJENE_POLNITVE(PID, ID, UserId, Nabojime, Krogla, teza_krogle, smodnik) VALUES (?, ?, ?, ?, ?, ?, ?)">

<SelectParameters>
<asp:QueryStringParameter Name="ID" QueryStringField="ID" Type="Int32" />
</SelectParameters>
<InsertParameters>
<asp:Parameter Name="UserId" Type="Int32" />
<asp:Parameter Name="ID" Type="Int32" />
<asp:Parameter Name="PID" Type="Int32" />
<asp:Parameter Name="Nabojime" Type="String" />
<asp:Parameter Name="Krogla" Type="String" />
<asp:Parameter Name="teza_krogle" Type="String" />
<asp:Parameter Name="smodnik" Type="String" />
</InsertParameters>
</asp:AccessDataSource>

<asp:LinkButton ID="LinkButton1" runat="server" onclick="LinkButton1_Click">LinkButton</asp:LinkButton>


and code behind


protected void LinkButton1_Click(object sender, EventArgs e)
{
PolnitevDetail.Insert();
}


At the moment, when i click the LinkButton, i get empty result in database. All fields are empty.

Also...i would also like to write in the code behind a code that in case a user click LinkButton and if this data is already in his favorites, he would get a message that this data is already in his favorites.

Thanks,