Month: June 2014

Posted in SQL Server Uncategorized

MSSQL Selecting top 10 but include columns with duplicate values

SAMPLE RECORDS Query for getting top 10 records based on the company values with duplicate values select…

Posted in MVC Uncategorized

UnitOfWork Generic Repository

The repository and unit of work patterns are intended to create an abstraction layer between the data…

Posted in Asp.Net Uncategorized

Export DataTable to Excel/CSV C#

protected void btnExport_Click(object sender, EventArgs e) { DataTable dtTable = new DataTable(); DataRow dtRow; dtTable.Columns.Add(“SNo”, typeof(int)); dtTable.Columns.Add(“Address”,…