Rohit Dhand

Hi every one. First of all I am sorry for not posting for a long time. Was really busy with other activities at home and work. Just to update I got my HTC HD7. Latest offering from Microsoft i.e. Windows Phone 7. To be precise, its the best thing Microsoft have produced in the last 10 years. Out of box experience and a wonderful device. Enjoying and getting habitual about my phone.... Kudos... Microsoft. They will improve this offering in 2011!!!! more................

Please find the link for the coding file as promised http://cid-0760ab0f61623b72.office.live.com/view.aspx/Public/Coding%20for%20AuthorizationDeletion.doc

Microsoft officially launched Windows Phone 7 for the world and show case some of the mobiles phones from companies like HTC, Samsung, LG that will launch Windows Phone 7 based mobiles in the later part of the year. With all the mix reviews coming from critics and tester, Microsoft is again pushing itself into the already flooded market of smart phones. Have a look at the various models: 1. HTC HD7 2. HTC 7 Mozart 3. HTC 7 Trophy 4. HTC 7 HD 5. Samsung Omnia 7   Personally I liked Samsung Omnia 7 from the looks and specifications factor (although Microsoft has been strict in asking the OEMs to go in for mimum specs at least).  Lets keep fingers crossed and see whether Microsoft succeeds or not?

Its now a confirmed news that Microsoft will officially announce the launch of Windows Phone 7 Series on 11th Oct, 2010. The phone will be running on T-Mobile and AT&T carrier providers. The event will be held in New York. Windows Phone 7 Series is a complete re-write of the Operating System and Microsoft wants to establish itself in the mobile space once again. Partners like Samsung, LG, HTC, ASUS, Dell will be launching phones based on Windows Phone 7 OS in the later part of the year. Lets keep fingers crossed and see how the market reacts to the effort of Microsoft.....

Microsoft finally released its first public beta of its much anticipated browser IE9. The browser is touted to be more faster as compare to others because of its new javascript engine code named: "Chakra".   The UI is also changed a lot and reflects more of Chrome kind of look. Other features are: 1. Full support of HTML 5 2. W3C complaint. 3. New and Fast Javascript rendering engine. 4. Uses GPU for full hardware acceleration. 5. One bar for url and search. 6. Tabs can be directly pinned to the windows task bar and it uses full utilization of jumplist. 7. Favorites icons being displayed for the most visited web sites. Download link: http://ie.microsoft.com/testdrive/ http://www.microsoft.com Thumbs up for making such a nice and stable public beta. Hope fully Microsoft may be launching the browser by Jan, 2011. Highly recommended.

