This SqlDataSource need first 20 data dont need all data loadsSQLltaspSqlDataSource ID34dfdfdf34 runat34server34 ConnectionString34lt

Hi t01714500930You need to use TOP 20 Clause in select queryPlease refer below sampleHTMLltaspGridView ID34gvCustomers34 runat34server34 AutoGenerateColumns34false34 DataSourceID34GridDataSource34gt ltColumnsgt ltaspBoundField DataField34ContactName34 HeaderText34Customer Name34 gt ltaspBoundField DataField34City34 HeaderText34City34 gt ltaspBoundField DataField34Country34 HeaderText34Country34 gt ltColumnsgtltaspGridViewgtltaspSqlDataSource ID34GridDataSource34 runat34server34 ConnectionString34lt ConnectionStringsConstr gt34 SelectCommand34SELECT TOP 20 ContactName City Country FROM Customers34gtltaspSqlDataSourcegtScreenshot

ASP.Net SqlDataSource: Display first (top) Nth Records from Database

t0171450...

SOLVED CLOSED ACTIVE ANSWERED
User: t01714500930
Posted: on Feb 24, 2022 10:01 PM
Forum: Data Controls
Answer: 1
Views: 1579

This SqlDataSource need first 20 data don't need all data loads

SQL

<asp:SqlDataSource ID="dfdfdf" runat="server" 
    ConnectionString="<%$ ConnectionStrings:Helpline %>" 
    ProviderName="<%$ ConnectionStrings:Helpline.ProviderName %>" 
    SelectCommand="SELECT [User], Titel, format(UpdateDate, 'mmm yyyy') AS [Date], ID, askpublish, UpdateDate, Titel_English, Help_Catagary, Help_page_Tag, Country, PublistDate, answer, format(UpdateDate, 'YYYY-MM-DD') AS lastupdate FROM Help GROUP BY [User], Titel, format(UpdateDate, 'mmm yyyy'), ID, askpublish, format(UpdateDate, 'YYYY-MM-DD'), UpdateDate, Titel_English, Help_Catagary, Help_page_Tag, Country, PublistDate, answer HAVING (askpublish = TRUE) AND (NOT (Titel LIKE 'NULL')) AND (Country LIKE '%' + ? + '%') AND (Help_Catagary LIKE '%' + ? + '%') AND ([User] LIKE '%' + ? + '%') AND (Help_page_Tag LIKE '%' + ? + '%') AND (answer LIKE '%' + ? + '%') ORDER BY PublistDate DESC"    
    FilterExpression="Titel LIKE '%{0}%' OR Titel_English LIKE '%{0}%' OR Help_page_Tag LIKE '%{0}%'">
    <FilterParameters> 
</asp:SqlDataSource>

Download FREE API for Word, Excel and PDF in ASP.Net

arjunv

0 1

Reply
ANSWER
User: arjunv
Replied: on Feb 24, 2022 10:03 PM
Modified: on Jun 11, 2022 05:46 AM
Report

Hi t01714500930,

You need to use TOP 20 Clause in select query.

Please refer below sample.

HTML

<asp:GridView ID="gvCustomers" runat="server" AutoGenerateColumns="false" DataSourceID="GridDataSource">
    <Columns>
        <asp:BoundField DataField="ContactName" HeaderText="Customer Name" />
        <asp:BoundField DataField="City" HeaderText="City" />
        <asp:BoundField DataField="Country" HeaderText="Country" />
    </Columns>
</asp:GridView>

<asp:SqlDataSource ID="GridDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:Constr %>"
    SelectCommand="SELECT TOP 20 ContactName, City, Country FROM Customers"></asp:SqlDataSource>

Screenshot

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

ASP.Net SqlDataSource: Display first (top) Nth Records from Database

Company

Explore

Follow us

Contact Us