Use stored procedure with C# (web part)
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