YOUR FEEDBACK
udaykiran wrote: Really Excellent Information. But i have some doubts. initially i have some aver...

SYS-CON.TV
TOP MICROSOFT .NET LINKS


DataWindow.NET How To: DataWindow Formatting
A simple but powerful way of formatting data in the presentation layer

In this article, we're going to look at how DataWindow.NET technology is a simpler but more powerful way of formatting data in the presentation layer.

We'll be taking a sample application provided by Microsoft for .NET and implementing it using DataWindow.NET technology. In this case, we're using the Visual Basic .NET Code Sample: DataGrid Formatting sample application available at www.microsoft.com/downloads/details.aspx? FamilyID=28fd458f-5571-42b4-a2fe-09b69ddf0863&displaylang=en.

The original sample was written to connect to the Microsoft Northwind sample database. So you'll need MSDE or SQL Server with that sample database installed if you want to try it out for yourself. Also like last month's article, the sample code for this article is intended as an addition to the original sample so you can compare them side-by-side. After adding the sample code files from this article to the original sample, you can switch between the DataGrid and DataWindow implementations by changing the startup form for the project (see Figure 1).

Main Form
The main form of the application consists of a DataGrid or DataWindow and four command buttons that apply "Default," "Table Style," "Column Style," and "Grid Properties" formatting to the DataGrid or DataWindow control. Table 1 shows the results of the different formatting applied to the DataGrid and DataWindow respectively.

The primary difference between the DataGrid and DataWindow implementations with regard to form variables is that the DataGrid has a DataSet defined (ProductData) and a constant (PRODUCT_TABLE_NAME). This particular VB.NET example, unlike the last two we looked at, is a typical ADO.NET sample that uses a DataAdapter and a DataSet to retrieve and store the data and then fill the DataGrid. The PRODUCT_TABLE_NAME constant is used to name the result set of interest in the DataSet because a .NET DataSet can actually hold multiple result sets.

Each of the command buttons calls two form methods (ResetDemo and BindDataGrid or BindDataWindow) and then a third form method for the non-default styles that sets up that particular style (see Table 2).

In the DataGrid implementation, the ResetDemo method clears the DataSet and then resets each of the various formatting properties that get set during the demo.

DataGrid ResetDemo

If Not IsNothing(ProductData.Tables(PRODUCT_TABLE_NAME)) Then
  ProductData.Tables(PRODUCT_TABLE_NAME).Clear()
End If

With grdProducts
   .BackgroundColor = SystemColors.InactiveCaptionText
   .CaptionText = ""
   .CaptionBackColor = SystemColors.ActiveCaption
   .TableStyles.Clear()
   .ResetAlternatingBackColor()
   .ResetBackColor()
   .ResetForeColor()
   .ResetGridLineColor()
   .ResetHeaderBackColor()
   .ResetHeaderFont()
   .ResetHeaderForeColor()
   .ResetSelectionBackColor()
   .ResetSelectionForeColor()
   .ResetText()
   .BorderStyle = DefaultGridBorderStyle
End With

The DataWindow implementation of ResetDemo is much simpler because we only need to reset the properties on the DataWindow control. The properties of the DataWindow object get reset during the BindDataWindow method when we reassign the DataWindow object to the control.

DataWindow ResetDemo

dw_products.BorderStyle = DataWindowBorderStyle.None
dw_products.TitleBar = False
dw_products.Text = ""

Both the BindDataGrid and BindDataWindow methods try to connect to the SQL Server version of the Northwind database and then try to connect to the MSDE version if the SQL Server version can't be found. The DataGrid implementation then uses an SqlDataAdapter class to retrieve the data from the database and routes it to the DataSet. Then it assigns that DataSet as the DataSource for the DataGrid control.

DataGrid BindDataGrid

Dim ProductAdapter As New SqlDataAdapter( _
  "SELECT ProductID, ProductName, UnitPrice, UnitsInStock FROM products", _
  northwindConnection)
ProductAdapter.Fill(ProductData, PRODUCT_TABLE_NAME)
grdProducts.DataSource = ProductData.Tables(PRODUCT_TABLE_NAME)

The DataWindow implementation of the BindDataWindow method does pretty much the same thing using DataWindow related classes. First the OleDB connection is bound to a DataWindow.AdoTransaction object. We then reset the DataWindow object assigned to the DataWindow control, assign the AdoTransaction object to the DataWindow control, and then retrieve the DataWindow.

DataWindow BindDataWindow

Dim SQLCA As New Sybase.DataWindow.AdoTransaction(conn, "")
SQLCA.BindConnection()

