Handle Gridview Paging in asp.net

Question

0.00/5 (No votes)

See more:

I got my Database values in Gridview and I have implemented the paging, Then I am importing data to excelsheet, I have done all these things and now I want to add more functionality as follows.

I have added two radio buttons that are "Top 100 rows" and "Show All". I want to show top 100 rows when user select the appropriate radio button and show whole bunch of data on selection of other radio button.

Can anyone one provide me with some idea??

Posted 3-Nov-13 22:07pm

chahthuranga

Updated 3-Nov-13 23:10pm

VICK

v2

Add a Solution

Comments

Thomas ktg 4-Nov-13 4:41am

Do you mean that you want to export Top 100 rows when user selects the Radio Button "Select top 100 rows"?

chahthuranga 4-Nov-13 4:56am

yes

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Thomas ktg · Answer 1 · 2013-11-03T23:11:00

Below is the simple code to make you understand how to fetch Top 100 records. This is actually an idea to make it clear how you can do to fetch Top 100 rows.

C#

private DataTable GetDatasource()
{
    DataTable dtable = new DataTable();
    string _Query = string.Empty;
    _Query = "SELECT TOP 100 * FROM Customers";
    //Do the other stuffs here to fetch Top 100 records from Database.
    return dtable;
}

// On Radion Button Click event 
protected void btnRadioButton1_Click(object sender, EventArgs e)
{
   //Here the dtable will have Top 100 rows from Database. If you want to show this in the gridview assign the dtable to the gridview datasource.
   DataTable dtable = GetDatasource();
   //Export the dtable record to excel
   GridViewExportUtil.Export("Customers.xls", dtable);
}

Hope it helps.

Suk@nta · Answer 2 · 2013-11-03T23:41:00

Solution 2

write a sql query for raddio button1 select event
i.e string conString="select top 100 [columnsname]or [*] from tablename";
..
for radiobuttion2:
string conString="select [columnsname]or [*] from tablename"

Posted 3-Nov-13 23:41pm

Suk@nta