MVC Scaffolding – Make website efficiently

Recently, I came across MVC Scaffolding to generate ASP.Net MVC Applications quickly using Package Manager and T4 templates. I created very basic application using this. Here are the steps I followed: 1. Create new MVC3 web project called EmployeeApplication. 2. Open Package Manager console. If its not installed on your VS 2010, get it from… Read More MVC Scaffolding – Make website efficiently

Writing Sql Results to Excel Sheet

Its a one line query which writes the result set to Excel Sheet. OpenRowSet loads the driver, open Excel connection string and writes the data into specified location. INSERT INTO OPENROWSET (‘Microsoft.Jet.OLEDB.4.0’, ‘Excel 8.0;database=C:\test.xls’, ‘SELECT * FROM [Sheet1$B4:D4]’) SELECT ‘aaa’, ‘bbb’, ‘ccc’ –Select statement can be replaced with your own Select Statement from the database… Read More Writing Sql Results to Excel Sheet