Last post Dec 09, 2010 03:04 AM by sachin.kapurkar
Dec 09, 2010 12:25 AM|ereko|LINK
Initially, I have tried to use stored procedure. But I changed my mind and preferred to call sql query in codebase with command text. However, it stills tries to find initially-called stored procedure (which is neither called or exists).
I think that it is related caching. But I tried it with different browsers it did not work.
What might be the reason?
Dec 09, 2010 01:19 AM|adeelehsan|LINK
It is better to use stored procedure but if you can post the code, I will be able to examine.
Dec 09, 2010 01:20 AM|suneeld|LINK
Check two things:-
1. CommandType of Sqlcommand should not be StoredProcedure
2. Ensure that you are not setting commandText to the property
Dec 09, 2010 01:23 AM|sansan|LINK
But I changed my mind and preferred to call sql query in codebase with command text
You might have not deleted the CommandType. Delete the line which says
Or set CommandType to text.
Dec 09, 2010 03:04 AM|sachin.kapurkar|LINK
'CommandType' for 'SqlCommand' should be 'CommandType.Text' for inline sql query.