
Untitled
By: a guest on
Apr 29th, 2012 | syntax:
None | size: 0.66 KB | hits: 20 | expires: Never
Passing a JavaScript variable in SQL Datasource in ASP.Net C#
var div = document.getElementById('main_content').offsetHeight;
var length = Mah.round(div / 400);
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:qbuyConnectionString1 %>"
SelectCommand="SELECT TOP variable * FROM [advertisement] WHERE ([enable] = @enable) ORDER BY NEWID()">
<SelectParameters><asp:Parameter DefaultValue="1" Name="enable" Type="Int32" /></SelectParameters>
</asp:SqlDataSource>
$.get('query.asp', {length: length});
<input type="hidden" id="dataForSQL"></input>
$('#dataForSQL').html(length);