Code for next,previous,first,last records...

This code is for to get the first,last,previous,next records.....
==================================================================
If we want to see the next,previous,first,last means we will use code like ,


int n=0;//global declaration
datatable dt;
form_load()
{
con...............
................//connection whatever you want...
sqldataadapter da=new sqldataadapter("select * from ",con);
dataset ds=new dataset();
da.fill(ds,"ali");//ali is ur table name or whatever your table
dt=ds.tables["ali"];
display();
}

first_click() //first record button(<<)
{
n=0;
display();
}
previous_click() //previous record button(<)
{
n=n-1;
if(n==-1)
{
n=0;
messagebox.show("first record);
}
else
{
display();
}
}
next_click() //next record button(>)
{
n=n+1
if(n>dt.rows.count-1)
}
else
{
display();
}
}
last_click() //last record button(>>)
{
n=dt.rows.count-1;
display();
}

display() //display function
{
datarow dr=dt.rows[n];
textbox1.text=dr[0].tostring();
textbox2.text=dr[1].tostring();
}


Happy Coding,
BY,
R.A.Gladwin


Comments

Author: antogladwin10 Dec 2008 Member Level: Silver   Points : 1

hi javier,

i updated the code..thank you for your valuable comments..


by,
R.A.Gladwin

Author: antogladwin10 Dec 2008 Member Level: Silver   Points : 1

hi javier,

if you can't understand hereafter also means...im ready to explain, friend.thank you..

//FYI(For your information)

* display() is a function..

* first,last....are buttons

by,
R.A.Gladwin

Author: Sachin02 Jul 2009 Member Level: Gold   Points : 0

Its very use full article..Thanks a lot

Author: Anilkumar24 Aug 2009 Member Level: Bronze   Points : 2

When am using this code display error like this
Class, struct, or interface method must have a return type

I wrote the code like
public partial class RegisterPatient : Form
{
int n = 0;
datatable dt;
public RegisterPatient()
{
InitializeComponent();
}

private void RegisterPatient_Load(object sender, EventArgs e)
{
SqlConnection Con = new SqlConnection("Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=HMS1;Data Source=ALIGNSOFT9\\SQLEXPRESS");
Con.Open();
SqlDataAdapter da = new SqlDataAdapter("Select * from RegisterAdmitPatient_details", Con);
DataSet ds = new DataSet();
da.Fill(ds,"RegisterAdmitPatient_details");
dt=ds.tables["RegisterAdmitPatient_details"];
display ();
}


private void btnfirst_Click(object sender, EventArgs e)
{
n = 0;
display();
}

private void btnprevious_Click(object sender, EventArgs e)
{
n=n-1;
if(n==-1)
{
n=0;
messagebox.show("first record");
}
else
{
display();
}
}

private void btnNext_Click(object sender, EventArgs e)
{
n = n + 1;
if(n>dt.rows.count-1)
{
}
else
{
display();
}
}

private void btnlast_Click(object sender, EventArgs e)
{
n = dt.rows.count - 1;
display();
}
display() //display function
{
datarow dr=dt.rows[n];
textbox1.text=dr[0].tostring();
textbox2.text=dr[1].tostring();
}
}

Guest Author: pandu04 Apr 2012

hi
i have datagridview with filled data when i cell double clicked
the perticular row record will go to another form of textboxes.
in that form i have next and previous buttons.
how to get next record by incrementing already existing record and
by decrementing previous record



  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name:
    Email: