Geeks With Blogs


Agha Usman Ahmed JILAWATAN February 2009 Entries
Configure SQL Server 2008 for File Stream
Well, from past two days I am working on SQL Server 2008 new feature called File Stream. In the period of SQL Server 2005 when we want to store some files to the database we can have that using varbinary(max) but that approach is not either smart nor popular amongst the developers. So, many developers like me wants to store images on any physical location and keep the file location in the table. But, that have issues too, what if somebody delete the files from physical location ? will file entries ......

Posted On Saturday, February 28, 2009 8:14 PM

How to Group by Just Date Portion Of DateTime Field
There are times when we need to group by the table with the date. But Datetime field also contain time part which is very deep. So, there is no way you can group by datetime field and see correct records because it will group by including the time portion of DateTime field. So, to get rid off the time portion in group by clause here is a quick query. 1: select dateadd(dd,0, datediff(dd,0,dateCreated)) as Date,count(*) TotalCount from tblRecords 2: group by dateadd(dd,0, datediff(dd,0,dateCreated)) ......

Posted On Friday, February 27, 2009 4:41 PM

Installing SQL Server 2008 Express
Currently, by the time I am posting this stuff SQL Server 2008 is in CTP. And off course, it has several installation issues. For the very first time, when I sit for the installation of SQL Server 2008 Express believe me I run the setup up to four times. So let me share with you, you must need to have the following items installed on your system. Windows Installer 4.5 Redistributed .net Framework 3.5 SP 1 or .net Framework 3.5 SP 1 (Full Download) Power Shell 1.0 Without installing the above component, ......

Posted On Tuesday, February 24, 2009 12:32 PM

Google Can Do Mistakes So Why People Don't


Finally Google Analytics rectifies its spell mistake. For detail please see this post. For detail please see this post.

Posted On Friday, February 20, 2009 2:24 AM

Prevent Request Timeout in
In one of our application we want our user to upload data up to 1GB and the most interesting part is we want this uploading via HTTP. I mean, we have plan to use FTP but that is for future. For now we need to make it with HTTP. Off course, uploading data in GB’s requires much extra time then the default configuration and same problem with the request size. So, to make it done we need to change the configuration of following items. executionTimeOut : Default value is 110 seconds, we need to make it ......

Posted On Thursday, February 19, 2009 8:34 PM

Dynamically control the scroll amount of marquee
Having a marquee on a page is not a big deal but what if somebody wants user to adjust the speed of the moving text. So the idea is we have many marquee in one page and we want to adjust their speed using two javascript Buttons called “Speed Up” and “Speed Down” The logic is very simple, the marquee tags which you want to control with the help of buttons give them name in my case it is “Scrollers” (Remember it is name not id, so you can give same name to as many controls). Now call the following ......

Posted On Monday, February 16, 2009 4:00 PM

Passing Parameter To User Control On A Modal Popup
This is the most demanded scenario for the one who are using AJAX Control Toolkit, I mean I have seen most of the people asking for this feature on forum. Unfortunately, we have no such functionality provided in Modal Popup because the control get rendered once the page is loaded and the Modal Popup is just a JavaScript which work is just to display a div which is hidden. Here is a little work around for those who wants to pass parameter to user control using Modal Popup. Basically, ......

Posted On Sunday, February 8, 2009 1:35 AM

Disable Control When AJAX is in progress
If the AJAX call to the server take too much time, then there is a possibility that user might press some other buttons or some other event occurred which will cause your AJAX call to stop and make a new request. To overcome this situation, I decided to have div on the top of the page so that while AJAX call is in progress user cannot do any thing else. So I simply Drag and Drop a Update Progress Control and write the following stuff. <asp:UpdateProgress ID="UpdateProgress1" runat="server"> ......

Posted On Friday, February 6, 2009 2:08 AM

Event Bubbling in Javascript
Today, while creating some javascript popup I had a condition in which I place onclick function on body tag. I had an other button which also implement onclick. So the code looks like as follows 1: <body onclick="disappearPopup()"> 2: <a href="#" onclick="ShowPopup()">Show me</a> 3: </body> So, what happen is whenever link is click the body clicked even called automatically. Practically speaking, we need to cancel the body onclick even each time we click the link click. And ......

Posted On Monday, February 2, 2009 6:03 PM

Send Welcome email to user using Membership API
While using Membership API, It is a very normal task to send user a registration or verification email. We can achieve that using two ways one is using the default email setting of Create User Control and other is by implementing CreateUserWizard.CreatedUser event Method 1: Drag and Drop the create user control, right click then properties and find MailDefination and set appropriate values for each property. BodyFileName is basically the location of the file which contains the body of the email. ......

Posted On Monday, February 2, 2009 6:03 PM

Copyright © Agha Usman Ahmed | Powered by: