Display Records in TextBoxes with First Next Previous Last in ASP.Net

Firuz

SOLVED CLOSED ACTIVE ANSWERED
User: Firuz
Posted: on Aug 10, 2015 02:39 AM
Forum: ASP.Net Web Forms
Answer: 1
Views: 3575
Sample Code: Download

Hi! I use article Mudassar Khan Implement Paging in DataList control in ASP.Net. It’s helpful for me. Now I want other method. Display Records as First-Next-Previous-Last in a Textboxes Using Asp.Net. How I can convert this code to Asp.Ne? It’s very important please help me!!!!

public Form1()
        {
            InitializeComponent();
            GetData();
        }
        DataSet ds = new DataSet();
        int i = 0;
        public void GetData()
        {
SqlCommand cmd = new SqlCommand("SELECT SURNAME,NAM,LASTNAME,BIRTHDAY,ADDRESS FROM INFO", con);
            SqlDataAdapter sda = new SqlDataAdapter(cmd);
            con.Open();
            sda.Fill(ds, "emp");
            dataGridView1.AutoGenerateColumns = false;
            dataGridView1.Columns[0].Name = "SURNAME";
            dataGridView1.Columns[0].HeaderText = "    SURNAME";
            dataGridView1.Columns[0].DataPropertyName = "SURNAME";
            dataGridView1.Columns[1].Name = "NAM";
            dataGridView1.Columns[1].HeaderText = "        NAME";
            dataGridView1.Columns[1].DataPropertyName = "NAM";
            dataGridView1.Columns[2].Name = "LASTNAME";
            dataGridView1.Columns[2].HeaderText = "    LASTNAME";
            dataGridView1.Columns[2].DataPropertyName = "LASTNAME";
            dataGridView1.Columns[3].Name = "BIRTHDAY";
            dataGridView1.Columns[3].HeaderText = "    BIRTHDAY";
            dataGridView1.Columns[3].DataPropertyName = "BIRTHDAY";
            dataGridView1.Columns[4].Name = "ADDRESS";
            dataGridView1.Columns[4].HeaderText = "    ADDRESS";
            dataGridView1.Columns[4].DataPropertyName = "ADDRESS";        
            dataGridView1.DataSource = ds.Tables["emp"];
            con.Close();
        }
        private void Add_Click(object sender, EventArgs e)
        {
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = con;
            cmd.CommandType = System.Data.CommandType.StoredProcedure;
            cmd.CommandText = "PINFO";
            con.Open();
            cmd.Parameters.AddWithValue("@Surname", Surname.Text.Trim());
            cmd.Parameters.AddWithValue("@Nam", Nam.Text.Trim());
            cmd.Parameters.AddWithValue("@Lastname", Lastname.Text.Trim());
            cmd.Parameters.AddWithValue("@Birthday", Birthday.Text);
            cmd.Parameters.AddWithValue("@Address", Address.Text.Trim());
            try
            {
                cmd.ExecuteNonQuery();
                con.Close();
                Surname.Text = string.Empty;
                Nam.Text = string.Empty;
                Lastname.Text = string.Empty;
                Birthday.Text = string.Empty;
                Address.Text = string.Empty;
                ds.Clear();
                GetData();
                Surname.Focus();
            }
            catch
            {
                MessageBox.Show("Error: Data not saved in database!!!");
            }
        }
       private void First_Click(object sender, EventArgs e)
        {
            if (ds.Tables[0].Rows.Count > 0)
            {
                i = 0;
                Surname.Text = ds.Tables[0].Rows[i]["SURNAME"].ToString();
                Nam.Text = ds.Tables[0].Rows[i]["NAM"].ToString();
                Lastname.Text = ds.Tables[0].Rows[i]["LASTNAME"].ToString();
                Birthday.Text = ds.Tables[0].Rows[i]["BIRTHDAY"].ToString();
                Address.Text = ds.Tables[0].Rows[i]["ADDRESS"].ToString();
            }

        }

        private void Next_Click(object sender, EventArgs e)
        {
            if (i < ds.Tables[0].Rows.Count - 1)
            {
                i++;
                Surname.Text = ds.Tables[0].Rows[i]["SURNAME"].ToString();
                Nam.Text = ds.Tables[0].Rows[i]["NAM"].ToString();
                Lastname.Text = ds.Tables[0].Rows[i]["LASTNAME"].ToString();
                Birthday.Text = ds.Tables[0].Rows[i]["BIRTHDAY"].ToString();
                Address.Text = ds.Tables[0].Rows[i]["ADDRESS"].ToString();
            }
            else
            {
            }

        }

        private void Back_Click(object sender, EventArgs e)
        {
            if (i == ds.Tables[0].Rows.Count - 1 || i != 0)
            {
                i--;
                Surname.Text = ds.Tables[0].Rows[i]["SURNAME"].ToString();
                Nam.Text = ds.Tables[0].Rows[i]["NAM"].ToString();
                Lastname.Text = ds.Tables[0].Rows[i]["LASTNAME"].ToString();
                Birthday.Text = ds.Tables[0].Rows[i]["BIRTHDAY"].ToString();
                Address.Text = ds.Tables[0].Rows[i]["ADDRESS"].ToString();
            }
            else
            {
                //No records to see more
            }

        }

        private void End_Click(object sender, EventArgs e)
        {
            i = ds.Tables[0].Rows.Count - 1;
            Surname.Text = ds.Tables[0].Rows[i]["SURNAME"].ToString();
            Nam.Text = ds.Tables[0].Rows[i]["NAM"].ToString();
            Lastname.Text = ds.Tables[0].Rows[i]["LASTNAME"].ToString();
            Birthday.Text = ds.Tables[0].Rows[i]["BIRTHDAY"].ToString();
            Address.Text = ds.Tables[0].Rows[i]["ADDRESS"].ToString();
        }
    }

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 1

