C# DLL calling stored procedure??

[Imagination]

Was wondering if someone could take the time to help me out. I'm trying to recreate a bunch of COM's i wrote in VB into C# (Visual Studio 2003, ours servers don't have 2.0+ framework yet). I've looked all over the web and i can't find any good/complete examples.

What would the code look like if I have a SQL Server on 192.168.0.1 and I wanted to pass 4 strings to a stored procedure on that server and then returned a OK or Failed back to a ASP?

Thanks if someone helps.....

 

[UCJefe]

It would look something like the following.

The technology that you want to search on and investigate is ADO.NET. You will get tons of hits once you know what to search for.