How to move a next and previous record?

Question

0.00/5 (No votes)

See more:

C#

public partial class Default2 : System.Web.UI.Page
{
    #region
    SqlConnection sc = new SqlConnection(ConfigurationManager.ConnectionStrings["ad"].ConnectionString);
    DataSet ds;
    int Maxrow=0;
    int inc =0;
    #endregion
    protected void Page_Load(object sender, EventArgs e)
    {
            sc.Open();      
            ds = new DataSet();
            SqlDataAdapter da = new SqlDataAdapter("select * from Customer", sc);
            da.Fill(ds, "ad");
            Navigate(); 
            Maxrow = ds.Tables["ad"].Rows.Count;
            
    }
    private void Navigate()
    {
        DataRow drow = ds.Tables["ad"].Rows[inc];
        TextBox1.Text = drow.ItemArray.GetValue(1).ToString();
        TextBox2.Text = drow.ItemArray.GetValue(2).ToString();
    }
    protected void Next_Click(object sender, EventArgs e)
    {
        if (inc != Maxrow-1)
        {
            inc++;
            Navigate();
        }
        else
        {
            MessageBox.Show("NoMore");
        }
        
    }
    protected void Pre_click(object sender, EventArgs e)
    {
        if (inc > 0)
        {
            inc--;
            Navigate();
        }
        //else
        //{
        //    MessageBox.Show("first ");
        //}
        
    }
    protected void Last_click(object sender, EventArgs e)
    {
        if (inc != Maxrow - 1)
        {
            inc = Maxrow - 1;
            Navigate();

        }
        
    }
    protected void Button5_Click(object sender, EventArgs e)
    {
        if (inc != 0)
        {
            inc = 0;
            Navigate();
        }
    }
    }

In this next and previous statements only take first two rows of table. Please clear doubt in c#

Posted 17-May-12 0:13am

JilRose

Updated 18-May-12 2:35am

v4

Add a Solution

3 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)

Dev-0001 · Answer 1 · 2012-05-17T00:38:00

Solution 2

C#

//Next -
 this.BindingContext[dt].Position += 1;
//Previous 
 this.BindingContext[dt].Position -= 1;
//First 
this.BindingContext[dt].Position  = 0;
//last  
this.BindingContext[dt].Count  = this.BindingContext[].Position -1;;

Posted 17-May-12 0:38am

Dev-0001

Comments

JilRose 17-May-12 6:49am

sorry! I can't understand.please explain it.

Maciej Los · Answer 2 · 2012-05-17T00:42:00

On a first look...

C#

protected void Next_Click(object sender, EventArgs e)
{
    if (inc < Maxrow-1) //(inc != Maxrow-1) <-- your condition
    {
//you can move to the next record until current record isn't last
}
protected void Pre_click(object sender, EventArgs e)
{
    if (inc >0) //(inc <0) <-- your condition
    {
//you can move to the previous record until current record isn't first
}

Jim Jos · Answer 3 · 2012-05-17T00:21:00

Solution 1

Then for previous your check should be if (inc > 0) isn't it? Also tell me how many rows you have what is the value of Maxrow?

Posted 17-May-12 0:21am

Jim Jos

Comments

JilRose 17-May-12 6:26am

total rows r 5.