Microsoft Cloud Authors: Elizabeth White, Yeshim Deniz, Serafima Al, Janakiram MSV, John Katrick

Related Topics: Microsoft Cloud, PowerBuilder

Microsoft Cloud: Article

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
End If

With grdProducts
   .BackgroundColor = SystemColors.InactiveCaptionText
   .CaptionText = ""
   .CaptionBackColor = SystemColors.ActiveCaption
   .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", _
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, "")

dw_products.LibraryList = "dwgridformatting.pbl"
dw_products.DataWindowObject = ""
dw_products.DataWindowObject = "d_g_products"

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:


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:


Dim grdTableStyle1 As New
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

More Stories By Bruce Armstrong

Bruce Armstrong is a development lead with Integrated Data Services (www.get-integrated.com). A charter 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.

Comments (11) View Comments

Share your thoughts on this story.

Add your comment
You must be signed in to add a comment. Sign-in | Register

In accordance with our Comment Policy, we encourage comments that are on topic, relevant and to-the-point. We will remove comments that include profanity, personal attacks, racial slurs, threats of violence, or other inappropriate material that violates our Terms and Conditions, and will block users who make repeated violations. We ask all readers to expect diversity of opinion and to treat one another with dignity and respect.

Most Recent Comments
monkfish 11/27/08 08:48:36 AM EST

thanks for the information. betsson iddaa

SohbetGor 11/17/08 09:42:36 AM EST

thanks you...


Qarisma 11/05/08 05:54:22 PM EST

But real Güzeş Site head turn before such excellent Sitelent see

evden eve nakliyat Sohbet

alvin 07/23/08 08:39:54 PM EDT

how can i change the highlight color of selected row? the default is blue which looks heavy.

Bruce Armstrong 12/10/07 12:27:42 PM EST

I'd suggest posting your question in Sybase's DataWindow.Net forum.


It would be much easier to address there.

Praveen 12/10/07 02:02:28 AM EST

Sir ,

We are using Datawindow.net 2.0[Trail] in VS2005 with ASP.Net 2.0 & C#.Net . Using WebDatawindow.net in ASP.Net data retrieving and also
data interting are so smoth . We using connection ADO.net & ASP.Net security trust level default security level ( full trust level )

