Sashidhar Kokku's blog

Blog moved.

Tue, 29 Jun 2010 03:01:00 GMT

My blog has moved to http://sashidhar.com Please update your references to point to the new site. Thanks, Sashidhar Kokku

SQL Profiler Custom Template

Fri, 20 Jun 2008 06:11:40 GMT

One of the things I found annoying with SQL Profiler (for SQL Server 2005) was that it would give me the traces of all the transactions that are happening on the server. I would not argue if its good or bad, however, I found it annoying while debugging, simply because I had to search through the junk to see where my code was being executed. So, to overcome that issue, I created a new template for SQL Profiler that would only show me data that was transmitted from my computer for a database of my choice. Here's how I did it.

Creating the template

Fire up SQL Profiler
Click on the "New Template" icon or choose from "File -> Templates -> New Template"
Your screen should look like this
Give a name to the sample template... say "AdventureWorksTracer". The idea is to get only "AdventureWorks" related trace messages originating from your computer.
Also, under the "General" tab, check the "Base new template on existing one" and pick "TSQL_SPs" from the drop-down menu. Your screen should look like this.
Click on the "Events Selection" tab. The default view would look like
Check the "Show all columns" checkbox. This will add more columns to the visible area of the screen, and also give us more options in the "Column Filters"
Click on "Column Filters" button, and set the database name as "AdventureWorks"
Further down on the left side of the window, search for "Hostname" (this will come only if you checked the "Show all columns" in step 7). In the hostname, add your computer name (you can find out your computer name by right clicking on "My Computer" -> Properties -> Computer name )
Click Ok to close this window. Finally click on Save to close the template design window as well. You may choose any extra columns you want before you close it though.
TADA... you are done now. All you need to do now is to use this new template.

Using the template

In SQL Profiler, File -> New Trace
In the screen that looks like this

select your newly created template.
Click Run, and debug your way to glory.

Advantages:

I get to see less junk coming from fellow developers.
My database name filter based template helps me start up a template for one database alone (obviously I will be working on one db at any point of time)

InnerText and TextContent

Tue, 27 May 2008 22:04:31 GMT

Just a quick tid-bit of browser specific information .

InnerText in IE => textContent in Firefox

Tested on Firefox 2+, and IE 7

ASP.NET Ajax 1.0 toolkit : Calendar Extender hide on lost focus

Mon, 19 May 2008 01:57:54 GMT

One of the problems with the calendar extender in the 1.0 toolkit is that if I use a button/image to show the calendar, I am forced to click on it again to hide the calendar. And imagine when you use it in a grid, the calendars seem to start piling up on one another like this.

Firefox 2+

IE - 7

Rather than have the end-user click on it twice to show then hide it back again, it would be simple to write a small javascript snippet that would do it for you.

     <cc1:CalendarExtender ID="CalendarExtender1" TargetControlID="txtDOB" PopupPosition="BottomLeft" Animated="True" PopupButtonID="imgCalendar"

                                                       CssClass="radcalendar" FirstDayOfWeek="Default" runat="server" OnClientDateSelectionChanged="hideCalendar" >

                                                   </cc1:CalendarExtender>

    this.Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "hideCalendar", @"function hideCalendar(calExtender) { calExtender.hide(); }", true);
  

One way to add this script is to add it for all the pages that use the calendar control, else you can just add it to the common.js that one would add to all the pages/just the masterpage of your asp.net application.

Including JS file references in masterpages

Fri, 09 May 2008 21:54:33 GMT

One of the issues I have faced with including site-wide JS files while developing web-applications is the simple fact that I was developing in Windows XP and IIS 5. And IIS puts in each of my websites as virtual-directories. So , I always have trouble including references to js files from the master-pages.

One alternative was to have a virtual directory outside the project structure and point it to the js folder, and my references would work properly. But there are other nicer ways to do the same.

1. Include the script tag as a server side tag, and give the reference to the file with a "~"

     <html xmlns="http://www.w3.org/1999/xhtml">

    <head runat="server">

        <title>Master page</title>    

        <script language="javascript" src="~/App_Common/Scripts/tablecloth.js" runat="server"></script>

    </head>

    <body>

2. Add some code to your masterpage's load event that would register the file after resolving the client url.

    protected void Page_Load(object sender, EventArgs e)

     {

         this.Page.ClientScript.RegisterClientScriptInclude(this.GetType(), "tableCloth", this.ResolveClientUrl("~/App_Common/Scripts/tablecloth.js"));         

     }

The above two approaches completely avoid having to create a virtual directory of any kind, and work all the time ... so long as the path is correct.

References : http://forums.asp.net/t/908248.aspx

Codeplex project from 1906

Wed, 09 Apr 2008 02:13:14 GMT

All I wanted to see was if there were any projects on Codeplex for SQL intellisense. What do I do....open up Firefox, type in "Sql Intellisense" in the search for codepex, and wola.....

Either the internet was that old....or maybe Codeplex stores just the last 2 digits of the year (HELLO ... Y2K !), or heck...Codeplex does not validate release dates.

Customary introduction.

Thu, 13 Mar 2008 23:08:00 GMT

Sashidhar Kokku (aka me) is a dude who gets paid for punching the keyboard on a daily basis for the past almost 4 years (as of March 2008). His continuous punching results is web-portals for healthcare insurance companies.

Regarding my education, I hold a Masters from Syracuse University in Computer Science.

Well....that sums up about me.

What am I doing here? I hope to cover some topics in ASP.NET 2.0 and above, my pet projects, my daily discoveries, my "oh-shits", and yeah...and my eureka's (No..i don't code in my bath-tub). Sparing the regular topics that I cover, I will put link to some of the nifty stuff that I bump across during my daily information-intake sessions.

Looking forward to doing a good job and keep myself occupied as well.

And yeah...I also maintain my own blog at www.dynacx.com and a personal website at www.dynacx.net.