InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 02:49:24 GMT20http://www.sqlservercentral.com/Forums/Topic1422026-391-1.aspxhave you captured a trace of that new C# code running?Wed, 20 Feb 2013 11:55:38 GMTmister.magoohttp://www.sqlservercentral.com/Forums/Topic1422026-391-1.aspxfixed the C# code :[code="vb"]SqlCommand cmd = new SqlCommand("casp_GetExist", cnt); SqlParameter parameter = new SqlParameter(); cmd.CommandType = CommandType.StoredProcedure; //The parameter for the SP must be of SqlDbType.Structured parameter.ParameterName = "@BLMJ_LIST"; parameter.TypeName = "CampaignIdList"; parameter.SqlDbType = System.Data.SqlDbType.Structured; parameter.Value = dataTable; cmd.Parameters.Add(parameter); SqlDataReader sqlDR = cmd.ExecuteReader();[/code]but dont get recordset on :sqlDR Wed, 20 Feb 2013 06:33:10 GMTpeleghttp://www.sqlservercentral.com/Forums/Topic1422026-391-1.aspxMaybe what you really need to do is post the C# code as that seems to be calling wrong...Wed, 20 Feb 2013 06:12:16 GMTmister.magoohttp://www.sqlservercentral.com/Forums/Topic1422026-391-1.aspxBecause you are declaring a parameter for the sp_executesql to use, but not actually using it in the query to execute...You can either change the last line to this:[code="sql"]execute sp_executesql N'exec casp_GetExist @BLMJ_LIST',N'@BLMJ_LIST CampaignIdList READONLY',@p3;[/code]or this[code="sql"]exec casp_GetExist @BLMJ_LIST=@p3;[/code]Wed, 20 Feb 2013 06:11:38 GMTmister.magoohttp://www.sqlservercentral.com/Forums/Topic1422026-391-1.aspxi am passing table from C# to sql.on sql this is my code :[code="sql"]CREATE TYPE [dbo].[CampaignIdList] AS TABLE( [BLMJ] NVARCHAR(50) NOT NULL )GOCREATE PROCEDURE [dbo].[casp_GetExist] @BLMJ_LIST CampaignIdList READONLYASBEGIN SET NOCOUNT ON; Select * from @BLMJ_LISTENDGO[/code]then i take the code as i see it on the profiler :[code="sql"]declare @p3 dbo.CampaignIdListinsert into @p3 values(N'1247')insert into @p3 values(N'1261')insert into @p3 values(N'1277')insert into @p3 values(N'1279')insert into @p3 values(N'1289')select * from @p3 -->> isee that there is data in @p3 execute sp_executesql N'exec casp_GetExist',N'@BLMJ_LIST CampaignIdList READONLY',@p3[/code]when i run the code that i take from the profiler, and i expect for resultfrom the query : Select * from @BLMJ_LISTi get no rows as result.any idea why?Wed, 20 Feb 2013 05:09:26 GMTpeleg