Browse by Tags

EntityGridView CustomProc from View adds a null record

I am confused why this code is in the EntityGridView. Can anyone explain why this is necessary? The result is that it adds a new entity to the list when I call my custom proc that returns no records. I don't see this with methods that return a TList, but for whatever reason, it happens with a VList....

Posted to .netTiers - General Support (Forum) by basolutions on 05-17-2007
Filed under: Custom Stored Procedure, EntityGridView, VList
Re: DeepSearch?

You rock! I've been round and round with this problem, and then finally came back to your post. This is a great way to do this. Note to self to read property names properly. For some reason I assumed it was a method name and couldn't figure out why it always returned a null value. I can go to bed now...

Posted to .netTiers - General Support (Forum) by Junto on 05-14-2007
Filed under: Custom Stored Procedure, Paging, cst, CustomMethodRecordCountParamName
Re: Paging and Custom Stored Procedure Example

I have had some success in solving this problem. The ORDER BY still eludes me, but I think a series of CASE WHEN statements would work (although ugly): ALTER PROCEDURE [dbo] . [_Company_SearchGetPaged] ( @WhereClause varchar ( 2000 ) = null , @PageIndex int = null , @PageSize int = null ) AS BEGIN -...

Posted to .netTiers - General Support (Forum) by Junto on 05-10-2007
Filed under: Custom Stored Procedure, PageSize, Paging, cst
Paging and Custom Stored Procedure Example

Hi, Would anyone like to share an example of a custom stored procedure that: Supports paging, and Returns a TList not a dataset, and INNER JOINS on one or more sub tables so a WHERE search can target the sub tables I have the following, which is an exact copy of the same generated GetPaged SP for a table...

Posted to .netTiers - General Support (Forum) by Junto on 05-08-2007
Filed under: Custom Stored Procedure, Paging, cst
trouble with custom sproc

First as I understand it, if my return values on my custom sproc are ordered right, it should return my object? here is my sql code for the sproc I am trying to write. SELECT City, State, ZipCode, AreaCode, TimeZone, MAX(CacheTime) AS CacheTime FROM dbo.USZipCache GROUP BY City, State, ZipCode, AreaCode...

Posted to .netTiers - General Support (Forum) by ecathell on 04-27-2007
Filed under: Custom Stored Procedure, Cutom Stored Procedures
Problem with custom SP ...somebody help me

Hi People i have this Sp and i try everything but wen i try to generate the code, nettiers tell me that the sp is not in the correct format. Could please somebody in the nettiers team help me... Thanks!!! this is my sp set ANSI_NULLS ON set QUOTED_IDENTIFIER OFF GO ALTER PROCEDURE [dbo].[_Negocios_AdvancedSearch...

Posted to .netTiers - General Support (Forum) by elfederiko on 04-04-2007
Filed under: .netTiers, Custom Stored Procedure, .net 2.0
Re: Advance Search Problem

I create a custom sp and try to do that search but is a dynamic SQL. And aperently nettiers do not support that kind of sp. Im new in nettiers so what do you suggest i should do? This is the SP. CREATE PROCEDURE [dbo].[_Negocios_Search] ( @Neg_NegocioID varchar(10)='', @Neg_Nombre varchar(100)='', @Neg_Calle...

Posted to .netTiers - General Support (Forum) by elfederiko on 03-29-2007
Filed under: .netTiers, Custom Stored Procedure, Cutom Stored Procedures, .net 2.0
Re: Custom sp expected format. Help Please!

Ok i really don't understand why is the format that nettiers espect os the SP. Please if someone in the nettiers team just tell me what is the problem. Thanks. Here is my sp -------------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[_Negocios_Search...

Posted to .netTiers - General Support (Forum) by elfederiko on 03-29-2007
Filed under: .netTiers, Custom Stored Procedure, Cutom Stored Procedures, .net 2.0
Bind to First T<List> Entity

Hi, This is a duplicate post but since I'm still searching for an answer I'm posting again. I apologise but I really need to find a solution to this problem. I have a list of Installations, related to an Installation is a list of Images. When listing Installations I want to select the 1st Image of the...

Posted to .netTiers - General Support (Forum) by bevan on 03-26-2007
Filed under: .netTiers, Custom Stored Procedure, ObjectDataSource, Cutom Stored Procedures, Entities, .net 2.0
Executing custome stored procedure with linked server reference?

I have included the following custom stored procedure in my build to retrieve the data from a Sybase database. SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO SET ANSI_WARNINGS ON GO CREATE PROCEDURE dbo.usp__Security__e2eGetList AS SELECT * FROM OPENQUERY(dv1stp, 'SELECT secref AS [PaceId], name AS...

Posted to .netTiers - General Support (Forum) by harki on 03-26-2007
Filed under: Custom Stored Procedure, Sybase, linked server

Page 1 of 6 (56 items) 1 2 3 4 5 Next > ... Last »