.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Bug Tracker: Build a Configurable Web-Based Bug Management Tool Using ADO.NET, XML, and XSLT

Posted By:      Posted Date: August 21, 2010    Points: 0   Category :ASP.Net

One of the most significant features of ADO.NET is its integration with XML. Developers can either use an ADO-like API to access the data or work directly with an XML representation of the data. This article demonstrates how both of these techniques can be used together to create Web applications that take advantage of XML standards such as XSLT. The example presented here is a bug tracking application built using C# and the.NET Framework. The development of the application covers several topics including data access using ADO.NET, the presentation of data using XSLT stylesheets, and the integration of ADO.NET with the .NET XML Framework.

Roy Margolis

MSDN Magazine July 2002

View Complete Post

More Related Resource Links

Debugging Tool: Build a Logging and Event Viewing Library to Help Debug Your .NET Framework-based Ap


Building a basic, reusable application framework can make development quicker and easier. This allows you to focus more on the problems at hand and less on the repetitive tasks involved in building any application. In this article, the author presents a framework that provides facilities to access the registry and an extensible framework for logging messages to a console window or the Event Viewer. This reusable framework can be included as a library in your projects, allowing you to display an enhanced, color-coded message log and dynamically change logging levels.

Daryn Kiely

MSDN Magazine May 2003

"Oslo" Basics: Build Metadata-Based Applications With The "Oslo" Platform


We introduce you to "Oslo" and demonstrate how MSchema and MGraph enable you to build metadata-driven apps. We'll define types and values in "M" and deploy them to the repository.

Chris Sells

MSDN Magazine February 2009

VSTO: Build Office-Based Solutions Using WPF, WCF, And LINQ


With Visual Studio Tools for Office you can easily build Office-based services that harness the power of Windows Communication Foundation, Windows Presentation Foundation, and LINQ.

Andrew Whitechapel

MSDN Magazine December 2007

Vector Graphics: Build Flexible, Lightweight XML-Based Images for ASP.NET Using Scalable Vector Grap


Scalable Vector Graphics (SVG), a W3C graphics standard built around XML, is one of several vector graphics technologies that allows fast, lightweight drawings such as charts and graphs to be rendered on the fly in an appropriate viewer. There are many advantages to such vector graphics, including conservation of bandwidth and storage media, and flexibility. This article explains these benefits and shows you how to easily add powerful, dynamic, interactive visual elements to your Web applications.

Dennis Forbes

MSDN Magazine July 2003

Scripting Windows: Windows Management Instrumentation Provides a Powerful Tool for Managing Windows


The new Windows Management Instrumentation (WMI) technology for Windows 2000, Windows NT 4.0, and Windows 98 provides powerful scripting technology that can be used to administrate Windows-based systems. With WMI, you can create scripts to simplify management of devices, user accounts, services, networking, and other aspects of your system. This piece will introduce you to WMI and the WMI Scripting Object Model, taking a look at the available objects, methods, and properties. Along the way, you'll see how these elements can be used to create system management scripts.

Alan Boshier

MSDN Magazine April 2000

Easiest way to build XML based Menu with Submenu

Hello guys, I need to develop an easy and quickly to build menu structure based on xml. The menu needs to have a "Main" menu at top of the screen and a submenu at the left of the screen. Excactly like this: http://www.enexis.nl/site/over_enexis/ Can someone explain to me where i need to get started and wich control i should use?   Thanks alot! cheers,   Rob 

using policy based management to exclude database access

After reading information on the link http://www.mssqltips.com/tip.asp?tip=1492 I was wondering whether its possible to have a policy in place such that database A cannot make reference to objects in database_B, I am guessing that one would have a policy such that the contents of the objects must not be like %database_B.%   Let me know whether there is a better way to do this. Thanks.

Policy based management : what rights do ##MS_PolicyTsqlExecutionLogin## need

Hi, In order to run Policies on scheduled basis, what permissions should I grant to ##MS_PolicyTsqlExecutionLogin## login? Problem is: When I evaluate the policies myself, they dont fail, but when I schedule them, they fail reporting ##MS_PolicyTsqlExecutionLogin## login doesn't have access to <> database. Any help please?

Policy-Based Management and On Change - Prevent




