Forum Discussion

anatar02's avatar
anatar02
Contributor
14 years ago

Unable to fetching data from SQL server by using C#

Hi All, I have written the set of below code to fectching the data from sql server by using C#. Its executed successfully without any error but unfortunately  its not fetching any data from db...
tristaanogre's avatar
tristaanogre
Esteemed Contributor
14 years ago
The execute call returns a RecordSet object which is a list of records in a particular format for you to be able to traverse and pull out specific values.  So, when you are calling Log.Message(PRM), you're trying to log as a string an object that does not convert to a string.



I don't know C# syntax very well so excuse any syntax errors.  But if you want the value returned from your query, you should call something on the lines of 



Log["Message"](Prm.Fields(0).Value)