gridview pagesize value set by web.config not working

I would like to set the gridview pagesize value from a web.config entry.
Web.config has this:
<appSettings>
    <add key="pagingSize" value="20" />
</appSettings>

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!
ToolTimeGangAsked:
Who is Participating?
 
Imran Javed ZiaConsultant Software Engineer - .NET ArchitectCommented:
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;
            try
            {
                string s = System.Configuration.ConfigurationManager.AppSettings["AppPageSize"];
                pageSize = Convert.ToInt32(s);
            }
            catch { }
            return pageSize;
        }
        int pageSize = GetPageSize();
0
 
Imran Javed ZiaConsultant Software Engineer - .NET ArchitectCommented:
just change setting  text as
string s = System.Configuration.ConfigurationManager.AppSettings["pagingSize"];
0
 
ToolTimeGangAuthor Commented:
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)
0
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

 
Imran Javed ZiaConsultant Software Engineer - .NET ArchitectCommented:
you may use like this
PageSize='<%= GetPageSize() %>'
or
PageSize='<%= SomeGeneralUtilityClass.GetPageSize() %>'
Please mark it as answered if it is helpful
Thanks


0
 
ToolTimeGangAuthor Commented:
Thanks a bunch!  I'm good now!!!  I sure will mark your answer as helpful!
0
 
ToolTimeGangAuthor Commented:
Very speedy with answers.  2nd time today!  That is appreciated so very much!
0
 
Imran Javed ZiaConsultant Software Engineer - .NET ArchitectCommented:
You are most welcome,
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.