Add this key in your config file -
<globalization enableclientbasedculture="true" culture="en-GB" uiculture="en" />
Also while passing date in your query use the date variable as like for eg:-
where fromdate between ' + Convert.ToDateTime(addDate2).ToString("yyyy-MM-dd") + "'"
Hope it helps