Record Navigation by a user's choice.

Question

Hiii members,   In my WinApp in C# with MS Access database, I want to navigate the records after input by a user.   I have checked many solutions on net on this topic but there is only one difference between them and mine is that, the solution works with the form-load event and my form is working after form load (on a button's click event) and based on user's criteria.   I want a solution for specific set of records and not all the records in the dt. in other words, if I have 5 suppliers and I want to see the records of only 1 supplier (e.g. supplier AAA) then I will enter value or name in a text box and click "Next' or 'Previous' to see the records only for AAA.   Please check the zip file attached that contains code file and a screen shot of my dt.   I hope I have cleard all the aspects and now waiting of your help. still you find any doubt please reply, I'll try my best to explain.   Thanks   Mayank

Mayank Jani · Answer

Hiii, Sorry again, same result...   as far as I understood, every time when I click 'Next', the click event for the button runs the query again and again and shows the first record.   could you please let me know if I can use any loop for the dataset? because I think, the query and dataset should not be there in the click event of the button. only execution of the dataset should be there, or something like that.   How about this... when click the 'Next' button, the query execute and dataset create only once then go to the loop until the records end... I do not know how to do that..   Thanks    Mayank Jani

Jefferson S. Motta · Answer

Ops,   try this and let me know:   using  System;     using  System.Collections.Generic;     using  System.ComponentModel;     using  System.Data;     using  System.Drawing;     using  System.Linq;     using  System.Text;     using  System.Windows.Forms;     using  System.Data.OleDb;          namespace  RecordNavigation     {          public  partial  class  Form1 : Form         {             OleDbConnection MyConn =  new  OleDbConnection(@ "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\SOFTWARES\Experiments\ExperimentsMAS.accdb" );                   public  Form1()             {                 InitializeComponent();                  // Prev button will be enabled after the btnNext_Click raises                btnPrev.Enabled =  false ;             }                               int  n = -1;  // moving index                    private   void  btnPrev_Click( object  sender, EventArgs e)             {                 OleDbDataAdapter FetchPrev =  new  OleDbDataAdapter( "Select * From FNPL Where PartyID='"  + textBox1.Text +  "' Order By PartySr DESC" , MyConn);                      DataSet dsFetchPrev =  new  DataSet();                 FetchPrev.Fill(dsFetchPrev);                        if  (dsFetchPrev.Tables[0].Rows.Count > 0                  && dsFetchPrev.Tables[0].Rows.Count >= n)               {                     n--;          // you need use the Rows[n], was 0, so it was getting always the first row                      textBox2.Text = (dsFetchPrev.Tables[0].Rows[n].ItemArray[2].ToString());                     textBox3.Text = (dsFetchPrev.Tables[0].Rows[n].ItemArray[3].ToString());                     textBox4.Text = (dsFetchPrev.Tables[0].Rows[n].ItemArray[4].ToString());                     textBox5.Text = (dsFetchPrev.Tables[0].Rows[n].ItemArray[5].ToString());                 }                       else                  {                     MessageBox.Show( "No More Record to Show." ,  "End of Record..." );                                       }                              }                   private   void  btnNext_Click( object  sender, EventArgs e)             {                 OleDbDataAdapter FetchNext =  new  OleDbDataAdapter( "Select * From FNPL Where PartyID='"  + textBox1.Text +  "' Order By PartySr" , MyConn);                      DataSet dsFetchNext =  new  DataSet();                 FetchNext.Fill(dsFetchNext);                       if  (dsFetchNext.Tables[0].Rows.Count >= 0                  && dsFetchNext.Tables[0].Rows.Count > n + 1)  // 1 >  -1 + 1 = 0                  {                     n++;                     textBox2.Text = (dsFetchPrev.Tables[0].Rows[n].ItemArray[2].ToString());                     textBox3.Text = (dsFetchPrev.Tables[0].Rows[n].ItemArray[3].ToString());                     textBox4.Text = (dsFetchPrev.Tables[0].Rows[n].ItemArray[4].ToString());                     textBox5.Text = (dsFetchPrev.Tables[0].Rows[n].ItemArray[5].ToString());                     btnPrev.Enabled =  true ;  // enable go prev                  }                  else                  {                                           MessageBox.Show( "No More Record to Show." ,  "End of Record..." );                                       }             }                   private   void  Form1_Load( object  sender, EventArgs e)             {                              }         }     }

Mayank Jani · Answer

Hiiii Jefferson S Motta,   thank you for your reply... I have tried the same but I'm sorry it's not working. I have attached two screen shots with necessary comments on them.  Please check them.   thanks once again...   Mayank Jani

Jefferson S. Motta · Answer

using  System;   using  System.Collections.Generic;   using  System.ComponentModel;   using  System.Data;   using  System.Drawing;   using  System.Linq;   using  System.Text;   using  System.Windows.Forms;   using  System.Data.OleDb;      namespace  RecordNavigation   {        public  partial  class  Form1 : Form       {           OleDbConnection MyConn =  new  OleDbConnection(@ "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\SOFTWARES\Experiments\ExperimentsMAS.accdb" );               public  Form1()           {               InitializeComponent();               btnPrev.Enabled =  false ;           }                         int  n = -1;  // moving index                private   void  btnPrev_Click( object  sender, EventArgs e)           {               OleDbDataAdapter FetchPrev =  new  OleDbDataAdapter( "Select * From FNPL Where PartyID='"  + textBox1.Text +  "' Order By PartySr DESC" , MyConn);                  DataSet dsFetchPrev =  new  DataSet();               FetchPrev.Fill(dsFetchPrev);                   //int p = dsFetchPrev.Tables[0].Rows.Count;                    if  (n > 0 && n              {                   n--;      // you need use the Rows[n], was 0, so it was getting always the first row                    textBox2.Text = (dsFetchPrev.Tables[0].Rows[n].ItemArray[2].ToString());                   textBox3.Text = (dsFetchPrev.Tables[0].Rows[n].ItemArray[3].ToString());                   textBox4.Text = (dsFetchPrev.Tables[0].Rows[n].ItemArray[4].ToString());                   textBox5.Text = (dsFetchPrev.Tables[0].Rows[n].ItemArray[5].ToString());               }                   else                {                   MessageBox.Show( "No More Record to Show." ,  "End of Record..." );                                   }                          }               private   void  btnNext_Click( object  sender, EventArgs e)           {               OleDbDataAdapter FetchNext =  new  OleDbDataAdapter( "Select * From FNPL Where PartyID='"  + textBox1.Text +  "' Order By PartySr" , MyConn);                  DataSet dsFetchNext =  new  DataSet();               FetchNext.Fill(dsFetchNext);                   if  (dsFetchNext.Tables[0].Rows.Count >= n+1)               {                   n++;                   textBox2.Text = (dsFetchPrev.Tables[0].Rows[n].ItemArray[2].ToString());                   textBox3.Text = (dsFetchPrev.Tables[0].Rows[n].ItemArray[3].ToString());                   textBox4.Text = (dsFetchPrev.Tables[0].Rows[n].ItemArray[4].ToString());                   textBox5.Text = (dsFetchPrev.Tables[0].Rows[n].ItemArray[5].ToString());                   btnPrev.Enabled =  true ;  // enable go prev                }                else                {                                       MessageBox.Show( "No More Record to Show." ,  "End of Record..." );                                   }           }               private   void  Form1_Load( object  sender, EventArgs e)           {                          }       }   }

Mayank Jani · Answer

Hiiiii Members,   waiting for the solution. Please help.

Amit Gupta · Answer

That means if abc party have 3 rows, you don't want to show all 3 rows to user at once and want that one by one using prev/next buttons. Is that you want?

Mayank Jani · Answer

Hi Amit,   thanks for reply... yes, I do not want to see all the records in the db but one by one for only one party which I have entered in the textbox.  Please refere the form I have attached. first user will insert an ID (suppose 1) and clicks on 'Next'. now I want to fetch all the records of ID 1, and display on the form one by one when click 'Next' and reverse when click 'Previous'

Amit Gupta · Answer

Don't you want to show all the records all at once based on partyID? May I know the scenario of the program, so that will give you the optimal solution