Skip to main content

Posts

Showing posts from April, 2013

Unable to convert MySQL date/time value to System.DateTime - Solved

Few days back I got an exception like 'Unable to convert Mysql date/time value to system.datetime' but this happened only after deploying and locally everything was working fine. After googling for sometimes found the reason that, it was due to the formatting difference between Mysql and C# also empty date value is causing some issue. Later found the below solution to fix'em. Add an extra property(Convert Zero Datetime = true) to connectino string. e.g server=localhost;User Id=root;password=pwd;database=test; Convert Zero Datetime=true Solution obtained from StackOverflow :)

Animated Gif not working when used with window.location

Today I came across a peculiar problem, might be known to many but I have never got into this before since this is the first time am trying this ;). Problem is like whenever location.href or window.location is used I can’t show animated GIF image as progress bar. I googled for few mins and found various solutions like using Iframe for the progress icon alone and some gave me some hack like adding src of the image tag again after navigation code. Code that wasn’t working: Function(){ Showprogressbar(); Location.href = “”; } But something strokes my mind to change the position like we used to do with Jquery plugins (when fighting to integrate multiple plugins) ;). This gave me a simple solution like below and it worked :) Working Code: Function(){ Location.href = “”; Showprogressbar(); } Hope it helps you too. If it doesn't post your problem as comment and I will try to give you the solution at the earliest.