Top 10 Filter

Question

How can i search like this top 10 or 25 or 50 or 100 pls help me

Naimish Makwana · Answer

Hello Jaya, You can use Top filter in your SQL query to get top data. You need to pass one parameter in your proc. And then use it in query like below. DECLARE @N INT; SET @N = ?; -- Placeholder for user-specified parameter SELECT TOP (@N) name FROM Table Thanks Naimish Makwana

Tuhin Paul · Answer

IF I try the Mongodb version of the accepted answer: int n = //user-specified parameter var topNames = collection.Find(_ => true) .Project(t => t.name) .Limit(n) .ToList(); collection is an instance of IMongoCollection and t represents the documents in the collection. I think Mongodb databases don't support a TOP keyword since they don't have a concept of ordering.

Tuhin Paul · Answer

here is the linq version of the accepted answer: int n = //user-specified parameter var topNames = context.Table .Select(t => t.name) .Take(n) .ToList(); context is an instance of your Entity Framework DbContext and Table is the name of the corresponding table.

Jaya Prakash · Answer

'>

Amit Mohanty · Answer

Check the attached zip file, this may help you to fix your issue.

Vishal Joshi · Answer

Hello On client side use this On server side use SettingsPager.PageSize=50; Thanks

Jaya Prakash · Answer

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { Label lblPgTotal = (Label)e.Row.FindControl("lblTotalPrice"); dPageTotal += Decimal.Parse(lblPgTotal.Text); } if (e.Row.RowType == DataControlRowType.Footer) { if (ViewState["TotalPrice"] != null && dPageTotal != 0) { Label lblPageTotal = (Label)e.Row.FindControl("lblPageTotal"); lblPageTotal.Text = dPageTotal.ToString("N2"); Label lblGrandTotal = (Label)e.Row.FindControl("lblGrandTotal"); lblGrandTotal.Text = ViewState["TotalPrice"].ToString(); } } } protected void lnkPage_Click(object sender, EventArgs e) { int pageIndex = int.Parse((sender as LinkButton).CommandArgument); this.GetCustomersPageWise(pageIndex); }

Jaya Prakash · Answer

Thank You all

Jignesh Kumar · Answer

Hello jaya prakash, Please refer this one, https://www.c-sharpcorner.com/blogs/custom-page-size-and-paging-for-asp-net-grid-view

Top 10 Filter

Answers (9)