how to use postback c#

Question

0.00/5 (No votes)

See more: (untagged)

Hi,

I am quite new with C#. I have a web app that connects to a MySQL server and binds a gridview to it's data, on the Page_Load method of the code-behind file. I have 3 pages in my web app. Every time I click on the page it always loads the data from the SQL, in short it makes a connection every time I click the page. I want it to load only once, during the first time the page loads, so if the user goes back to the page it won't try to connect to the MySQL server. I currently have this on the Page_Load of each page

C#

protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
               if(DBconnection=true)
               {
               }
            }
        {

Any input is greatly appreciated.

Thanks!

Posted 11-Jul-12 6:30am

Franco Cipriano

Add a Solution

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)

Sandeep Mewara · Answer 1 · 2012-07-11T07:38:00

Using page property IsPostback helps as long as you are posting back to same page based on various events of the same page.
If you want to persist data across different pages then you need to store it in Session or Cache it. This way, you can get your data back without connecting to database as long as you have data stored.

Following would help:
MSDN: ASP.NET State Management Overview[^]
State management in ASP.NET - 1[^]

R. Ganesh Kumar IT · Answer 2 · 2012-07-11T07:52:00

Hi,

Postback is an event when a form is submitted back to the server for example by a button click.
If you want to fill the grid view only at the first time when the page loads and
if you do not want make a database connection during the button click event or similar events, you must enter the database connection page load and it should be within
if (!IsPostBack)
{
//Your code Here
}

So that the database connection occurs only once.
Not only database connection, you can also enter the code within not postback event for anything that must be loaded only at the beginning like loop statements.

Thank You,

Ganesh

how to use postback c#

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0