I’m working on Policy-Based management feature and I’m keen to implement some of the features. I tried to setup a Policy for a “backup device” facet based on the condition that the name starts with bkd_. I tried to set the evaluation mode to “On Change – Prevent” but unfortunately I could not find the mode at all in the Policy Screen. I also made sure the “Nested Triggers” advanced Option is set to 1.


I went through this  link http://blogs.msdn.com/b/sqlpbm/archive/2009/04/13/policy-evaluation-modes.aspx and checked for the execution_mode in  msdb..sysp

Cannot add XSLT based view in a web part


i am newbie and i do understand reviewing the forums which i have done but there are not too many helpful replies

customize the view to display the latest comments entered for a task when the comments filed is enabled for multiple text entries and avoid "view entries" in the field


Win 7 Enterprise x64
SPD 2007

Sharepoint server 2007 with no admin priviledges to the server (cannot get any logs or anything)

Another test client
Win 2003 Enterprise Server x64

Steps taken to reach the desire view:

  • Created a standard view with the required columns, filtering and sort criteria. (view called summary_view with filename summary_view.apsx)
  • Added the view as part of a web part in a multi-web part page (called Status report with file name status_report.aspx)
  • Now open site in SPD, copy summary_view.aspx and renamed it to finalsummary_view.aspx
  • Right click on the view page and select convert to XSLT Data view
  • Make my minor layout customizations
  • save the page and previewed in browser from SPD and by visiting the actual page from a different machine and browser. results are as desired.
  • now edit the status report page, click on modify shared web part
  • now when selected the finalsummary_vi

Management Studio extract to flat file tool outputs dates with 9 digits after the point (unparseable



I hope this is the right forum for this. I tried exporting data from a table using this procedure:

  • SQL Server Management Studio -> Right-click on database -> Tasks -> Export Data...
  • Source: SQL Server, Destination: Flat File destination (delimited).

The data was correctly exported, but when I try to parse the file using FileHelpers, DateTime.ParseExact() fails for any date with non-integer seconds: I discovered the decimal part of the number of seconds has 9 digits, while DateTime.ParseExact() accepts only up to 7 digits, even with a custom format.

//The output date has the following format, and I can't:
// either find a format that accepts it,
// or prevent SQL server from outputting all those digits.
 "2010-10-12 16:21:10.960000000",
 "yyyy-MM-dd HH:mm:ss.FFFFFFFFF", //This doesn't work
//A FormatException is thrown.

SQL Server 2008 R2 Enhancements to Policy-Based Management


I'm reasearching enhancements which have been made to Policy-Based Management in SQL Server 2008 R2.  I"ve found several articles and posts on PBM in general, but nothing that explicitly describes what enhancements have been implemented in SQL 2008 R2 which are not available in SQL 2008.  Does anyone know of any white papers or articles which discuss this?

not able to connect to sql server using management tool but can login using mylittleadmin



I am unable to connect using sql server management tool installed in the computer but can login using little web admin.

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)

Could any one explain what is going wrong.

Thanks in advance

Policy based management missing evaluation modes


For some reason, I only get the on demand and on schedule evaluation modes with my instance of SQL server, what is even more suprising is the fact that i am following a step by step guide and the guide seems to have the on change log only evaluation mode.

Is this a bug or something ?

I am using SQL 2008 SP1 developer edition, I get the same issue even on my standard edition.

SQL Server Express 2005 Configuration Management tool



        I have installed both the Client as well as SQL Server Studio Management Express using the following setups SQLServer2005_SSMSEE.msi & SQLEXPR32.EXE.

                                                                                              But SQL Server Express 2005 Configuration Management tool is not installed in the system. What should I do.

Thank you

Suggestion for web based Ad hoc OLAP reporting tool

Hi Guys,

I want a suggestion from you people regarding the best tool for OLAP reporting.

What I want to do is

Allow administrator to create OLAP based web report, which he/she can publish to users of his/her choice.
Similarly can create dashboards using the OLAP.

This needs to be done in web based application.

Can anybody suggest any 3rd party tool for this??

Thanks in advance

SQL Server 2008 management tool and MSXML6 sp2 question



I would like to install the management tool on my WinXP SP3 machine.
When almost went through all processes, some error happened.  And I checked it's because of the MSXML6 SP2.  I need to uninstall the MSXML6, but just can't remove it from the Add/Remove program.  I tried to reinsatll the MSXML6 but it said a newer version is already there.
How do I solve this problem?
Thanks for help.


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend