Infragistics Webdatagrid Row Edit Template: Software Free Download

. 9.2k.The WebDataGrid is a flexible and feature-rich ASP.NET control available by Infragistics. The WebDataGrid is a part of Ultimate UI for ASP.NET, a library of ASP.NET controls. The control uses ASP.NET to eliminate the post back process. One of the core features of the control is, its built-in out-of-box functionality that simply requires few simple settings to provide a fully-functional, rich data-drive Web application. The code is also fully optimized and incorporates lightweight markups for performance reasons.

IntroductionThe WebDataGrid is a flexible and feature-rich ASP.NET control available. The WebDataGrid is a part of, a library of ASP.NET controls. The control uses ASP.NET to eliminate the post back process. One of the core features of the control is its built-in out-of-box functionality that simply requires a few simple settings to provide a fully-functional, rich data-driven Web application.

The code is also fully optimized and incorporates lightweight markups for performance reasons.In this article, we will learn the following. Introduction to data binding in a WebDataGrid. Implemention of paging, filter, and sorting functionality.

Auto CRUD database operations. Export records to Excel. Implement virtual scrolling. Multiple column fixingIntroduction to WebDataGridInfragistics’s product, provides rich, fast, modern controls for ASP.NET Web development. The Ultimate UI for ASP.NET consists of dozens of popular ASP.NET controls.

Some of the popular controls provide functionality related to charting, data grid, Excel and Word conversion, calendar, date picker, HTML editor, rating, tree, gauge, dialogs, and several other controls.Once downloaded and installed, the controls are accessible via Visual Studio Toolbox, like any other ASP.NET control. WebDataGrid is one of these controls that provides data grid functionality. Some of the built-in functionality of WebDataGrid control are data binding, CRUD operations, filter, sort, and search.Data Binding to WebDataGridViewLet’s create a simple ASP.NET Web application and use a WebDataGrid control for data display and data manipulation. Open Visual Studio and create a new project.Click on File - New - Website.Select ASP.NET Empty Web Site and give a meaningful name and click OK. See Figure 1. Figure 6.

Click the arrow on the right corner of WebExplorerBar. It opens a window where click on “Edit Group and Items” opens a new popup, which is blank. Click “add root” then select root and click on “add child”. By using this, you can add as many as items to the static navigation header. You can also add root and child items dynamically in your code.You can change the Group and child name by changing the text property of each and after adding required root and their child click OK. There are several other properties of root and child which can be set to make the UI look more interactive such as image, tool tip, CSS etc.

Once done, select Apply. See Figure 7. Figure 8This action will help us create a data source. In our case, we will select a SQL Server database as our data source. Clicking on “New Connection” will open a dialog box. First enter the MS-SQL Server name (“.” can be used for localhost) if your database is on your local machine.

You will also have to provide your SQL Server user id and password. Once selected and authenticated, you will see a list of databases available on the server will be loaded in the Connect to a database drop down. See Figure 9.

After adding Iframe, go to design view and click on the arrow and select “Edit Group and Item” then select the child node on which you want to load data (“Permanent” in this case). We need to set two properties to bind the data, Navigate Url and Target.

In navigate url select the Employee WebForm and in Target give the iframe name.Now you are all set to load data. Click on F5 to run the app and you’ll see the Navigation pane and after clicking on Permanent, your data will load in iframe. See Figure 16. Figure 17Paging, Filtering and Sorting in Infragistics WebDataGridPaging, filtering, and sorting are some common operations for a data-drive applications. We just finished loading data from a SQL Server into a WebDataGrid.

Now let’s see how we can implement paging, filtering, and sorting functionality in the WebDataGrid records. The good news is, the WebDataGrid control comes with built-in paging, filtering, and sorting functionality. All we need to do is set a few properties and we’ll be all set.Step 1Open Employee WebForm by double clicking on it in the Solution Explorer.

Now, click on the upper right corner WebDataGrid tasks arrow and then select Edit Behaviors. See Figure 18. Figure 27So, we just saw how easy it is to implement insert, update, and delete records using a WebDataGrid control.Export Grid View Data to ExcelWe often require data from a DataGrid control to be export to an Excel sheet. The WebDataGrid data can be exported to an Excel sheet by writing a few lines of code.Open Employee Webform and add the following controls to the Form by dragging them from the Toolbox. Select and drag the WebExcelExporter from toolbox. Give it a meaningful name. Show some text before downloading where the user can give a download file name.

User clicks this button to generate the Excel file.Step 1You can setup these controls to your Form below the WebDataGrid control or wherever you like. My final code looks like Figure 28. Figure 31Virtual ScrollingA WebDataGrid control bound to a database with millions of records may affect performance of a web page. Virtual scrolling feature of the WebDataGrid control helps load partial data to keep a web page's load time lower and data loading time faster.To enable Virtual Scrolling, open Web Form and go to Edit Behaviors and select Virtual Scrolling. Change the Row Cache Factor according to your need (2 in this sample).

Infragistics Webdatagrid Row Edit Template: Software Free Download Windows 10

The Row Cache Factor is a multiplier used to determine the total number of fetched rows per request. Let’s Uncheck Paging for now to test Virtual Scrolling. See Figure 31.