For security problem most of developer suggests that 'medium trust'and also our webserver support only medium trust.So we are changing Security policy to 'medium'.
( In %windir%\Microsoft.NET\Framework\v2.0.50727\CONFIG\Web.Config
to change

***********Then I am facing a crucial problem ************
Required permissions cannot be acquired.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Security.Policy.PolicyException: Required permissions cannot be acquired.

How can overcome to in this problem . If you have any solution ... pls forward me ...

Bruce Armstrong 11/14/07 07:09:07 AM EST

I'd suggest posting your question in Sybase's DataWindow.Net forum:


It would be much easier to address there.

Atif Riaz 11/14/07 01:51:39 AM EST

Hey this is atif i have read your articles they were really help full. what i am trying is that i am using data window 2.0 in Dotnet now i want any CSS file like we do it for html or asp pages i want to define CSS file from where i can formate the report made in Data Window automatically. I need your help?

Bruce Armstrong 02/07/06 03:58:48 PM EST

If you can't find it here, check the Sybase CodeXchange site. I loaded it there as well:


Mike 02/07/06 02:58:03 PM EST

Where is an arcticle code?

SYS-CON Australia News Desk 02/03/06 01:45:59 PM EST

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.

@ThingsExpo Stories
Enterprises have taken advantage of IoT to achieve important revenue and cost advantages. What is less apparent is how incumbent enterprises operating at scale have, following success with IoT, built analytic, operations management and software development capabilities - ranging from autonomous vehicles to manageable robotics installations. They have embraced these capabilities as if they were Silicon Valley startups.
DXWorldEXPO LLC announced today that ICOHOLDER named "Media Sponsor" of Miami Blockchain Event by FinTechEXPO. ICOHOLDER give you detailed information and help the community to invest in the trusty projects. Miami Blockchain Event by FinTechEXPO has opened its Call for Papers. The two-day event will present 20 top Blockchain experts. All speaking inquiries which covers the following information can be submitted by email to [email protected] Miami Blockchain Event by FinTechEXPO also offers s...
Poor data quality and analytics drive down business value. In fact, Gartner estimated that the average financial impact of poor data quality on organizations is $9.7 million per year. But bad data is much more than a cost center. By eroding trust in information, analytics and the business decisions based on these, it is a serious impediment to digital transformation.
Predicting the future has never been more challenging - not because of the lack of data but because of the flood of ungoverned and risk laden information. Microsoft states that 2.5 exabytes of data are created every day. Expectations and reliance on data are being pushed to the limits, as demands around hybrid options continue to grow.
The standardization of container runtimes and images has sparked the creation of an almost overwhelming number of new open source projects that build on and otherwise work with these specifications. Of course, there's Kubernetes, which orchestrates and manages collections of containers. It was one of the first and best-known examples of projects that make containers truly useful for production use. However, more recently, the container ecosystem has truly exploded. A service mesh like Istio addr...
As IoT continues to increase momentum, so does the associated risk. Secure Device Lifecycle Management (DLM) is ranked as one of the most important technology areas of IoT. Driving this trend is the realization that secure support for IoT devices provides companies the ability to deliver high-quality, reliable, secure offerings faster, create new revenue streams, and reduce support costs, all while building a competitive advantage in their markets. In this session, we will use customer use cases...
Digital Transformation: Preparing Cloud & IoT Security for the Age of Artificial Intelligence. As automation and artificial intelligence (AI) power solution development and delivery, many businesses need to build backend cloud capabilities. Well-poised organizations, marketing smart devices with AI and BlockChain capabilities prepare to refine compliance and regulatory capabilities in 2018. Volumes of health, financial, technical and privacy data, along with tightening compliance requirements by...
Business professionals no longer wonder if they'll migrate to the cloud; it's now a matter of when. The cloud environment has proved to be a major force in transitioning to an agile business model that enables quick decisions and fast implementation that solidify customer relationships. And when the cloud is combined with the power of cognitive computing, it drives innovation and transformation that achieves astounding competitive advantage.
DevOpsSummit New York 2018, colocated with CloudEXPO | DXWorldEXPO New York 2018 will be held November 11-13, 2018, in New York City. Digital Transformation (DX) is a major focus with the introduction of DXWorldEXPO within the program. Successful transformation requires a laser focus on being data-driven and on using all the tools available that enable transformation if they plan to survive over the long term. A total of 88% of Fortune 500 companies from a generation ago are now out of bus...
Cloud Expo | DXWorld Expo have announced the conference tracks for Cloud Expo 2018. Cloud Expo will be held June 5-7, 2018, at the Javits Center in New York City, and November 6-8, 2018, at the Santa Clara Convention Center, Santa Clara, CA. Digital Transformation (DX) is a major focus with the introduction of DX Expo within the program. Successful transformation requires a laser focus on being data-driven and on using all the tools available that enable transformation if they plan to survive ov...
DXWordEXPO New York 2018, colocated with CloudEXPO New York 2018 will be held November 11-13, 2018, in New York City and will bring together Cloud Computing, FinTech and Blockchain, Digital Transformation, Big Data, Internet of Things, DevOps, AI, Machine Learning and WebRTC to one location.
DXWorldEXPO | CloudEXPO are the world's most influential, independent events where Cloud Computing was coined and where technology buyers and vendors meet to experience and discuss the big picture of Digital Transformation and all of the strategies, tactics, and tools they need to realize their goals. Sponsors of DXWorldEXPO | CloudEXPO benefit from unmatched branding, profile building and lead generation opportunities.
Dion Hinchcliffe is an internationally recognized digital expert, bestselling book author, frequent keynote speaker, analyst, futurist, and transformation expert based in Washington, DC. He is currently Chief Strategy Officer at the industry-leading digital strategy and online community solutions firm, 7Summits.
Digital Transformation and Disruption, Amazon Style - What You Can Learn. Chris Kocher is a co-founder of Grey Heron, a management and strategic marketing consulting firm. He has 25+ years in both strategic and hands-on operating experience helping executives and investors build revenues and shareholder value. He has consulted with over 130 companies on innovating with new business models, product strategies and monetization. Chris has held management positions at HP and Symantec in addition to ...
Cloud-enabled transformation has evolved from cost saving measure to business innovation strategy -- one that combines the cloud with cognitive capabilities to drive market disruption. Learn how you can achieve the insight and agility you need to gain a competitive advantage. Industry-acclaimed CTO and cloud expert, Shankar Kalyana presents. Only the most exceptional IBMers are appointed with the rare distinction of IBM Fellow, the highest technical honor in the company. Shankar has also receive...
With 10 simultaneous tracks, keynotes, general sessions and targeted breakout classes, @CloudEXPO and DXWorldEXPO are two of the most important technology events of the year. Since its launch over eight years ago, @CloudEXPO and DXWorldEXPO have presented a rock star faculty as well as showcased hundreds of sponsors and exhibitors! In this blog post, we provide 7 tips on how, as part of our world-class faculty, you can deliver one of the most popular sessions at our events. But before reading...
The best way to leverage your Cloud Expo presence as a sponsor and exhibitor is to plan your news announcements around our events. The press covering Cloud Expo and @ThingsExpo will have access to these releases and will amplify your news announcements. More than two dozen Cloud companies either set deals at our shows or have announced their mergers and acquisitions at Cloud Expo. Product announcements during our show provide your company with the most reach through our targeted audiences.
The IoT Will Grow: In what might be the most obvious prediction of the decade, the IoT will continue to expand next year, with more and more devices coming online every single day. What isn’t so obvious about this prediction: where that growth will occur. The retail, healthcare, and industrial/supply chain industries will likely see the greatest growth. Forrester Research has predicted the IoT will become “the backbone” of customer value as it continues to grow. It is no surprise that retail is ...
Andrew Keys is Co-Founder of ConsenSys Enterprise. He comes to ConsenSys Enterprise with capital markets, technology and entrepreneurial experience. Previously, he worked for UBS investment bank in equities analysis. Later, he was responsible for the creation and distribution of life settlement products to hedge funds and investment banks. After, he co-founded a revenue cycle management company where he learned about Bitcoin and eventually Ethereal. Andrew's role at ConsenSys Enterprise is a mul...
DXWorldEXPO LLC announced today that "Miami Blockchain Event by FinTechEXPO" has announced that its Call for Papers is now open. The two-day event will present 20 top Blockchain experts. All speaking inquiries which covers the following information can be submitted by email to [email protected] Financial enterprises in New York City, London, Singapore, and other world financial capitals are embracing a new generation of smart, automated FinTech that eliminates many cumbersome, slow, and expe...