Having years of background developing applications using MSSQL Server as the database, I encountered a roadblock when my stored procedure is required to return the id for my newly created row in oracle.
Immediate Work-Around
Since all my tables have a timestamp field, the most obvious thing to do is to query the topmost row of my table sorted by the timestamp field. For added accuracy, I also filtered my query against the userid which created the affected row.
Tab AJAX Control Toolkit Style Problem
If you’ll ask all the ASP.Net developers on what control they want Microsoft to create and include freely, I bet that Tab Control is in the top 5 list. Well, now our dreams finally came true. With the released ASP.Net AJAX last January 2007, the ASP.Net AJAX Team included 4 new controls that are not in their RC1 and Tab Control is one of them (others are AutoComplete, Calendar, MaskedEdit).
Now I am currently involved in a web application development that is deeply in need of tab-based navigation to greatly improve the page’s user friendliness. We downloaded and installed that AJAXToolkit from ASP.Net site, plugged it in one of your page, provided it’s required and necessary properties saved the file and refreshed the page. Our fingers were crossed with be waited for the progress bar to reached it’s maximum length and after the page was rendered, this is what we saw.
DataFormatString For DateTime Column
I was coding with breeze rendering my tabular data with the use of a GridView control. I successfully bound it to my ObjectDataSource and the data were displaying just fine except for one minute problem. My DateTime column was rendered as “raw” format from my SQL Server. This means that my date column displays “8/12/2006 11:47 AM”.
Using my experience from DataGrid control from my ASP.Net 1.1 days, I immediately set the value of my DateTime column’s DataFormatString property to “{0:d}” (short datetime format). I saved the page and refreshed the browser finding my DateTime column still displaying the same “raw” format. What seems to be the problem?
Podcast Mania
I stumbled across Podcasting last year when I’m browsing on MSDN’s website and came across the DotNetRocks! page. I downloaded few of their episodes and immediately got hook by the show. That’s when I switched to iTunes as my primary music player for downloading a podcast is a breeze on that player.
Over the past months, I accumulated dozens of podcast episodes from different category. From the latest in technology, programming, movies, fashion, music, business, and humor. Here are some of the podcasts I’m currently listening and recommend:
I encountered some TSQL Select problem where I want my result set to have a “number” on the first column. If for example you have a simple select statement
USE Northwind SELECT CustomerID , CompanyName FROM Customers ORDER BY CustomerID
which outputs
Different versions of .Net framework can work side by side in a single web server (IIS). But after porting my finished project to the production server (IIS 6.0 running on Windows Server 2003), I got this error message:
I have projects made with .Net framework 1.1 and 1.0 working well side by side with my 2.0 web applications but migrating it to an IIS 6.0 made my app behave that way. What seems to be the problem?
After I searched MSDN and other technical blog, I came across Scott Forsyth’s Weblog article on running multiple versions of ASP.Net. I found out that IIS 6.0 handles running an application differently from it previous counterparts.
Custom Paging in GridView Control
Introduction
I searched the entire web looking for tutorials about custom paging in GridView control in ASP.Net 2.0. Since GridView is relatively new to ASP.Net, most of my search returned custom paging using DataGrid Control.
To help others who have the same problem as I encountered today, here is the tutorial regarding custom paging in GridView. I hope you’ll have a great time reading my article as I have writing it.
Overview
While DataGrid requires additional coding for it’s paging, GridView control automatically supports paging by setting the PagerSettings property. This allows you to customize the appearance of the pager the the GridView automatically generates for you. You can set the mode of your PagerSetting to the following custom made selections
Hello World!
A fitting title for my first blog entry. Hope you’ll find this site useful. Enjoy!