Sunday, April 19, 2015

Cannot generate deployment plan SSDT

Delete the .dbmdl file in your database project.

Getting relative virtual path from physical path asp net c#

var relativePath = "/" + physicalPath.Replace(HttpContext.Current.Request.PhysicalApplicationPath, String.Empty).Replace("\\""/");
Or use the extension method
/// <summary>
/// Get relative path from physical path
/// </summary>
/// <param name="di">DirectoryInfo</param>
/// <returns></returns>
public static string GetRelativePath(this DirectoryInfo di)
{
 return "/" + di.FullName.Replace(HttpContext.Current.Request.PhysicalApplicationPath, String.Empty).Replace("\\""/");
}

Wednesday, April 15, 2015

How to add serial no in crystal report cross tab

No option in crystal report instead use sql server's DENSE RANK FUNCTION
e.g.
SELECT DENSE_RANK() OVER(ORDER BY g.[FirstColumnInCrossTab]) SrNo, * FROM 

Monday, April 13, 2015

How do I convert an enum to a list in asp net C#

Enum.GetValues(typeof(SomeEnum)).Cast<SomeEnum>().Select(v => v.ToString()).ToList();