dw_products.LibraryList = "dwgridformatting.pbl"
dw_products.DataWindowObject = ""
dw_products.DataWindowObject = "d_g_products"
dw_products.SetTransaction(SQLCA)
dw_products.CreateHeaderSortArrows()
dw_products.Retrieve()

The FormatGridwithoutTableStyles, FormatGridwithTableStyles, and FormatGridwithBothTablesAndColumnStyles methods are all somewhat similar. The FormatGridwithoutTableStyles method (only an excerpt is shown below) sets the format by manipulating the properties of the DataGrid itself:

FormatGridWithoutTableStyles

With grdProducts
   .BackColor = Color.GhostWhite
   .BackgroundColor = Color.Lavender
   .BorderStyle = BorderStyle.None
   .CaptionBackColor = Color.RoyalBlue
   .CaptionFont = New Font("Tahoma", 10.0!, FontStyle.Bold)
   .CaptionForeColor = Color.Bisque
   .CaptionText = "Northwind Products"
   .Font = New Font("Tahoma", 8.0!)
   .ParentRowsBackColor = Color.Lavender
   .ParentRowsForeColor = Color.MidnightBlue
End With

The FormatGridwithTableStyles method (only an excerpt is shown below) takes the same approach for many properties, but it also defines a DataGridTableStyle object to handle some of the other properties and then assigns that to the DataGrid:

FormatGridWithBothTableAndColumnStyles

Dim grdTableStyle1 As New
  DataGridTableStyle()
With grdTableStyle1
   .AlternatingBackColor = Color.GhostWhite
   .BackColor = Color.GhostWhite
   .ForeColor = Color.MidnightBlue
   .GridLineColor = Color.RoyalBlue
   .HeaderBackColor = Color.MidnightBlue
   .HeaderFont = New Font("Tahoma", 8.0!, FontStyle.Bold)
   .HeaderForeColor = Color.Lavender
   .SelectionBackColor = Color.Teal
   .SelectionForeColor = Color.PaleGreen
   .MappingName = PRODUCT_TABLE_NAME
   .PreferredColumnWidth = 125
   .PreferredRowHeight = 15
End With
grdProducts.TableStyles.Add
   (grdTableStyle1)

About Bruce Armstrong
Bruce Armstrong is a development lead with Integrated Data Services (www.get-integrated.com). A member of TeamSybase, he has been using PowerBuilder since version 1.0.B. He was a contributing author to SYS-CON's PowerBuilder 4.0 Secrets of the Masters and the editor of SAMs' PowerBuilder 9: Advanced Client/Server Development.

MICROSOFT .NET LATEST STORIES
VMware’s ESX hypervisor has become the first third-party hypervisor accredited under Microsoft’s months-old Server Virtualization Validation Program (SVVP). The validation applies to VMware ESX 3.5 update 2 (ESX 3.5u2) and means VMware customers who run Windows Server and Microsoft...
We are seeing more being written about Cloud computing and cloud platforms today, and there is strong validation that the future of computing will include significant innovation and value in web/cloud platforms. Microsoft’s Cloud strategy is materializing, and as part of our overall ...
Nth Penguin has released WW.DataServices to the public and is available for immediate download at: www.nthpenguin.com. WW.DataServices, the first system of the WebWidgetry engine, removes all the work from accessing your data. You simply point it to a database location, push a button,...
Gizmox announced the release of a fully functional beta version of its Visual WebGui (VWG) with support for Microsoft Silverlight. For the first time, VWG enables Silverlight for enterprise applications by providing a RAD like Windows Forms development experience with drag & drop desig...
Google will come out from behind the Firefox browser that it’s been pumping money into – and profiting royally from – and take direct aim at Microsoft with a browser of its very own. The widgetry is called Google Chrome and Google Chrome, like all of Google’s non-search widgetr...
SUBSCRIBE TO THE WORLD'S MOST POWERFUL NEWSLETTERS
SUBSCRIBE TO OUR RSS FEEDS & GET YOUR SYS-CON NEWS LIVE!
Click to Add our RSS Feeds to the Service of Your Choice:
Google Reader or Homepage Add to My Yahoo! Subscribe with Bloglines Subscribe in NewsGator Online
myFeedster Add to My AOL Subscribe in Rojo Add 'Hugg' to Newsburst from CNET News.com Kinja Digest View Additional SYS-CON Feeds
Publish Your Article! Please send it to editorial(at)sys-con.com!

Advertise on this site! Contact advertising(at)sys-con.com! 201 802-3021


SYS-CON FEATURED WHITEPAPERS

ADS BY GOOGLE
BREAKING NEWS FROM THE WIRES
Neverfail, a leading global software company providing affordable continuous availability and disast...