Tuesday, July 29, 2014

Stored procedure runs fine from SSMS but fails when called from the C# app


So what is oParam.fillDt?


David




David http://ift.tt/1c5QNcs



Sorry wasn't clear on that. I use a wrapper to call basic ADO.Net commands such as dataAdapter.Fill(dt).


In this case the dataAdapter.SelectCommand has its cmd.CommandText = "usp_RebuildIndexes", so it just invokes the SP and receives back, in the datatable, any returned messages/prints.


No comments:

Post a Comment