How to show next record

Question

Hi In my window application record is displayed in TextBox. I have a next Button on the form. I want to show next record in TextBox on Next Button Click(event). What will be code for it. plz help me. Thanks.

Satyapriya Nayak · Answer

Hi Alok Try this......... using System.Data.SqlClient; public class Form1 : System.Windows.Forms.Form { SqlConnection con=new SqlConnection(server=localhost;uid=sa;pwd=;database=pintu); SqlCommand com; SqlDataAdapter sqlda; DataSet ds=new DataSet(); String str; BindingManagerBase bm; private void btnload1_Click(object sender System.EventArgs e) { con.Open(); str = select * from student; com = new SqlCommand(strcon); sqlda = new SqlDataAdapter(com); ds = new DataSet(); sqlda.Fill(ds student); txtid.DataBindings.Add(Text ds student.sid); txtname.DataBindings.Add(Text ds student.sname); txtmarks.DataBindings.Add(Text ds student.smarks); txtaddress.DataBindings.Add(Text ds student.saddress); txtyear.DataBindings.Add(Text ds student.year); bm=this.BindingContext[dsstudent]; bm.Position = 0; con.Close(); } private void btnnext_Click(object sender System.EventArgs e) { bm.Position += 1; } } Thanks

Suthish Nair · Answer

How to display records as First-Next-Previous-Last in a Textboxes using Windows Application