Skip to main content

Working With a Binding Navigator Control in Windows Forms

Definition:
BindingNavigator control Provide user interface with a simple data navigation and manipulation on the form . it is used for Binding the Database Tables values to the control (Datagridview,Text Box, label etc.). BindingNavigator with the BindingSource enable users to move through data records on a form and interact with the records.
There are few buttons in binding Navigator listed below:
1.      Move First---------------àGo first record of the table
2.      Move Next---------------àGo Next record of the table with respect to current record.
3.      Move Previous----------àGo previous record of the table.
4.      Move Last----------------àGo Last record of the table.
5.      Delete----------------------àDelete selected row (record).
6.      Add New--------------------àAdd New Row.
7.      Tool Strip-------------------àYou can add button, Label, Image and Textbox etc.
8.      Position Item---------------àcurrent row count.
9.      Count Item------------------àTotal Number of rows in database table.

Here we Bind Binding Navigator with Datagridview and TextBoxes.You can view the record in textboxes and datagridview with the help of binding navigator.First we create database and table and bind control with binding navigator.
Step: 1
 Open your visual studio-->File-->New-->Project-->Windows Forms Application, Drag and Drop Datagridview, Label, Text Box and Binding Navigator control on the Form from tool Box as shown below:

                                 

 Step: 2

·         Now open Microsoft Sql Server Studio
·         Create a table bio and insert into some values.




 



Step: 3

 Expand DataBindings on the top of the  Binding Navigator Properties Window:











Step: 4
 Click Add Project Data Source which is shown above image.




 







Step : 5 
Now select Database and click Next Button.

                           


 Step: 6
 Select Dataset and click Next button.


 





Step: 7

 Click on Next Button. Select Table bio and click on Finish button.



                         




Step: 8 

Open your windows Form, Go properties of id Text Box and Expand DataBindings --> Text --> double click on column id Now
Doing same way for Name,Passw and fname also.


                                      






Step: 9

 Select BindingNavigator control and goes to its properties window.
Select bindingSource1.











Step: 10
 Run the Application press F5 ---àOutput






For Datagrid View:
First Bind the Binding Navigator follow the step 9.
Step1:
·         Select Datagridview . Now click on smart button on the Right top of the Datagridview.
·         Select Datasource --àbindingSource1.  Press F5 and View output.









Output: 



Labels:

Comments

Post a Comment

Popular posts from this blog

Login Form Using LINQ in Windows Forms Application

Step 1:  First we create a database and then Table in SQL Server. Here we create a table named “logintb”. Now insert a name and Password into the logintb table. Step 2:  Open Visual Studio then select "File" -> "New" -> "Project..." then select "Windows Forms". Drag and drop a Label for ID and a Label for password. Drag and drop a TextBox for txtuser and a TextBox for txtPassword. Drag and drop a Button for Login. Step 3:  Go to the project then right-click and seelct "Add" -> "New Item..." then select "Windows Form" -> "LINQ to SQL Classes" then click on "Add". Now go to the Server Explorer, drag and drop the logintb table as in the following: Open Server Explorer and select the database and then the table. Step 4 :  Now double-click on the button Login in the form and write the following code: CS Code:   using  System; using  System.Collections.Generic; using  System.Comp
Post a Comment
Read more

How to Pass Data from one Form to other Form in windows Form Application C#

Introduction: Hi Guys! In this tutorial we learn how to pass data from one form to other form in windows form application using c#. Let’s Follow the Step and create windows form application. Step1: Visual studio- à File- à New- à Project à windows Form Application- à Ok Step2: Click on ToolBox- à Drag and drop Label and TextBox. I creat a Form with 3 Labels and TextBox as shown in fig. Step 3: I have Name,Fname,Address Label on Form .so I take a three global variable .Write this code on the Form1.cs         public static string SetValueForText1 = "" ;         public static string SetValueForText2 = "" ;         public static string SetValueForText3 = "" ; Step4: Project- à Add Windows Form- à Click on Add Step 5: After Creating Form Double Click on Submit button on windows Form1 and Write the Code:   private void button1_Click( object sender, EventArgs e)      
1 comment
Read more