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

How to fetch row records on a button click

Administrator

Administrator