While working with LINQ, you must have wondered what the difference between the IQueryable and IEnumerable is. The primary difference is that the extension methods defined for IQueryable take Expression objects instead of Functional objects, meaning the delegate it receives is an expression tree instead of a method to invoke. IQueryable is inherited from IEnumerable. … Continue reading IQueryable vs IEnumerable
How to call the page methods using asp.net ajax and jquery
Introduction: This article describes how to design & invoke the page methods using asp.net ajax and jquery. The topics that are covered in this are What are page methods How to enable page methods in a web page. Can we implement page methods in a web page? Can we implement page methods in a user … Continue reading How to call the page methods using asp.net ajax and jquery
How to resolve Untrusted Enterprise Developer (Apple IOS IPhone)
After so much of trail and error towards learning IOS development/distribution of app for enterprise, I made my first "HelloWord" app and successfully deployed it on the iphone via custom distribution medium. I was excited to see that the app (Enterprise distribution not via app store) has finally got installed. When I try to open the app, I … Continue reading How to resolve Untrusted Enterprise Developer (Apple IOS IPhone)
How to display HTML content in Microsoft Reporting Services report
In Microsoft SQL Server Reporting Services did you know that we can display html text as well ? Why should you be even excited about the ability to display HTML in the reports, well here are the reasons It will let you display HTML mark up text like Bold text, colored text and much more. … Continue reading How to display HTML content in Microsoft Reporting Services report
How to change local path in team foundation (TFS) on my machine
I have downloaded all of my code in a defined location let's say c:\saiworkingfolder. Over a period of time the size of that folder has grown up. Due to the size limitation on the hard disk. I had to change the local path in TFS. To do that, open visual studio (mine is 2012), go … Continue reading How to change local path in team foundation (TFS) on my machine
Npm behind a corporate web proxy
One day, I had to start working on phonegap. Upon reading some documentation online, the first thing I understood was to install the phone gap by running the command. npm install -g phonegap After a very long pause by a spinning wheel, it showed the following message. npm ERR! network connect ETIMEDOUT npm ERR! network … Continue reading Npm behind a corporate web proxy
Table variable based Template to iterate through the default constraints of the tables
Get a list of default value constraints in sql server and replace them to your wish
One day, while working on a project. I hit a wall. The wall says, the date and time should be displayed according to the local datetime settings. E.g: A visitor while visiting the site, should display the US date and time (dd/mm/yyyy), where as a user visiting the site from india, should have india date … Continue reading Get a list of default value constraints in sql server and replace them to your wish
The OLE DB provider “OraOLEDB.Oracle” for linked server “” returned a “NON-CLUSTERED and NOT INTEGRATED” index “” with the incorrect bookmark ordinal 0
The good thing with linked servers is, you can write queries to fetch the data from a remote server (via linked) in your sql procedures and more. We happened to test the connectivity of a oracle server due to an upgrade. When a new Linked server connection is created using the UI and ran a … Continue reading The OLE DB provider “OraOLEDB.Oracle” for linked server “” returned a “NON-CLUSTERED and NOT INTEGRATED” index “” with the incorrect bookmark ordinal 0
SQL SERVER Cursor Template
A sql code pasted here so it can be referred easily. /***************************************************************** Cursor Template ****************************************************************/ Declare @vendor_id int; Declare @vendor_name varchar(10); DECLARE curName CURSOR FOR SELECT BusinessEntityID, Name FROM Purchasing.Vendor WHERE PreferredVendorStatus = 1 ORDER BY BusinessEntityID; --Replace this line to suit your needs OPEN curName; FETCH NEXT FROM curName INTO @vendor_id, @vendor_name; WHILE @@FETCH_STATUS … Continue reading SQL SERVER Cursor Template
Devakumar Sai Chinthala 