http://www.advancescripts.com/rss/127.htmlDatabase Management RSS feedsen-usCopyright (c) AdvanceScripts All rights reserved. http://www.advancescripts.com/detailed/14645.html This bit allows you to add .sql files to a ASP.Net website or Visual studio project and use a generated class to execute the procedure. The .sql file can be edited in any SQL editor, the generated class has strong type properties to set the parameters of the statement. Both stored procedures and direct sql is supported. Nothing needs to be added to the sql file all it requires is a standard T-Sql procedure declaration http://www.advancescripts.com/detailed/14598.html 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. http://www.advancescripts.com/detailed/13583.html Record selection, filtering, templates, scrolling, grouping, exporting, key navigation, can handle millions of records, resizable columns. Works in .NET 1.1 and .NET 2.0, ASP.NET AJAX Compatible, Cross-browser: IE, Firefox, Safari, Opera. Easy to customize http://www.advancescripts.com/detailed/13576.html Generate TreeView HTML code with a single simple method. Create professional look of standard VB TreeView with single method. See examples at our site. Compatible with ASP.Net 2.0. ASP.NET AJAX Compatible, Cross-browser: IE, Firefox, Safari, Opera. Easy to customize. http://www.advancescripts.com/detailed/13436.html Aspose.Words for Reporting Services is a rendering extension for Microsoft SQL Server 2005 Reporting Services that allows exporting reports in the DOC, RTF and WordprocessingML formats. All RDL report features, including tables, matrices, charts, textboxes, lists and images are converted with the highest degree of precision to Microsoft Word documents. http://www.advancescripts.com/detailed/12510.html Aspose.AdHoc is an ASP.NET component to quickly and easily add ad hoc capabilities to ASP.NET application. It also supports; Building Queries like Drag and drop on to web form, Editable dropdown list that supports auto complete function, Parsing SQL statements, Queries output to webpage and documents like Word, Excel & PDF, Show SQL statement window, UI Control for Customer CSS Style. Simply assign a DataTable object as the data source on your web form and let the component do the rest. http://www.advancescripts.com/detailed/12505.html Aspose.Grid is a .NET component that provides you a total grid solution. It is packaged with two different .NET components to support Desktop and Web applications. Main features include: Importing/exporting to CSV & SpreadSheetML format, Find/Replace feature, Easy to apply skins, Extensive support for Grouping rows & creating subtotal features, formulae, Large array of cell types, Managing Cells, Pictures, Hyperlinks, Keyboard Navigation, Grid Events and support for both edit and view modes. http://www.advancescripts.com/detailed/11209.html SQLReports is a desktop module for the iBuySpy portal that allows you to quickly add read-only tables to your portal tabs using dynamic data in your iBuySpy database. The module allows creation of the dynamic tables without any coding of custom modules. Simply enter the SQL 'SELECT' statement to execute, and the table will be displayed. http://www.advancescripts.com/detailed/11208.html r-Access is an online database management system providing fast and convenient way to view/edit remote (web hosted) databases over the Internet. Software consists of two parts: Client and Server. Server part should be installed on your web server to access databases and supply Client with data. Client is a Windows application allowing to browse database tables and views, edit/delete/add records, execute SQL queries with ease. Supported databases: Microsoft Access, MS SQL Server, MySQL. http://www.advancescripts.com/detailed/11207.html Generates C# source code to call stored procedures in the SQL Server 2000 database. http://www.advancescripts.com/detailed/11206.html DbNetGrid.Net is a web-based grid component based on DHTML behaviours and ASP.NET. Grids can be searched, sorted, edited, copied, printed and results saved in HTML, Word, Excel or XML formats. Fully encapsulated, grids can be nested or linked together on the same page to create powerful drill-down capabilities. Automatically selects between SqlClient and OleDb ADO.NET libraries for optimal performance. Includes integrated GUI designer. Visit the web site for online demos and a free fully functional download. http://www.advancescripts.com/detailed/11205.html The .Net Word document reporting component which enables you to read and write Word documents without utilizing Microsoft Word. Open files created in Microsoft Word 97, 2000 and XP; Fill mail merge fields defined in the document with your data; Use a DataSet, DataTable, DataView, IDataReader or an array of values as a data source for the mail merge operation; Merge multiple records of a DataTable into one document to create documents such as letters, invoices or mailing labels; Grow tables or regions inside your document dynamically to accommodate for all rows in the data source; Save document in Microsoft Word or text format. http://www.advancescripts.com/detailed/11204.html WordReports .NET is a .NET reporting component that allows complete control over Word document generation. The component embeds efficient Word and RTF document creation into .NET web or desktop applications. Documents may be created without Microsoft Word, or any form of automation. Generate reports, with charts and database binding. Layout templates in Word. Comes with example source code, coding tutorials, and e-mail support. Prices from $99. Free 30-day evaluation copy. http://www.advancescripts.com/detailed/11203.html DBReporter is a database structure documentation generator for SQL Server. It generates a report of all tables, columns, indexes, views, stored procedures and triggers nicelly formated in HTML, XML or text. http://www.advancescripts.com/detailed/11202.html The product suite including all Aspose office file reading and writing components such as Aspose.Excel, Aspose.Word and Aspose.Project. http://www.advancescripts.com/detailed/11201.html Aspose.Excel is the .Net Excel spreadsheet reporting component which can create Excel spreadsheets featured in formatting, functions, pictures and charts. With it, you can create Excel spreadsheets both for desktop applications and web server applications; you can create Excel spreadsheets via designer or API or combined designer and API, which offers the most flexibility to create Excel spreadsheets both from static data and dynamic data. You can customize your Excel spreadsheets in minutes from fully-featured demos which create similar reports to those in the Microsoft Access Northwind Database Sample. http://www.advancescripts.com/detailed/11200.html The product suite including all Aspose reporting components such as Aspose.Excel, Aspose.Word, Aspose.Pdf, Aspose.Chart. http://www.advancescripts.com/detailed/11199.html ASP.NET Maker 2 is a powerful yet easy-to-use code generator for ASP.NET 2.0. It can create a full set of ASP.NET 2.0 pages quickly from your data source. Supported databases includes Microsoft Access, Microsoft SQL Server, MySQL, Oracle and other databases with ADO or ODBC connectivity. ASP.NET Maker 2 is equipped with a number of cool features. Drill-down Master/Detail view, Advanced Security, User Registration System, Custom View, Report, Export, File uploading, User Selectable Page Size, Table-specific List Page Options, Dynamic Table Loading, etc. http://www.advancescripts.com/detailed/11198.html 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. http://www.advancescripts.com/detailed/3465.html 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+. Can upload data without or by page submit. 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 events, CSS styles, expert scrolling, localization. http://www.advancescripts.com/detailed/2980.html This is an .NET based DataAccessLayer which allows users to save and update data on the database. This tool is included with several requests and it is simple to work. In this tool save data is used to save and return updated data in the dataset for later retrieval. This tool provides fully customization facility to the users they are, users can pass data to the classes like, datatable, datarows etc., and also the users can skip all remaining rows and current row and they can view errors occured in dataset etc., Get Data and Executenonquery is used for retrieving command parameter values. http://www.advancescripts.com/detailed/2224.html This is a program using which webmasters can include ad hoc reporting functionality with their ASP.NET applications. This program is very easy to use and it utilizes DataTable object as data source, so webmasters can use any database backend. This program delivers various output such as Filtered DataView, SQL statement, Filter DataTable, Where statement. http://www.advancescripts.com/detailed/1826.html This tool is helpful for the users who want to access multiple database with a code snippet instead of making duplicate source code for each databases. AllDb is a .NET framework database tool that allows database administrators to make interface for their .NET application with multiple databases. This tool supports the databases like, MS SQL 2000, Oracle DB2, MySQL, MS Access and Sybase SQL server. http://www.advancescripts.com/detailed/1572.html Active Tree is a navigation tool which is helpful for the users who want to navigate their users by providing treeview model on their data list. It allows the users to select their required topic or data by hitting checkbox and then it displays list of nodes. Features supported by this utility are, it supports flow layout and grid layout, it has automated children selection mode, databinding with recursive data sources are included etc. http://www.advancescripts.com/detailed/1571.html Active Pager is a database tool which is used to add a paging tool to a data grid component. It offers useful navigation tool which helps the users to navigate between different pages using previous, next, drop down selector, first and last page, numeric paging etc., Users are allowed to change the appearance using different styles. http://www.advancescripts.com/detailed/1247.html Bean Software Search Control is ASP.NET web custom control that creates WHERE clause of SQL Query to database. It is intended to web developers to easily add database searching options to web site without much effort and without advanced knowledge of database programming. Your web site visitors can choose between four ways of searching: any word, all words, phrase or boolean search expression with AND, OR and NOT keywords. http://www.advancescripts.com/detailed/1242.html This is a small Web Application, this contains basic database functions using ASP.NET including a database driven user authentication, adding new records, viewing records, editing and deleting records. http://www.advancescripts.com/detailed/1236.html ExportWizard is a step wizard for database exports. In a few simple steps, users can choose a SQL Server database object (table, view, or query) and export its data in any of the standard formats (XML, CSV, TXT, or HTML, or generate the SQL script with "INSERT" statements). http://www.advancescripts.com/detailed/246.html The ASP.NET Time Tracker Starter Kit application (referred to as "Time Tracker" for rest of this white paper) is a line-of-business application allowing users to track the time worked on projects. Additionally, the application enables project managers to better track the status of projects they manage by viewing user's time entries and detailed reports for those time entries. http://www.advancescripts.com/detailed/191.html DBDocumentor is a database structure documentation generator for SQL Server. It generates a report of all tables, columns, indexes, views, stored procedures and triggers nicelly formated in HTML, XML or text.