>>SET DELETE must be ON to get rid of deleted records.
>>
>>About formatting - I'm not yet sure - I believe ToString() has overloads allowing formatting or you can probably look at String.Format()
>
>That's what I meant. SET DELETED is ON. I still get deleted records. Is there a setting in NET?
>I have tried many variations of ToString() and Format() but can't seem to get the syntax right. {0:C} is supposed to do it but how to put it into the command line?
If you explicitly set deleted on in your SP, then I don't understand how would you get the deleted records back. Even if the connection has DELETED OFF, SP setting should have override this, I would assume.
For your format question I'm researching it. I quickly checked Convert class and ToString documentation in MSDN, but haven't found an example yet. I recall it in the C# book I had, but I don't have it now.
If it's not broken, fix it until it is.
My Blog