Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1726
  • Last Modified:

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!
0
ToolTimeGang
Asked:
ToolTimeGang
  • 4
  • 3
3 Solutions
 
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
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
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.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now