Database Tools

The following example demonstrates a ControlParameter used to obtain a parameter value from a DropDownList control on the page.

The DataList control displays data items in a repeating list, and optionally supports selecting and editing the items. The content and layout of list items in DataList is defined using templates. At a minimum, every DataList must define an ItemTemplate; however, several optional templates can be used to customize the appearance of the list. The following table describes those templates.

The Repeater control displays data items in a repeating list. Similar to DataList, the content and layout of list items in Repeater is defined using templates. At a minimum, every Repeater must define an ItemTemplate; however, the following optional templates may be used to customize the appearance of the list.

AjaxGrid is a web-based ajax enabled reporting and application development tool that enables high functional web applications to be created in minutes without the need for complex development tools. AjaxGrid is highly scalable and can cope with 100,000's of rows and hundreds of users. With AjaxGrid you can search, sort, edit, upload, print, copy, export, nest, link and much more with just a few lines of code. AjaxGrid includes it�s own GUI Designer application that allows applications to be generated and deployed against any table, view or stored procedure in your database with the need to write any code.

The PagerDataSource performs two main tasks: * Retrieve data from a data source and expose it to another control, performing paging if needed. Provide a customized user interface to allow navigation to the different pages of data. * To retrieve data from the data source, the PagerDataSource can use any of the two options that the ASP.NET framework gives us: * Using the DataSource property: the only option available in ASP.NET 1.x. * Using the DataSourceID property: using the new ASP.NET 2.0 DataSourceControls. The PagerDataSource control has two working modes: * Extracting the data for the current page from the data source. * Requesting the data for the current page only. The pager is fully configurable with templates, has full design time support and can be used to improve search engine positioning, generating search engine friendly page links. It can be render as a CSS list or as an HTML table. Be sure to check out the live demo!

Sorting The DotNetGrid supports bidirectional data sorting Summaries The DotNetGrid can calculate summaries and display them within the grid, grid summaries displayed at the base of the entire grid. Regardless of which summary option you prefer, the following features are available to you: -total page -total rows Exporting Export the data to numerous formats such as XML, Excel etc with current UI layout such as visible columns, columns order, group columns etc. Extensive Styles Support Customize every single element of the grid through CSS, designer mode or programmatically. The carefully prepared layout can be saved or restored also using XML-based format file. Customizable Page Size. Miscellaneous Features DotNetGrid is optimized for Microsoft� Visual Studio� .NET Multiple row selection - available when the grid's BehaviorOptions.EnableMul tiSelection option is active.

BuilderEditor is a powerful and easy to use ASP.NET RAD component for maintaining a datasource (e.g. SQL database, dataset). It allows you to add, edit, delete and display data from a data source. It generates the data entry forms used to insert and edit data based on the data source schema. In the same way it generates the data forms used to display data. The data entry forms may include both input and validation controls. To insert, update or delete data you need to interact with data events. The events include all information (e.g. data keys, input control values) that you need to execute a data operation. The BuilderEditor component allows you to specify the controls to be used to generate the data forms. You can use standard web controls or third-party controls. Save time using the BuilderEditor ASP.NET component!

This is a MS Access database with a list of words and synonyms to use in your applications.

SqlWhereBuilder is a web control which provides a user interface for generating custom SQL WHERE clauses. The SqlWhereBuilder web control provides a friendly interface for a user to enter query conditions, which may be compiled upon postback into a SQL WHERE clause. As an ASP.NET server control wrapping a JavaScript library, user-interaction happens entirely client-side, while on the server, additional functionality such as XML-based configuration and integration with IDbCommand objects is implemented.

DHTML JavaScript component with ASP.NET wrapper WebControl and DataGrid objects to display, edit and upload data in table, grid, tree view or grid with tree on HTML page. Compatible with IE 5.0+, Mozilla 1.0+, Firefox 1.0+, Opera 7.60+. Manages by own a data transfer from and to database and from and to client browser. Supports XML (SOAP) web services. Can upload data without or by page submit. EJS TreeGrid is client component and runs on client browser. It does not require any installation or other components on client or server side. It does not need any JavaScript code to use TreeGrid on a page. It has very small code (about 70 kB). You don't need to write any JavaScript support code. Specs: Tree functions, rows dragging by mouse, rows adding, deleting, rows filtering and sorting, calculated cells like in MS Excel, column resizing and moving. User script extensions by events, CSS styles, expert scrolling, localization to other languages, user controls and many more.

