Thanks to all who tried to help.

I figured it out. I didn't mention that I was working in a Dynamics CRM environment (because I didn't think it mattered) but it...

Mike, thanks for the suggestion. I...

RBarryYoung (9/24/2013)

---

You should use the SQL Profiler to see what's really happening on your SQL server when it's called from C#. In all likelihood, there's some unexpected difference at...

Okay then, that's great. How are you defining your C# parm?

AndrewSQLDBA (9/24/2013)

---

Have you tried to just run a query:

SELECT

GroupId

, GroupName

, FileTypeName

, SubjectID

FROM

dbo.MyTable

WHERE

SubjectId =...

Yes, that query returns 1 row.

Yes, to all questions.

The field I am comparing the parameter to is defined as uniqueidentifier and contains a Guid.

The sproc now reads, in part:

where filetypename = 'Enrollment' and

SubjectId =...

Yes, to all questions. No rows returned.

Here is what the sproc looks like now:

ALTER procedure [dbo].[ce_GetBySubjectId]

(@SubjectIdString nvarchar(550))

as

begin

set nocount on

Select GroupId, GroupName from dbo.MyTable

where filetypename = 'Enrollment' and...

Andrew, the method was originally written to handle two stored procedures. The method works for the other sproc. The connectionstring is fine.

You do not need to Open...

Thanks for responding, Mike. Yes, the original method call passes in the name of the stored procedure and the value of the parameter.

private DataSet dsList(String connectionString, String sSprocName, String...

Thanks for responding, Andrew. I just forgot to copy the "End".

No, I am not allowing null input and the null reference was not originally there. I added it during my...

The rest of the code is:

DataSet ds = new DataSet();

try

...

This was a good demo and it taught me something I didn't know. Minor error: your end point for the code for the digits is incorrect:

"Ascii Codes 48 thru...

I am female and have been programming/developing/analyzing systems since the mid-1970's. I won my current position by being selected by a male manager from among a large group of interviewees,...

For my purposes, all params will be strings.

Gosta, thank you for your comments.

I will try Stephen's solution with your variation as soon as I can. I'm in the middle of something else right now, but first thing...