How to fetch row records on a button click

Question

Hi Suppose we have a table name 'emp' in Sql server having 4 fields in that having four TextBoxes and a button click name as Next in the aspx Or Windows form then i want to know that on a next button click event the values in the TextBoxes fetches a new row from the emp table on every click.

Senthilkumar · Answer

Hi I have designed the page what you expect. Instead of fetching from database i have created the datatable. You can write the sql connection to load the data table. Design Page: Untitled Page Employee Name: Address: City: State: Width=58px />  onclick=btnPrevious_Click />  Text=Next onclick=btnNext_Click Width=60px />  ID=btnLast runat=server Text=Last onclick=btnLast_Click Width=57px /> Code File: protected void Page_Load(object sender EventArgs e) { if (!Page.IsPostBack) { GenerateTable(); Session[CurrentPage] = 0; LoadPage(0); } } private void LoadPage(int position) { DataTable dt = (DataTable)Session[UsersTable]; if(dt.Rows.Count > 0) { DataRow dRow = dt.Rows[position]; txtName.Text = dRow[Name].ToString(); txtAddress.Text = dRow[Address].ToString(); txtCity.Text = dRow[City].ToString(); txtState.Text = dRow[State].ToString(); } Session[CurrentPage] = position.ToString(); } protected void btnPrevious_Click(object sender EventArgs e) { int currentPage = Convert.ToInt32(Session[CurrentPage].ToString()); if (currentPage > 0) { LoadPage(currentPage - 1); } } protected void btnNext_Click(object sender EventArgs e) { int currentPage = Convert.ToInt32(Session[CurrentPage].ToString()); DataTable dt = (DataTable)Session[UsersTable]; if (currentPage { LoadPage(currentPage + 1); } } protected void btnFirst_Click(object sender EventArgs e) { DataTable dt = (DataTable)Session[UsersTable]; if (dt.Rows.Count > 0) { LoadPage(0); } } protected void btnLast_Click(object sender EventArgs e) { DataTable dt = (DataTable)Session[UsersTable]; if (dt.Rows.Count > 0) { LoadPage(dt.Rows.Count - 1); } } private DataTable GenerateTable() { DataTable dTable = new DataTable(); DataColumn dColumn = null; DataRow dRow = null; dColumn = new DataColumn(); dColumn.ColumnName = SNO; dColumn.AutoIncrement = true; dColumn.AutoIncrementSeed = 1; dColumn.AutoIncrementStep = 1; dTable.Columns.Add(dColumn); dColumn = new DataColumn(); dColumn.ColumnName = Name; dTable.Columns.Add(dColumn); dColumn = new DataColumn(); dColumn.ColumnName = Address; dTable.Columns.Add(dColumn); dColumn = new DataColumn(); dColumn.ColumnName = City; dTable.Columns.Add(dColumn); dColumn = new DataColumn(); dColumn.ColumnName = State; dTable.Columns.Add(dColumn); dRow = dTable.NewRow(); dRow[Name] = Senthil; dRow[Address] = Bangalore; dRow[City] = Bangalore; dRow[State] = Karnataka; dTable.Rows.Add(dRow); dRow = dTable.NewRow(); dRow[Name] = Praveen; dRow[Address] = Raman nagar; dRow[City] = Chennai; dRow[State] = Tamilnadu; dTable.Rows.Add(dRow); dRow = dTable.NewRow(); dRow[Name] = Vinay; dRow[Address] = Bangalore; dRow[City] = Bangalore; dRow[State] = Karnataka; dTable.Rows.Add(dRow); dRow = dTable.NewRow(); dRow[Name] = Sanjay; dRow[Address] = Shivaji nagar; dRow[City] = Mumbai; dRow[State] = Maharastra; dTable.Rows.Add(dRow); dRow = dTable.NewRow(); dRow[Name] = Neetu; dRow[Address] = Pricad; dRow[City] = Delhi; dRow[State] = New Delhi; dTable.Rows.Add(dRow); Session[UsersTable] = dTable; return dTable; } Screenshot: Hope this will help you.

Satyapriya Nayak · Answer

Hi Deepak Try this... Normal 0 @ Page Language =C# AutoEventWireup =true CodeFile =Default.aspx.cs Inherits =_Default %> DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd> html xmlns =http://www.w3.org/1999/xhtml> head runat =server> title > Untitled Page title > head > body > form id =form1 runat =server> div > asp : Label ID =Label1 runat =server Text =ID Width =80> asp : Label > asp : TextBox ID =TextBox1 runat =server> asp : TextBox > br /> asp : Label ID =Label2 runat =server Text =Name Width =80> asp : Label > asp : TextBox ID =TextBox2 runat =server> asp : TextBox > br /> asp : Label ID =Label3 runat =server Text =Address Width =80> asp : Label > asp : TextBox ID =TextBox3 runat =server> asp : TextBox > br /> asp : Label ID =Label4 runat =server Text =Marks Width =80> asp : Label > asp : TextBox ID =TextBox4 runat =server> asp : TextBox > br /> asp : Label ID =Label5 runat =server Text =Year Width =80> asp : Label > asp : TextBox ID =TextBox5 runat =server> asp : TextBox > br /> asp : Button ID =btnfirst runat =server Text =First Width =60px onclick =btnfirst_Click /> asp : Button ID =btnprevious runat =server Text =Previous Width =60px onclick =btnprevious_Click /> asp : Button ID =btnnext runat =server Text =Next Width =60px onclick =btnnext_Click/> asp : Button ID =btnlast runat =server Text =Last Width =60px onclick =btnlast_Click/> br /> asp : GridView ID =GridView1 runat =server> asp : GridView > div > form > body > html > using System; 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; public partial class _Default : System.Web.UI. Page { string connStr = ConfigurationManager .ConnectionStrings[ ConnectionString ].ConnectionString; SqlCommand com; SqlDataAdapter sqlda; string str; static DataSet ds; static DataTable dt; static int r1; static int r2; protected void Page_Load( object sender EventArgs e) { SqlConnection con = new SqlConnection (connStr); try { if (!IsPostBack) { con.Open(); str = select * from student ; com = new SqlCommand (str con); sqlda = new SqlDataAdapter (com); ds = new DataSet (); sqlda.Fill(ds student ); dt = ds.Tables[ student ]; r1 = dt.Rows.Count; if (r1 > 0) { showfirst(); } r2 = 0; } } catch ( Exception ex) { Response.Write(ex.Message); } con.Close(); bindgrid(); } public void bindgrid() { SqlConnection con = new SqlConnection (connStr); con.Open(); str = select * from student ; com = new SqlCommand (str con); sqlda = new SqlDataAdapter (com); ds = new DataSet (); sqlda.Fill(ds student ); GridView1.DataSource = ds; GridView1.DataMember = student ; GridView1.DataBind(); con.Close(); } public void showfirst() { TextBox1.Text = dt.Rows[0].ItemArray[0].ToString(); TextBox2.Text = dt.Rows[0].ItemArray[1].ToString(); TextBox3.Text = dt.Rows[0].ItemArray[2].ToString(); TextBox4.Text = dt.Rows[0].ItemArray[3].ToString(); TextBox5.Text = dt.Rows[0].ItemArray[4].ToString(); } protected void btnfirst_Click( object sender EventArgs e) { showfirst(); } protected void btnprevious_Click( object sender EventArgs e) { SqlConnection con = new SqlConnection (connStr); try { if (r2 > 0) { r2 -= 1; TextBox1.Text = dt.Rows[r2].ItemArray[0].ToString(); TextBox2.Text = dt.Rows[r2].ItemArray[1].ToString(); TextBox3.Text = dt.Rows[r2].ItemArray[2].ToString(); TextBox4.Text = dt.Rows[r2].ItemArray[3].ToString(); TextBox5.Text = dt.Rows[r2].ItemArray[4].ToString(); } } catch ( Exception ex) { Response.Write(ex.Message); } finally { con.Close(); } } protected void btnnext_Click( object sender EventArgs e) { try { if (r2 { r2 += 1; TextBox1.Text = dt.Rows[r2].ItemArray[0].ToString(); TextBox2.Text = dt.Rows[r2].ItemArray[1].ToString(); TextBox3.Text = dt.Rows[r2].ItemArray[2].ToString(); TextBox4.Text = dt.Rows[r2].ItemArray[3].ToString(); TextBox5.Text = dt.Rows[r2].ItemArray[4].ToString(); } } catch ( Exception ex) { Response.Write(ex.Message); } } protected void btnlast_Click( object sender EventArgs e) { try { TextBox1.Text = ds.Tables[ student ].Rows[r1 - 1].ItemArray[0].ToString(); TextBox2.Text = ds.Tables[ student ].Rows[r1 - 1].ItemArray[1].ToString(); TextBox3.Text = ds.Tables[ student ].Rows[r1 - 1].ItemArray[2].ToString(); TextBox4.Text = ds.Tables[ student ].Rows[r1 - 1].ItemArray[3].ToString(); TextBox5.Text = ds.Tables[ student ].Rows[r1 - 1].ItemArray[4].ToString(); } catch ( Exception ex) { Response.Write(ex.Message); } } } Thanks If this post helps you mark it as answer