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. ...
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...
In this Article we learn Basic LINQ Queries in Asp.Net . 1- Fill Gridview record: public void showgridview() { DataClassesDataContext dc = new DataClassesDataContext (); var q = from a in dc.GetTable< bio >() select a; GridView1.DataSource = q; GridView1.DataBind(); } 2- Search record: public void SearchQuery() { DataClassesDataContext dc = new DataClassesDataContext (); ...
Comments
Post a Comment