Last post Apr 17, 2006 10:01 AM by exptrade2000
Apr 17, 2006 10:01 AM|exptrade2000|LINK
Hi, I have been using SqlHelper in all my projects, and now i have really weird problem. On one table two of the columns return Nothing in no matter what I do. I tried dropping the tables, recreating sp and what not. Funny thing is that it works from let's
say Snippet compiler but in my ap it sets these columns to nothing. Code is the same and they reference the same dll's and the same dbs. I actually copied code from my app to Snippet compiler and it works. This is driving me crazy. Anybody has any suggestions?
This is the table:
/****** Object: Table [dbo].[IC_ISD_Setting] Script Date: 04/17/2006 09:01:29 ******/
and this is a sp that retrives the data
Executing this in query window works fine but if I do
ds = SqlHelper.ExecuteDataset(_connectionString, CommandType.StoredProcedure, "usp_IC_ISD_Setting_Get")
and look at
isd_id and time_id are set to Nothing.
However I take this piece of code to snippet compiler and it works as expected.