I made a post in my Wordpress blog on how to export GridView data to DataSet and eventually to an XML Excel Spreadsheet.

You may view the entry there and feel free to post your comments/suggestions.

Plugging our event.:)

PHINUG will be delivering a talk to Subic-Olongapo IT Society (SOITS) on 28 June 2008. If in case you are near the area, you can contact SOITS for further details. :)


Cross posting from my blog ( Building Some Web TreeViews )

The TreeView control in ASP.NET 2.0 is used to display hierarchical data, such as table of contents or file directory in a tree structure. In most applications that I do, I use the TreeView control to show file directory structure. I was able to create a class that populates a TreeView provided with a physical directory structure residing on the same computer as to where the server is running. Rename the file below to .dll and use it as a reference on your web application. Once added to your web application usage would be:

By default, the variable location will treat the path as a virtual path. If you want to specify a specific physical directory, you can specify the 8 character directory format as a location value but you need to specify the property “isWeb” as “false” and as shown above. The “TreeView1″ is assumed to be a TreeView control placed onto the ASPX file. For testing purposes, you can put in your code behind the following code without placing a TreeView control in your ASPX file but will output the same.

Physical Drive TreeView DLL

The challenge for me is to bring the same functionality to a SourceSafe database which is despite having a directory like structure isn’t directory based at all when accessed programmatically. Furthermore, the DLL provided with Visual Source Safe 2005 isn’t a native .NET object but a COM interop one.

Luckily, using the same logic behind the previous DLL, I managed to create a DLL to populate a TreeView from a SourceSafe database. The constructor needs only 3 parameters namely the database location, username, and password.

Sample usage would be:

Same with the code above, the code assumes that there’s a TreeView control instance in the ASPX file that has an ID of “TreeView1″.

Sourcesafe TreeView

For questions, feel free to add some comments
Just to dispel rumors or claim/s that contests being run here are "fakes/jokes", I would like to share the picture of what I got for the Office 2007 contest ran by Keith.

(clockwise: launch bag, 2 books, launch pad (partly hidden), discount voucher (partly hidden) and the 2 launch kits that contains office 2007 professional and microsoft office groove).

Again, thanks Keith for the prizes and I really appreciated that. :D

Yes, it is IEs or Internet Explorers.

The trend of tableless site design is significantly growing. The idea behind this concept is you'll use CSS to determine the width and height of our pseudo-"tables". However, it is not a secret that CSS is not consistent across browsers and it depresses developers (and site designers as well) that a site does not appear the way it should be.

If you are currently using IE7, chances are, your site might not behave correctly on IE6 (or for any browser for that matter). There are circulating information over the internet how to tweak using IE6 and IE7 side by side in a single machine. Some of these include various changes in the registry and other miscellaneous stuff. Since we started deploying our site (PEP), we understand that majority of our target audience uses IE as their primary browser and there will be differences from our development machine as we are using Firefox being more "standards" compliant than IE.

So as not to compromise the site design (knowing the fact that site content is secondary to aesthetics), we installed this 10.6 mb file download that enables us to install multiple versions of IE (even up to IE 3.0). Just imagine you have IE versions from 3.0 to 7.0. It's not that we're keeping this program as "secret" but I still find some people asking for ways on how to test their site on IE6 when IE7 is installed in their machines. So I guess, if you are more concerned on how your site will look on different browsers, this program is a good shot!

Of course, the program is not perfect; the older browsers doesn't load sites from the internet but load sites from your local IIS/Apache webservers. As far as we our concerned, the only issue that we found by using this program is that the we cannot retrieve fully the cookie information that we have set by loading the site.

If you want to check this, download the program from Tredosoft.

Happy coding!
I am now breaking my blogging "virginity" here at DevPinoy Stick out tongue. Before everything else, let me introduce myself and a bit of history about my programming life.

I'm Patrick, a web programmer here in the Philippines. I already heard DevPinoy while I am still studying although I'm a bit hesitant at joining since I thought it would be a ".NET world" in here and that word was nowhere in our college vocabulary. My first encounter with .NET was last 2004 when I got a free entrance to Microsoft Philippines' Devdays 2004. I must admit that back then, I was an open source zealot attending to a Microsoft event where deep inside myself, I am laughing or countering anything that they talk about particularly in security. Nonetheless, that event triggered my "thirst" for knowledge and from there I started studying .NET (even if the school doesn't teach it).

My exposure to .NET grew very much when I started working for Microsoft Philippines as an Academic Developer Evangelist. While my primary language for web development is PHP, I began to like and to favor more ASP.NET not just because my work demands for it but for myself, I have realized that it's much more better (based on my personal metrics on what a web technology should be). Although because for some reasons that I can't disclose, I left the company for a more technical role in a different company. Right now, I am working as a web developer for GMA NMI, a subsidiary of GMA Network, Inc.. My first yet a very large project with them is the Philippine Entertainment Portal. Although it is not a .NET house, I will be soon having my own .NET project, according to my manager, and still it would be for the web.

So I guess I'll end my story here and I'll try to be more active in blogging about technology. This isn't my first blog at all; in fact this is my fifth blog - I ceased to use the first one, I abandoned the second one, I have stalled using the third one, I am maintaning the fourth one and this is the fifth. I'll share here sometimes stuff about the web particularly in AJAX, PHP, and ASP.NET.

That's all for now and I'll switch now to the coding window. Stick out tongue