Use stored procedure with C# (web part)

Question

Hi,

I have some C# code with a giant sql string in it, you cant miss it. This piece of code works and gets some data out of a database.

What I want to accomplish is the sql string out of my code, so i made a stored procedure.

The problem is that I dont know how I can use the stored procedure in my C# code, so that i get the same results as the sql string in my code does now. Can some one help me out?
Tnx in advance.


ps. I use MS sql server2000
 (mistakenly deleted my previous topic :/ )


EDIT--  Problem solved, i got it working-- EDIT