Recently I developed a WPF MVVM application using MySQL as database. I faced a lot of problems!

One Issues i faced was when i retrieve the data from data base using linq i am getting exception  "Unable to convert MySQL date/time value to System.DateTime". When i checked the data has empty /0000-00-00  as date. When i checked in the internet i found the solution. 

Fix one Change or fix the Dates to a correct date.

Fix Two 

add the following property to connection string 

convert zero datetime=True;

You can set this when you connect to the data base as well. You have to click advanced and make the "convert zero datetime" property true;

When i tried to follow MVVM architecture in WPF, i faced the challenge of how to do Navigation to pages in Frame. finally i figured it out in the internet.

You need to have  a navigator class like following,

In your App.xml.cs file under the OnStartup method put the following code

Now you can call any pages in the ViewModel like the code follows

Happy Coding

Problem

PhoneGap Android Application crashes when orientation changes

Solution 

Some changes need to be done in the AndroidMainfest.xml file 

Put the following to the Main activity or all the activity you have

android:configChanges="orientation|screenSize|keyboardHidden" 

Today i found a simple way to fix the Header and Footer of the HTML page to top and bottom respectively and make the content scroll able, it will be useful when we have list of items and fixed header & footer in mobile applications. 

Here is the HTML you have to use






Here is the CSS you have to use.