ASP.NET with C# and SQL SERVER , some vb.net . asp.net examples, asp.net codes, asp.net programs, c# code, sql server queries, important codes.
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>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment