Passion is not a logic; it's an emotion.
The repository and unit of work patterns are intended to create an abstraction layer between the data access layer and the business logic layer of an application. Implementing these patterns can help insulate your application from…
Read More
protected void btnExport_Click(object sender, EventArgs e) { DataTable dtTable = new DataTable(); DataRow dtRow; dtTable.Columns.Add(“SNo”, typeof(int)); dtTable.Columns.Add(“Address”, typeof(string)); for (int i = 0; i <= 9; i++) { dtRow = dtTable.NewRow(); dtRow[0] = i; dtRow[1] =…
Read More
Sample data download: here Declare @tempAttendance table(EmpID int, EmpName varchar(50), edate int, ecode varchar(5)) insert into @tempAttendance SELECT empid, empname, code as ‘edate’, value as ‘ecode’ FROM [dbo].[hattendance] UNPIVOT ( value FOR code IN ( [1],…
Read More
Sample Data download: http://goo.gl/lcOf8z Generate excel report as below. Username, Address, City, State, Zip, Question 1, Question 2, Question 3, ….. Prakash, test, anand, gujarat, 388001, Answer 1, Answer 2, Answer 3,.. Chirag, test, anand, gujarat,…
Read More
<script> addCommas = function(input){ // If the regex doesn’t match, `replace` returns the string unmodified return (input.toString()).replace( // Each parentheses group (or ‘capture’) in this regex becomes an argument // to the function; in this case,…
Read More
finally its resolved by using, <system.webServer> <validation validateIntegratedModeConfiguration=”false” /> <modules> <add name=”ScriptModule” preCondition=”integratedMode” type=”System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35″ /> </modules> <handlers> <remove name=”WebServiceHandlerFactory-Integrated” /> <add verb=”POST,GET” name=”Ajax” path=”ajax/*.ashx” type=”Ajax.PageHandlerFactory, Ajax” /> <add name=”ScriptHandlerFactory” verb=”*” path=”*.asmx” preCondition=”integratedMode”…
Read More
I have installed windows 8 in my laptop and tried to open ‘Android SDK Manager’. It was not open. By googling I found the solution as below. Go to android-sdk folder what you had set path…
Read More
As generally we do in asp.net project, I have created a global resource file for storing common error messages, info messages, labels etc in my first MVC4 project. I used ready-made validation.js for giving validation. I…
Read More
SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE FUNCTION [dbo].[unqSplit](@String nvarchar(4000), @Delimiter char(1)) RETURNS @Results TABLE (value nvarchar(4000)) AS –this function takes two parameters; the first is the delimited string, the second is the delimiter…
Read More
The story of an ant (employee) The Story of of Management vs. Associates – A funny representation; A presentation I received from a friend
Read More