Thursday, 18 October 2012

datalist with sqldatasource with parameters in asp.net c#


<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>

No comments:

Post a Comment