gridview pagesize value set by web.config not working

Posted on 2011-03-22
Last Modified: 2012-05-11
I would like to set the gridview pagesize value from a web.config entry.
Web.config has this:
    <add key="pagingSize" value="20" />

Open in new window

gridview has this:
                <asp:GridView ID="gvCustomers1" runat="server" DataSourceID="odsCustomers" 
                    AutoGenerateColumns="False" AllowSorting="True" AllowPaging="True" 
                    EmptyDataText="No data exists" CssClass="siteTable"  
                    DataKeyNames="CustomerID" ViewStateMode="Enabled" 
                    PageSize="<%$  appSettings:pagingSize %>" >

Open in new window

But this is not working.  I get "Int32Converter cannot convert from (null)".  If I hardcode it to 20, it works just fine.

Can you please tell me what I am doing wrong?  Thank you!
Question by:ToolTimeGang
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
LVL 16

Accepted Solution

Imran Javed Zia earned 125 total points
ID: 35193819
Hi ,
You can use following code in a method and code to access, make sure you have added related key and value in config appSettings

public static int GetPageSize()
            int pageSize = 20;
                string s = System.Configuration.ConfigurationManager.AppSettings["AppPageSize"];
                pageSize = Convert.ToInt32(s);
            catch { }
            return pageSize;
        int pageSize = GetPageSize();
LVL 16

Assisted Solution

by:Imran Javed Zia
Imran Javed Zia earned 125 total points
ID: 35193840
just change setting  text as
string s = System.Configuration.ConfigurationManager.AppSettings["pagingSize"];

Author Comment

ID: 35193948
Wow!  that was quick.  And it makes sense to me!  so then my setting would be like this:
PageSize=<%= GetPageSize %>

right?  (of course I would first have to add the logic in my code behind)
Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

LVL 16

Assisted Solution

by:Imran Javed Zia
Imran Javed Zia earned 125 total points
ID: 35193963
you may use like this
PageSize='<%= GetPageSize() %>'
PageSize='<%= SomeGeneralUtilityClass.GetPageSize() %>'
Please mark it as answered if it is helpful


Author Comment

ID: 35194036
Thanks a bunch!  I'm good now!!!  I sure will mark your answer as helpful!

Author Closing Comment

ID: 35194044
Very speedy with answers.  2nd time today!  That is appreciated so very much!
LVL 16

Expert Comment

by:Imran Javed Zia
ID: 35194048
You are most welcome,

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Color can increase conversions, create feelings of warmth or even incite people to get behind a cause. If you want your website to really impact site visitors, then it is vital to consider the impact color has on them.
There’s a good reason for why it’s called a homepage – it closely resembles that of a physical house and the only real difference is that it’s online. Your website’s homepage is where people come to visit you. It’s the family room of your website wh…
This video teaches users how to migrate an existing Wordpress website to a new domain.
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question