Hi,

I'm a newbie. I'm writing an application in C# and connect to SQL 2K server. How can I execute a stored procedure that needs 2 parameters and return a value back?

Thanks.

1_ Insert a Command in ur form.
2_ Set the CommandText to SP's name
ex: [u]Command1.CommandText = "dbo.[SP-Name]";</u>
3_ Set the CommandType to StoredProcedure;
ex: [u]this.CommGetDeputyInfo.CommandType = System.Data.CommandType.StoredProcedure;</u>
4_ Set Connection too;
ex: [u]Command1.Connection = this.NewBazConn;</u>
If u do these in Visual mode Visual Studio will ask u to insert Parameters in SP in ur Command!

HTH, let me know.

Always:),
Hovik Melkomian.