Working With a BindingNavigator Control in Windows Form

CREATE DATABASE EMP

USE EMP

CREATE TABLE EMP_DETAIL
(
    E_ID INT PRIMARY KEY,
    E_NAME VARCHAR(30),
    E_AGE INT,
    E_CITY VARCHAR(30),
    E_DEPARTMENT VARCHAR(20)
)

INSERT INTO EMP_DETAIL VALUES(11,'ALOK KUMAR',24,'DELHI','IT')
INSERT INTO EMP_DETAIL VALUES(12,'RAJESH TRIPATHI',22,'ALLAHABAD','SALES')
INSERT INTO EMP_DETAIL VALUES(13,'SATISH KUMAR',23,'JHANSI','PRODUCT')
INSERT INTO EMP_DETAIL VALUES(14,'MANOJ SINGH',22,'NOIDA','MARKETING')
INSERT INTO EMP_DETAIL VALUES(15,'AMIT MAHESHWARI',25,'ALLIGARH','IT')
INSERT INTO EMP_DETAIL VALUES(16,'DEEPAK DWIJ',24,'NOIDA','IT')

Step 5. Now select a TextBox and go to its Text property under DataBindings.

Step 6. Click on Text property -> Click on bindingSource1 and select the appropriate column. (Look at the following figure; I am selecting "E_ID" to show the value of this column in the TextBox.)

Step 7. Do the same for the remaining TextBoxes.

Run the application.

Output

You can move to first, previous, next, and last records as well and you can add new records and delete records.

Now we perform the same work without using a wizard. Take a Windows Forms application -> take a BindingSource, a BindingNavigator, five Labels, and five TextBoxes and set the Text and Name property like as Step 4. Your form will look like in the following figure.

Write the following code.

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace WindowsFormsApplication1
{
    public partial class Form2 : Form
    {
        public Form2()
        {
            InitializeComponent();
        }

        SqlDataAdapter da;
        DataSet ds;

        private void Form2_Load(object sender, EventArgs e)
        {
            da = new SqlDataAdapter("select * from emp_detail", "database=emp;server=.;user=sa;password=wintellect");
            ds = new DataSet();
            da.Fill(ds);
            bindingSource1.DataSource = ds.Tables[0];
            bindingNavigator1.BindingSource = this.bindingSource1;
            txtid.DataBindings.Add(new Binding("Text", bindingSource1, "E_ID", true));
            txtname.DataBindings.Add(new Binding("Text", bindingSource1, "E_NAME", true));
            txtage.DataBindings.Add(new Binding("Text", bindingSource1, "E_AGE", true));
            txtcity.DataBindings.Add(new Binding("Text", bindingSource1, "E_CITY", true));
            txtdepartment.DataBindings.Add(new Binding("Text", bindingSource1, "E_DEPARTMENT", true));
        }
    }
}

Run the application.

You can perform different operations like the above.

Related resources

• How to Work with Items Controls in Windows Phone 7
• SharePoint Designer Work flow: Part I
• Three State Work flow in Sharepoint
• Working With Active MDI Child Form Controls: Part 2