Simon 0

Simon 0

  • NA
  • 3
  • 0

Use stored procedure with C# (web part)

Mar 7 2006 6:07 AM
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