Highlighter is .NET component that changes format of wanted words and phrases, to make them more notable in text on web page (e.g. for search results). You can change anything you can imagine, including font size, color, bold, italic, underline, background color etc., or simply use css styling. Features & Benefits: Developers: Add highlighting features to your ASP or ASP.NET application in no time with this easy to use component. Just add your terms and choose the look that best suite to your existing design. You can format all words to the same format or specify different formats if you need it. Your business: Improve your web site and make it more intuitive for your customers. If your web page has a lot of text, it could be confusing for your vistiors to find what they want. That can be crucial in making decision of purchasing, enroll or next visit to your site.

Main features: - Requires no OLAP-servers to work. It's possible to install the Library on any web site with ASP.NET support. - An ability to create any multidimensional cube at the time when application is running. Cubes may be created dynamically on the base of any queries from different tables. - Comfortable interacting. Users may perform all operations interactively, no need to use intricate expressions of MDX-language. - Supports user groups, sorting, filtering by dimension members. Can filter by any combination of dimension members in any dimension. - Supports hierarchical dimensions. - Can use DataSet objects or any other classes supporting IDbCommand interface (for example SqlCommand, OleDbCommand, or OracleCommand). - Can save "the history of analysis" (or history of views) with the ability to switch between the saved stages of analysis. - Allows to export data to the following formats: XLS, PDF, XML, TXT, RTF, CSV, BMP, WMF.

DataStreams is a library of components designed to allow you to read, write, and bulk insert several common file formats including csv, xls, xml, and fixed width. Components work with SqlBulkCopy class to allow for DTS like speed during bulk inserts. Readers allow for record by record looping and data manipulation.

Fully intergratable online web mortgage application form that submits form applications into the SQL database. Every time someone fills the form out you will be notified via email, also fully customizable ASP script with standard HTML form that can easily be placed on a network of websites that dumps into the same database, also every HTML form you put out there has a forward on it so that when the user clicks submit, the database returns a thank you page on originating site.

ssData has useful methods that allow you to clean data before inserting; converting a .NET DateTime object to a SQL Server universal date time format; Boolean to SQL Server Bit conversion; dealing with DataSets, SqlDataReader; and others that will help speed up your development time. Free developer version. Features Sample project and documentation included Can be used with Window Forms, Windows Console, and ASP.NET projects Speeds up development time Consistent code for your projects Shipped with ssCMS Architected specifically for .NET Royalty-free implementation, unlimited projects.

MaxVirtual.Data is a compact yet powerful class library enabling database independent .net development. The information of data sources used in the application is stored in the XML configuration file. This extends the library to use all the possible .net providers. The use of the library is exactly similar to the encapsulated ADO.net providers. In fact, the IBuySpy Portal / Community / Reporting applications were ported to MaxVirtual.Data mostly by search/replace. Includes documentation and sample console apps. in VB.net, C#, JScript, J# & C++.net.

SoftArtisans OfficeWriter delivers real Excel spreadsheets and Word documents over the Web without the need for Microsoft Office. Other Web reporting solutions may claim to support Microsoft Office formats, but OfficeWriter is the only product on the market that fully maintains all of Excel's and Word's formatting/styles and advanced features such as VBA, macros, pivot tables and charts. Powerful as a stand-alone Web-based solution � it generates over 100,000 reports per hour - it�s also a perfect complement to your current business intelligence tool, delivering reports in the familiar formats your users want.

The product suite including all Aspose reporting components such as Aspose.Excel, Aspose.Word, Aspose.Pdf, Aspose.Chart.

The product suite including all Aspose office file reading and writing components such as Aspose.Excel, Aspose.Word and Aspose.Project.

A 3D client paging Datagrid with draggable pages, including an asp.net HiddenPanel control