how to navigate through textboxes rewind

Question

0.00/5 (No votes)

See more:

hi all
i am trying to navigate to next record through textbox but have not yet succeeded, tried different approaches but with no result

C#

public partial class data_entry : System.Web.UI.Page
{
    SqlDataAdapter da1;
    DataTable dt1;
    int i = 0;
    protected void Page_Load(object sender, EventArgs e)
    {
        string strcon = ConfigurationManager.ConnectionStrings["gallup"].ConnectionString;
        string next = "SELECT * from city_breakup";
        da1 = new SqlDataAdapter(next, strcon);
        dt1 = new DataTable();
        da1.Fill(dt1);
    }
protected void btn_next_Click(object sender, EventArgs e)
    {
        if(i<dt1.Rows.Count-1){
            i++;
            txtlcity.Text=dt1.Rows[i]["city"].ToString();
            txtsample.Text = dt1.Rows[i]["sample"].ToString();
        }
    }
}

Posted 19-Jul-12 1:56am

mehdilahori

Add a Solution

Comments

ZurdoDev 19-Jul-12 7:57am

What's the question?

Sandeep Mewara 19-Jul-12 9:23am

This is not a well framed question! We cannot work out what you are trying to do/ask from the post. Please elaborate and be specific.
Use the "Improve question" link to edit your question and provide better information.

mehdilahori 19-Jul-12 10:55am

2 textboxes on page
txtCity
txtSample
one button
btnNext
when user clicks on button next record should be shown in respective textboxes
i am able to move to the next record only once but when i click next button second time nothing happens
can not store value of row index
thanks you very much

1 solution

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)

BobJanova · Answer 1 · 2012-07-19T03:31:00

Instance variables in the page class (in this case, i) are not stored between requests. You have a (very common) fundamental misunderstanding of the nature of a web application, and HTTP in general: your page class instance exists for the lifetime of a single HTTP request (i.e. a single request and response containing a page), and when the user requests a new page (for example by pressing a postback button) you will get a new instance, and i will be 0 again.

This misunderstanding is encouraged by the fakery that old school ASP.net indulges in (which is why I hate it): postback controls store lots of state in a very opaque way and make it look like your instance stays active and its state information is preserved. That is not the case as you discover when you try to write code similar to a WinForms application.

In this case I recommend simply making the 'next' button or link submit a query parameter that is the page to request, and extracting it from Request.Form in your page code.