Microsoft.NET

Exports excel data to SharePoint custom list with desired column names!

So once again I am back with a blog post… Today we will see that how to import a spreadsheet inside a custom list with defined columns. We are ready for production deployment for an application. This application contains the master data for cities all over the world. Client provided us the list of 9000 Exports excel data to SharePoint custom list with desired column names!

Resolved: The security validation for this page is invalid. Click Back in your Web browser, refresh the page, and try your operation again.

During my SharePoint project i need to clean up the site for better performance.  So first thing i started to delete the closed web parts from web part pages. As there were so many web part pages in the application so i decide to write a web application that can delete the closed web parts Resolved: The security validation for this page is invalid. Click Back in your Web browser, refresh the page, and try your operation again.

Common errors with SharePoint 2010 development using Visual Studio 2010 in x64 architecture: Resolved

“The type or namespace name ‘SharePoint’ does not exist in the namespace ‘Microsoft’ (are you missing an assembly reference?” (Even you add Microsot.SharePoint.dll reference in your project and import the namespace in code but while building the solution you will get above mentioned annoying error.) OR “FileNotFoundException was unhandled: The Web application at http://localhost/ could Common errors with SharePoint 2010 development using Visual Studio 2010 in x64 architecture: Resolved

File Download from SharePoint Document Library in Forms Based Authentication Scenario

I was writing the code for downloading a file from a SharePoint document library using Forms Based Authentication. Every time file was getting downloaded with 8kb of size when i was opening them they were showing that file is not supported. I opened one of downloaded files that was actually a word file, in notepad File Download from SharePoint Document Library in Forms Based Authentication Scenario

Sql Server: Insert comma separated values in different rows

This is a code snippet for a Stored Procedure which accepts a comma separated values in parameter @Retailers which needs to be stored in a table with different rows. One fine day i had such type of requirement and i fount this post in a forum. I felt like it to share with you. Declare Sql Server: Insert comma separated values in different rows

Triggers

A TRIGGER is a special type of stored procedure, which is ‘fired’ automatically when the data in a specified table is modified. It is invoked when an INSERT, UPDATE, or DELETE action is performed on a table.   Creating a TriggerSyntax: CREATE TRIGGER trigger_nameON { table | view } [ WITH ENCRYPTION ] {     Triggers