Overview

DbNetGrid is a fully encapsulated AJAX enabled grid component designed for use in Intranet/Internet development. It provides a fast and flexible way of presenting and updating database information in a browser environment. DbNetGrid can be used as a simple grid component integrated with your own applications, a web-reporting tool or as part of a fully functional web-application. No need to write any code. Grids can be generated from the DbNetGrid Designer interface.

DbNetGrid can be added easily to existing HTML/ASP or ASP.NET pages in a few seconds with as little as 3 lines of code. DbNetGrid can be implemented as either a client-side JavaScript object or a server-side .Net Web Control (.aspx pages only).

Implementing DbNetGrid as a client-side JavaScript object

<script src="/dbnetgrid/dbnetgrid.js"></script> 
...
window.onload = createGrid

//////////////////////////////////////////////////////////////////////////////////////////////
function createGrid()
//////////////////////////////////////////////////////////////////////////////////////////////
{
	var dbnetgrid1 = new DbNetGrid( "dbnetgrid1" )

	with ( dbnetgrid1 )
	{
		connectionString = "sqlserver"
		fromPart = "customers"
		loadData()
	}
}
...

...

Implementing DbNetGrid as a server-control

<%@ Register TagPrefix="DNL"  Namespace="DbNetLink.Web.UI" Assembly="DbNetLink.DbNetGrid" %>
...
<form id="Form1" name="Form1" method="post" runat="server">
	<DNL:DbNetGrid 
		id="customers" 
		runat="server" 
		ConnectionString = "samples"
		FromPart = "customers"
		>
	</DNL:DbNetGrid>
</form>

DbNetGrid has a massive array of capabilities that you can activate with a few lines of code saving hundreds of man-hours of development time. These capabilities include:

• Update, insert and delete records (including custom validation).
• Point and click re-ordering.
• Search dialog (with the ability to use the full range of SQL relational operators)
• Ability to export results in HTML, Word, Excel or XML formats.
• Create charts using MS Excel
• Link to MS Word and perform automated mail-merges