binding Navigator problem

Question

I Have Problem on binding navigator as a First column records & last column records of dtabase filed moving problem. if i am select datagriedview of 3rd records with datagriedview then problem is 1st element from datagredview is 3rd records and same problem on last records of datagredview.its not proper records show .please solve my problem & do needful. thanxs

Satyapriya Nayak · Answer

Also refer http://www.codeproject.com/Articles/15596/BindingSource-and-BindingNavigator-in-C-2-0 http://www.c-sharpcorner.com/UploadFile/718fc8/working-with-bindingnavigator-control/ Thanks If this post helps you mark it as answer

Satyapriya Nayak · Answer

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 App.config Form1.cs 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 Insert_update_delete_navigate { public partial class Form1 : Form { string ConnectionString = System.Configuration. ConfigurationSettings .AppSettings[ dsn ]; OleDbCommand com; OleDbDataAdapter oledbda; string str; DataSet ds; byte flag; BindingManagerBase bm; public Form1() { InitializeComponent(); } private void Form1_Load( object sender EventArgs e) { OleDbConnection con = new OleDbConnection (ConnectionString); con.Open(); str = select * from student ; com = new OleDbCommand (str con); oledbda = new OleDbDataAdapter (com); ds = new DataSet (); oledbda.Fill(ds student ); textBox1.DataBindings.Add( Text  ds student.id ); textBox2.DataBindings.Add( Text  ds student.name ); bm = this .BindingContext[ds student ]; con.Close(); bindgrid(); } private void bindgrid() { OleDbConnection con = new OleDbConnection (ConnectionString); con.Open(); str = select * from student ; com = new OleDbCommand (str con); oledbda = new OleDbDataAdapter (com); ds = new DataSet (); oledbda.Fill(ds student ); dataGridView1.DataMember = student ; dataGridView1.DataSource = ds; con.Close(); } private void btn_first_Click( object sender EventArgs e) { bm.Position = 0; } private void btn_next_Click( object sender EventArgs e) { bm.Position += 1; } private void btn_previous_Click( object sender EventArgs e) { bm.Position -= 1; } private void btn_last_Click( object sender EventArgs e) { bm.Position = bm.Count - 1; } private void btn_add_Click( object sender EventArgs e) { textBox1.Text =  ; textBox2.Text =  ; textBox1.Focus(); flag = 1; } private void btn_modify_Click( object sender EventArgs e) { flag = 2; } private void btn_save_Click( object sender EventArgs e) { if (flag == 1) { OleDbConnection con = new OleDbConnection (ConnectionString); con.Open(); str = insert into student(idname) values (@id@name) ; com = new OleDbCommand (str con); com.Parameters.AddWithValue( @sid  textBox1.Text); com.Parameters.AddWithValue( @sname  textBox2.Text); com.ExecuteNonQuery(); con.Close(); MessageBox .Show( Records Successfuly Inserted ); bindgrid(); } if (flag == 2) { OleDbConnection con = new OleDbConnection (ConnectionString); con.Open(); str = update student set name=' + textBox2.Text.Trim() + ' where id=' + textBox1.Text.Trim() + ' ; com = new OleDbCommand (str con); com.ExecuteNonQuery(); con.Close(); MessageBox .Show( Records Successfuly Updated ); bindgrid(); } } private void btn_delete_Click( object sender EventArgs e) { DialogResult result; result = MessageBox .Show( Are You sure want to Delete?  Conformation  MessageBoxButtons .YesNo); if (result == System.Windows.Forms. DialogResult .Yes) { OleDbConnection con = new OleDbConnection (ConnectionString); str = delete from student where id=@id ; com = new OleDbCommand (str con); com.Parameters.AddWithValue( @id  textBox1.Text); con.Open(); com.ExecuteNonQuery(); con.Close(); MessageBox .Show( Records Successfuly Deleted ); bindgrid(); } else { MessageBox .Show( No action ); } } } } /* Style Definitions */ table.MsoNormalTable{mso-style-name:Table Normal;mso-tstyle-rowband-size:0;mso-tstyle-colband-size:0;mso-style-noshow:yes;mso-style-priority:99;mso-style-qformat:yes;mso-style-parent:;mso-padding-alt:0in 5.4pt 0in 5.4pt;mso-para-margin:0in;mso-para-margin-bottom:.0001pt;mso-pagination:widow-orphan;font-size:11.0pt;font-family:Calibrisans-serif;mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;mso-fareast-font-family:Times New Roman;mso-fareast-theme-font:minor-fareast;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;mso-bidi-font-family:Times New Roman;mso-bidi-theme-font:minor-bidi;}