How Can we call a Stored Procedure in a Custom Lookup

[mayankkshah]

Can anyone help me call a stored procedure in a custom lookup?

[luongnv6]

try this

 [LookupScript("LookupKey", Expiration = -1, Permission = "?")]
 public class LookupName : LookupScript
 {
     public LookupName ()
     {
         this.IdField = "Id";
         this.TextField = "Name";
         this.getItems = this.GetItems;
     }

     protected IEnumerable<dynamic> GetItems()
     {
         using (var con = SqlConnections.NewFor<ABCRow>())
         {
             return con.Query(@"StoreProcedueName", null, commandType: CommandType.StoredProcedure);
         }
     }
 }