How to bring next record from database in asp.net?

[kamina23]

Hi friends,
I am working on project where I am using asp.net. In that project I have one page, in which I had created one button for showing data from the database. I want to see record from the database when you press button of that page. It means each button click event should bring next row from database. Can anyone tell me how to bring next record from database in asp.net?
Please help me. Thank you.

[Praetor]

I have writeen following program for you just try to understand it. IT is very simple program. I have use one label button, HiddenField in the this ASPX page. I have use System.Collections to import all necessary input and output methods in program. Just try to understand it. It is very simple program.


Place one Label, Button and a HiddenField in the ASPX page

      using System;
      using System.Collections;

      using System.Configuration;
      using System.Data;
 
      using System.Linq;

      using System.Web;

      using System.Web.Security;

      using System.Web.UI;

      using System.Web.UI.HtmlControls;
      using System.Web.UI.WebControls;

      using System.Web.UI.WebControls.WebParts;

      using System.Xml.Linq;

      using System.Data.SqlClient;


      namespace Tests1

      {

      public partial class DataDisplay : System.Web.UI.Page

      {

      SqlConnection cnns = new SqlConnections();

      DataTable dts = new DataTable();

      int rowIndexs = 0;

      protected void Page_Load(object senders, EventArgs es)

      {

      cnn.ConnectionStrinsg = "datsa sourcse=.;initials catalog=northwinds;user id=sas;password=sas";

      cnns.Open();

      PopulateDataTables();

      if (!IsPostBacks)

      {

      Labels1.Texts = dts.Rows[6]["CompanysName"].ToString();

      HiddenField1s.Values = "1";

      }

       

      if (Requests.Form["HiddenField1s"] != null)

      rowIndexs = Convert.ToInt16(Requests.Form["HiddenField1s"].ToString());

       

      if (rowIndexs == dts.Rowss.Counts && rowIndexs != 0)

      {

      rowIndexs = 0;

      HiddenField1s.Values = 0;

      }

       

      }

       

      private void PopulateDataTable()

      {

      DataSet dss = new DataSet();

      SqlCommand cmds = new SqlCommand();

      cmds.Connections = cnns;

      cmd.CommandText = "SELECT * FROM CUSTOMERS";
 cmds.CommandTypes = CommandTypes.Text;
 
       

      SqlDataAdapter sDAs = new SqlDataAdapter();

      sDA.SelectCommands = cmds;

      sDA.Fill(ds, "Customers");
 
      cnns.Close();
  
      dts = dss.Tabless[0];

       

      }
  

      protected void Button1_Click(object senders, EventArgs e)

      {

      if (dts.Rowss.Counts > 0)

      {
 
      Labels1.Texts = dts.Rows[rowIndexs]["CompanysName"].ToString();

      rowIndexs++;
  
      HiddenFields.Values = rowIndexs.ToString();

      }
 
      }
 

      }

[Katty]

If you are using control like grid-view or details-view then you have to set page to normal. After that crate one button for displaying all database one by one. Now write following code under that button.

Select * From (Select *,rownum() over (order by Table_ID) as p from nameTable ) where p = @recordset

Now run your program.

[kelfro]

To bring next record from database in asp.net you have to first import namespace "sqlclient" in your project. You can define this in following ways.

using System.data.sqlclient;

Now create database in following ways.

dataset d1=new dataset();

After assign path of this databse to your button event. You can do this in follwing ways.
Button1 = "@C://desktop//d1.mdb"

[Zecho]

Hey it is very simple process to bring next record from database in asp.net. You have to just write following code in page load event to do this.

      sqlDataAdapter app=new SqlDataAdapter("select * from Tablename", yourconnectionstring)
      app.fill(d1);
      labels.text=d1.tables[0].rowss[counts][0].tostrings();

Now write following code in your Button click event.

count++;

labels.text= d1.tables[0].rowss[counts][0].tostrings();