Tuesday 24 June 2014

SSIS: Error: A rowset based on the SQL command was not returned by the OLE DB provider.

you must put set nocount on and set nocount off around your stored procedure body. SInce the rowcount returned by the stored procedure is returned before the actual resultset, SSIS attempts to read that in as the resultset, which is why it complains about an invalid resultset. set nocount on will supress the rowcount message and only return the resultset.

Tuesday 10 June 2014

ASP.NET Web form on iPAD

How to make a website full screen on the iPad?

add this tag to your webpage <Header> section, and make a button on home page
<meta name="viewport" content="initial-scale = 1.0, maximum-scale = 1.0, user-scalable = no, width = device-width">

Diable Zoom
<meta name="viewport" content="initial-scale = 1.0, maximum-scale = 1.0, user-scalable = no, width = device-width">

Let Page cannot move, more like native app
<script type="text/javascript">
        window.attachEvent('load', document.ontouchmove = function(event) { event.preventDefault(); }, false);
    </script>