http://www.linkedin.com/groupAnswers?viewQuestionAndAnswers=&discussionID=19725684&gid=43315&trk=EML_anet_qa_ttle-0Qt79xs2RVr6JBpnsJt7dBpSBA
http://mef.codeplex.com/Thread/View.aspx?ThreadId=35083
Saturday, July 24, 2010
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
http://www.codeproject.com/KB/aspnet/MVC2Introduction01.aspx
Friday, July 23, 2010
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))
=FormatCurrency(RunningValue(Fields!Totalamt.Value, Sum, "table1_MemberName"))
--Running total never reset
=FormatCurrency(RunningValue(Fields!Totalamt.Value, Sum, Nothing))
Wednesday, July 14, 2010
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
http://msdn.microsoft.com/en-us/library/aa337169.aspx
--expression
http://msdn.microsoft.com/en-us/library/ms157328.aspx
Tuesday, July 13, 2010
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;
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;
Tuesday, June 22, 2010
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
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
Wednesday, May 26, 2010
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"
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"
Subscribe to:
Posts (Atom)