ASP.NET & MVC

http://www.linkedin.com/groupItem?view=&srchtype=discussedNews&gid=43315&item=24397298&type=member&trk=EML_anet_qa_ttle-0Qt79xs2RVr6JBpnsJt7dBpSBA


http://www.codeproject.com/KB/aspnet/MVC2Introduction01.aspx

SSRS - running total

--Member wise running total
=FormatCurrency(RunningValue(Fields!Totalamt.Value, Sum, "table1_MemberName"))

--Running total never reset
=FormatCurrency(RunningValue(Fields!Totalamt.Value, Sum, Nothing))

SSRS, Cascading Parameters and Expression

-- dropdown filter
http://msdn.microsoft.com/en-us/library/aa337169.aspx

--expression
http://msdn.microsoft.com/en-us/library/ms157328.aspx

UNIX, crontab file

-- Basic UNIX script command
http://freeengineer.org/learnUNIXin10minutes.html

--list Crontab file

crontab -l

--edit crontab file

crontab -e

--Get yesterday using UNIX script
today=`date "+%Y%m%d"`
#get yesterday
date "+%Y%m%d"
date +%Y%m%d -d "yesterday"

CurrentDate=`TZ="GMT+24" date +'%y%m%d'`
echo $CurrentDate;

YESTERDAY=$((`date +%d` -1))
MONTH=`date +%m`
YEAR=`date +%Y`
NDAY=`date +%u`
WEEKDAY=${DAYS[`date +%u`]}
if [ $YESTERDAY -eq "0" ]
then
MONTH=$((MONTH-1))
if [ $MONTH -eq "0" ]
then
MONTH=12
YEAR=$((YEAR-1))
fi
set `cal $MONTH $YEAR`
shift $(($# - 1))
YESTERDAY=$1
fi
echo $YEAR$MONTH$YESTERDAY;
varyesterday="$YEAR$MONTH$YESTERDAY"
#end yesterday

echo $varyesterday;

String must be exactly one character long.

When you have DBML lINQ entity fields with CHAR data type. you will get an error while retrieve the data.

Solution:
----------
1) go to the DBML entity
2) select field
3) press F4
4) change data type to string from char, where you have DB data type VARCHAR(1)
5) Save

Cannot add an entity with a key that is already in use, LINQ

When you have table with ID coulumn (uniqueidentifier) and default value = (newid()),
than the above error occur.

To Resolve:

1) go to your .DBML file design view
2) go to property of particular columns
3) set "Auto generated Value" = true.

it will add following in DBML file IsDbGenerated="true"

Power shell, installutil

Error occur while installing powershell dll.

System.Reflection.ReflectionTypeLoadException: Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information

Resolution:
make sure you have all the project reference dll in the project, developer always forgot reference dll while delpoying the project.

alternate approch is to load the reference DLL into GAC