sp_helpfile Execute

[betterc]

I'd like to be able to run the stored procedure sp_helpfile from within my C# program against my MSDE db. Is this possible? I haven't a clue on how to set up a structure to hold the results of the command. Any help would be appreciated. cb

[leppie]

Have a look at my most excellent tool, DBHelper ;p http://www.codeproject.com/cs/database/dbhelper.asp[^]

top secret AdvancedTextBox

[betterc]

I ran the demo and got "An exception 'System.Data.SqlClient.SqlException' has occured in SPTestApp.exe". cb

[Heath Stewart]

You do it just like I told you to do for the sp_attach_db stored procedure. Look at the SQL docs for the names of the parameters and use this in the SqlCommand.Parameters.Add method as I did with the other stored proc.

Microsoft MVP, Visual C# My Articles

[betterc]

Thanks for all of your help. I just didn't know how I 'captured' the return values. There is only one parameter to pass, the db. cb

[Heath Stewart]

Handle the SqlConnection.InfoMessage event. With each message printed by the server this event is raised. You can get the message from the SqlInfoMessageEventArgs that is passed to your handler.

Microsoft MVP, Visual C# My Articles