Reply
ANSWER
User: dharmendr
Replied: on Aug 11, 2015 06:16 AM
Modified: on Aug 28, 2017 05:07 AM
Report

Hi Firuz,

I have made a sample that fill-fill your requirement.

Code

protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        this.GetData();
    }
}
protected void btnAdd_Click(object sender, EventArgs e)
{
    string str = ConfigurationManager.ConnectionStrings["conString"].ConnectionString;
    SqlConnection con = new SqlConnection(str);
    SqlCommand cmd = new SqlCommand("PINFO", con);
    con.Open();
    cmd.CommandType = CommandType.StoredProcedure;
    cmd.Parameters.AddWithValue("@SURNAME", txtSurname.Text.Trim());
    cmd.Parameters.AddWithValue("@NAM", txtName.Text.Trim());
    cmd.Parameters.AddWithValue("@LASTNAME", txtLastName.Text.Trim());
    cmd.Parameters.AddWithValue("@BIRTHDAY", txtBirthday.Text);
    cmd.Parameters.AddWithValue("@ADDRESS", txtAddress.Text.Trim());
    try
    {
        cmd.ExecuteNonQuery();
        this.GetData();
        con.Close();
    }
    catch
    {
    }
}
protected void btnFirst_Click(object sender, EventArgs e)
{
    DataTable dt = (DataTable)ViewState["emp"];
    if (dt.Rows.Count > 0)
    {
        int firstIndex = 0;
        txtSurname.Text = dt.Rows[firstIndex]["SURNAME"].ToString();
        txtName.Text = dt.Rows[firstIndex]["NAM"].ToString();
        txtLastName.Text = dt.Rows[firstIndex]["LASTNAME"].ToString();
        txtBirthday.Text = dt.Rows[firstIndex]["BIRTHDAY"].ToString();
        txtAddress.Text = dt.Rows[firstIndex]["ADDRESS"].ToString();
        Session["CurrentIndex"] = firstIndex;
    }
}
protected void btnNext_Click(object sender, EventArgs e)
{
    DataTable dt = (DataTable)ViewState["emp"];
    int currentIndex = Convert.ToInt32(Session["CurrentIndex"]);
    if (currentIndex == dt.Rows.Count - 1)
    {
        currentIndex = 0;
        txtSurname.Text = dt.Rows[currentIndex]["SURNAME"].ToString();
        txtName.Text = dt.Rows[currentIndex]["NAM"].ToString();
        txtLastName.Text = dt.Rows[currentIndex]["LASTNAME"].ToString();
        txtBirthday.Text = dt.Rows[currentIndex]["BIRTHDAY"].ToString();
        txtAddress.Text = dt.Rows[currentIndex]["ADDRESS"].ToString();
        Session["CurrentIndex"] = currentIndex;
    }
    else if (dt.Rows.Count > 0)
    {
        txtSurname.Text = dt.Rows[currentIndex + 1]["SURNAME"].ToString();
        txtName.Text = dt.Rows[currentIndex + 1]["NAM"].ToString();
        txtLastName.Text = dt.Rows[currentIndex + 1]["LASTNAME"].ToString();
        txtBirthday.Text = dt.Rows[currentIndex + 1]["BIRTHDAY"].ToString();
        txtAddress.Text = dt.Rows[currentIndex + 1]["ADDRESS"].ToString();
        Session["CurrentIndex"] = currentIndex + 1;
    }
}
protected void btnPrevious_Click(object sender, EventArgs e)
{
    DataTable dt = (DataTable)ViewState["emp"];
    int currentIndex = Convert.ToInt32(Session["CurrentIndex"]);
    if (currentIndex == 0)
    {
        currentIndex = dt.Rows.Count;
    }
    if (dt.Rows.Count > 0)
    {
        txtSurname.Text = dt.Rows[currentIndex - 1]["SURNAME"].ToString();
        txtName.Text = dt.Rows[currentIndex - 1]["NAM"].ToString();
        txtLastName.Text = dt.Rows[currentIndex - 1]["LASTNAME"].ToString();
        txtBirthday.Text = dt.Rows[currentIndex - 1]["BIRTHDAY"].ToString();
        txtAddress.Text = dt.Rows[currentIndex - 1]["ADDRESS"].ToString();
        Session["CurrentIndex"] = currentIndex - 1;
    }
}
protected void btnLast_Click(object sender, EventArgs e)
{
    DataTable dt = (DataTable)ViewState["emp"];
    int lastIndex = dt.Rows.Count - 1;
    txtSurname.Text = dt.Rows[lastIndex]["SURNAME"].ToString();
    txtName.Text = dt.Rows[lastIndex]["NAM"].ToString();
    txtLastName.Text = dt.Rows[lastIndex]["LASTNAME"].ToString();
    txtBirthday.Text = dt.Rows[lastIndex]["BIRTHDAY"].ToString();
    txtAddress.Text = dt.Rows[lastIndex]["ADDRESS"].ToString();
    Session["CurrentIndex"] = lastIndex;
}
public void GetData()
{
    string str = ConfigurationManager.ConnectionStrings["conString"].ConnectionString;
    SqlConnection con = new SqlConnection(str);
    SqlDataAdapter sda = new SqlDataAdapter("SELECT SURNAME,NAM,LASTNAME,BIRTHDAY,ADDRESS FROM INFO", con);
    DataSet ds = new DataSet();
    sda.Fill(ds, "emp");
    //gvEmp.DataSource = ds.Tables["emp"];
    //gvEmp.DataBind();
    ViewState["emp"] = ds.Tables["emp"];
    Session["CurrentIndex"] = 0;
}

Screenshot

Hope this will help you.

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Display Records in TextBoxes with First Next Previous Last in ASP.Net

Company

Explore

Follow us

Contact Us