Sunday, December 30, 2012


if you are using kendo UI web for MVC and you are getting the error when you are click on create new.

just hide/remove the code from create & Edit razor view of your controller

 @section Scripts {  

*Now This problem is resolve in VS 2013

Wednesday, December 26, 2012

silverlight hyperlink button image in datagrid column

In tool hyperlink image button in silverlight datagrid we can set property, command like other control.
the binding of the datagrid column is:

  <sdk:DataGridTemplateColumn Header="Buyer Comments" Width="2*">  
                 <StackPanel Orientation="Horizontal">  
                   <HyperlinkButton Content="" Width="30" Command="{Binding Source={StaticResource srConfirm}, Path=ShowComments}"   
                            CommandParameter="{Binding}" ToolTipService.ToolTip="{Binding Path=Comments}">  
                       <ImageBrush ImageSource="/images/Icons/add.png" Stretch="Uniform" />  

here srConfirm is the Viewmodel of the window which i defined in cs.

     private VMEditReceiveBuyerComment _dataContext = null;  
     public EditBuyerCommentReceival()  
       _dataContext = new VMEditReceiveBuyerComment();  
                this.Resources.Add("srConfirm", _dataContext);  
       this.DataContext = _dataContext;  

Sunday, December 23, 2012

SQL auto generate last column id without auto increment

If we want to get a table autogenerate column id, without auto increment column. we can do it easily.
we can also made it globally for all table. We can create a table name paramaterize store procedure that
will give us table last column ID without using auto increment column.

      @tableName [varchar](100),  
      @locationId [int]  
 declare @newID varchar(20)  
 declare @dbID varchar(20)  
 declare @generateID bigint  
 declare @ReturnValue varchar(100)  
  if exists(select * from DB_TablePKID where LocationID=@locationId and TableName=@tableName)  
   --table name exists  
   set @ReturnValue= (select MaxID+1 from DB_TablePKID where LocationID=@locationId and TableName=@tableName)  
  else --table name is not exists.  
   -- generate new first ID for the supplied table  
   select @dbID= DBid from DB where DBLocationID=@locationId  
   set @newID=@dbID+'00000000000001'  
   set @generateID=convert(bigint,@newID)  
   set @ReturnValue=@generateID  
   select @ReturnValue  

declar the store procedure in C#

 public long GetTablekeyID(string tableName, int locationId)  
       long id = 0;  
       // id = _db.spSET_GetDB_TablePKID(tableName, locationId);  
       System.Data.Objects.ObjectResult<string> sid = this.DataContext.spSET_GetDB_TablePKID(tableName, locationId);  
       foreach (string aa in sid)  
         id = long.Parse(aa.ToString());  
       return id;  

Now call from anywhere with your any table name. it will return last id of your table. here locationID is optional.

Tuesday, December 11, 2012

C# globally check List instance's item count

 We can check an instance of a list count() globally

 public class CheckListCount  
     public bool IsOneItemEntry(IEnumerable<dynamic> objEntity)  
             String ErrorMessage="";  
       bool IsValid = true;  
       if (objEntity.Count() == 0)  
         IsValid = false;  
         ErrorMessage = "At least one item must be available.";  
       return IsValid;  

Now create instance in any class &  check any list's instance Count();

  private CheckListCount _CheckList = new CheckListCount();  
       List<CommentReceipt> CommentReceiveItem = new List<CommentReceipt>();  
         foreach (LAB_LDCommentReceipt receipt in ViewData.LdCommentReceiveList)  
           if (receipt.AppStatusID>0)  
          if (_CheckList.IsOneItemEntry(CommentReceiveItem))  
           // do something  

Monday, December 10, 2012

Date range query in Entity framework

Entity Framework Date rang query is not same as like LINQ.
You can try like this

 var events = this.coreDomainContext.Events.Where(  
   e => EntityFunctions.TruncateTime(e.EventDate.Value) >= DateTime.Today  
    && EntityFunctions.TruncateTime(e.EventDate.Value) <= EntityFunctions.TruncateTime(endPeriod))  
   .OrderByDescending(e => e.EventDate)  

For details you can See

Tuesday, December 4, 2012

silverlight ria services association class relationship

If you have association relationship in your class. then normally you will not get the associated list data using Silverlight ria service. how to solve it..? please see this

MSDN Silverlight Ria Service Fourm

vfpoledeb.1 provider is not registered on the local machine

Have u Install VFP Ole DB Provider in your System ? If No then Please Install it from following link.