Users will encounter a problem of 'HTTPS 413: The page was not displayed because the request entity is too large' . If we implement https (secured socket layer) in our website, this will cause the error to occur mainly because of two reasons: 1. Data is transmitted every time whenever the re-negotiation occurs between client and server. 2. Files uploaded by the users are of large size. The problem is because of the SSL. Whenever we implement SSL on the web site, every time the client re-negotiates with the server, data is sent again and again, which exceeds the limit of the uploadreadaheadSize, a variable to handle the data sent in the post back or reloading of the pages. In order to avoid the problem, the following command can be given at the command prompt: cscript adsutil.vbs set w3svc/3/uploadreadaheadsize 204800 (where the last 204800 is the size in bytes which we want. The default size is 48 KB. Also 3 is the index of the website to which we want to apply. We can

IIS provides method of redirecting from http to https in case you want shifting from http to https automatically (secured socket layer). To implement it, one of the methods named: URLRewrite Module can be used. The following steps are to be followed: 1. Download the rewrite module for IIS 7. The link for downloading is: http://www.iis.net/download/URLRewrite 2. Now install the rewrite module and restart the server. 3. Copy the following code in the root directory (web.config file under system.Webserver) Please note that if we want to automatically do for all the virtual directories like: http://mywebsite/india then, we have to do the following changes: url="https://{HTTP_HOST}/{RESOURCE_URI}"

Free email website Hotmail.com has improved a lot over a previous years. Stiff competition from other free email services have made them to improve according to the latest trends and standards. The latest avtaar has been excellent providing a seamless integration with cloud computing services like 'Free Office WebApps' from Microsoft. So the user is infact not only able to work with emails in a better way but rather create, edit documents, spreadsheets, presentations online through Office WebApps. If you want to use it, you need to have a hotmail, live or msn account. Few screenshots of new Hotmail version: 1. The new Folder Structure 2. New Hotmail UI. 3. Threaded Emails. 4. Online Chatting (MSN Messaging) within Hotmail UI 5. Active View to view Images like a slideshow (A cool new feature) A screenshot of creating a live document with Office Web Apps through internet explorer. I hope every one likes it and Microsoft improves more quickly their products..

In a previous article describing how to read the data from Excel file with help of C#, the end developer may face a problem of not able to read the data from a column that contains mixed data types. For e.g. if you have got a column in which the data looks like this: 125200 568585 F25363 152525 The above data will be read except for a value starting with F . This is because when we read the excel with Oledb driver , there is a " RowsToGuess " property in the registry setting which tells how many rows to scan to govern the datatype of the column. If we set that to 0, all the rows are scanned to determine the datatype. Also we need to use IMEX  attribute setting in the connection string so that the data is always read in the "Text" Format. This will help in removing the problem. The following code shows how to set the IMEX setting: OleDbConnection vConn = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\rohit.xls;Extended Properties

Normally in windows based application there is a requirement to display image in the picture box which has been read from SQL Server. The image is stored in binary format in SQL Server. So we have to convert raw format read from database into bytes and then use stream to load the bytes in the format of an image. The following code shows how to display the image in the picture box in VB.NET    Dim vbyte() As Byte = CType(myDatarow("Snap"), Byte())    Using ms As New IO.MemoryStream(vbyte)    PictureBox1.Image = New Bitmap(ms)    PictureBox1.SizeMode = PictureBoxSizeMode.StretchImage    End Using In the above code, myDatarow is the object of DataRow class that is read and “Snap” is the name of the column in the database that stores the image. 1. So firstly we convert the read image from SQL Server into Bytes array. 2. Then we use MemoryStream to read the bytes into the stream and load the same bytes in the format of image in the PictureBox. 3. We can also the “Si

In order to display an image stored in SQL Server on the Web Form, we need the concept of Generic Handler in ASP.NET. A Generic Handler is just any other web form that is added in the current form. A generic handler is responsible for fulfilling requests from a browser. A handler is a class that implements IHttpHandler interface. Normally the generic handler is having an extension of “Handler.ashx”. In my previous post, I discussed about the storing of an image in SQL Server which the user selects on the web page (.aspx) page. I will be continuing from the same process. The following interface is used: In the above screen shot, a textbox is there in which the Image id will be entered by the user which the user wants to display. Also the button will be used to show the same. And lastly an image control that will display the image fetched from the database. On the Show Image button the following coding is to be done. The hander is invoked with the help of following code: Protec

How to Store Images in SQL Server from an ASP.NET Page Normally there is a requirement in the dynamic web sites where the user uploads an image for a specific purpose like profile, product image etc. and it has to be saved in the database. This article discusses the step by step process of storing the image chosen in the ASP.NET Page into SQL Server Database. For this I have taken a small table called as “MyPhoto” which contains two fields having following details: 1. PhotoID                 Numeric                     Identity Column 2. Photo                     Image The image will be stored in the Photo Field which is of type Image and later on can be retrieved with the help of some another process which I will discuss in another post. Step 1. Create an interface in ASP.NET Page for the UI. I have created a same and giving a snapshot for the same. Step 2. Write down the code in the code behind of button having label “Upload Photo” : protected void Button1_Cli

As requested by number of students, I am posting some details about LPU's IT infrastructure (More of hardware and network components). LPU Infrastructure PDF Hope this gives details about LPU's IT infrastructure!!!!

Finally Microsoft released the RTW versions of the VS 2010 one of the most used tool in the world. It comes with .NET Framework 4 and has lot of new features to offer. Visual Studio.NET 2010 is now offered in 4 different versions: 1. Professional 2. Premium 3. Ultimate 4. Test Edition The best thing about Visual Studio 2010 is that it is itself written in WPF and offers variety new features like: Windows 7 Phone Development (really awesome) Silverlight now integrated directly as a toolbar. WCF Development RIA development jQuery out of the box support And much much more.... Soon I will be reviewing the tool.

LINQ is the new way of accesing the databases in .NET. Through this method the programmer can use the conventional syntax of querying objects in a dataset and formulate queries like they are framed in the RDBMS. The future of the database access through front end is going a sea change with the introduction of technologies like: LINQ. Will be talking about LINQ in the coming posts. Keep tuned.

Yes!!!. I am back from the campus placement drive. They are institutions of National Importance. What a culture they have.... Few pictures of the trip, please follow the link. http://picasaweb.google.co.in/dhandrohit/IITKharagpurAndIITGuwahatiPlacementDrive?authkey=Gv1sRgCOLl9ee75_mf2wE&feat=directlink

I am off to IIT Kharagpur and IIT Guwahiti for Campus placements. Blogging will be less from 23rd March to 27th March, 2010. .....

There has been a problem notified by multiple users that their USB Pen Drives dont allow them to write or delete any data because of the Write Protection Error. Even this doesnot allow the formatting of the USB Pen Drive. The reason of this problem is a virus that gets injected into the USB Pen drive and makes all the data readonly. Even the virus scanners are able to scan the virus, but they fail to clear/remove the same. In order to solve the problem download the following link: http://www.transcendusa.com/Support/DLCenter/index.asp?#Detail You select the type of USB Pen drive and size. And there will be a link for the same: Online Recovery tool . Download the tool and use it. Make sure the internet is connected at that time because it uses some files from it original server.

Organisations using Smartermail as an email solution face a problem of database backup restoration. After the restoration of the database some emails are shown blank. This is because of the indexing issue. Solution is to copy the inbox folder without copying a file called "mailbox.cfg" that is the configuration file. So delete the file and open the email account. Smartermail will automatically create this file again. This will solve the problem of blank corrupted emails.

Sometimes the user wants to run a 32 Bit application on 64 Bit server. For e.g. running smartermail 32 Bit loaded on 64 Bit windows requires certain tweak to be done. This is feasible through CORFLAGS.exe, a file that comes with the SDK of .NET Framework and and acts a utility to change the header information of .NET assembly. The following command can be used to do the same: corflags.exe /32Bit+ (if we want to convert it to 32 mode) corflags.exe /32Bit- (if we want to reverse the same) This can be used for other software also which requires this kind of tweak.

Microsoft has finally taken off every thing from its major upgrade and overhaul of the mobile software and shown it to everyone what is coming in i.e. Windows Phone 7. Microsoft now calls it as Windows Phone 7 and not Windows Mobile 7 (which was presumed). The initial reaction to the new interface is quite positive and it looks like Microsoft is back in the business of Mobile. The UI is based on a term called "Metro" Microsoft is trying to get the Windows Phone 7 by the end of year 2010 which means the holiday season. Few screenshots of the Windows Phone 7:

There is a genuine problem which all the users of Nokia 5800 Xpress Music Edition are facing. Whenever they update their phone software to ver 30.0 or higher, the music stored in the memory card stops playing. This happens because of the lock code of the songs is overwritten. There is a workaround to solve the problem: 1. Hard Reset the phone which can be done by pressing a combinations of buttons. Please follow the link given below to read and see how it is done. Hard Reset Nokia 5800 Xpress Music 2. Follow the steps given in the Pdf file. The pdf file can be downloaded from the following link: PDF File 3. And copy the keys of all DRM music content (which is also told in PDF file). Nokia 5800 Xpress Music Keys I have used this method to unlock the content again. It works flawlessly.