Hi Experts:
I met a problem when trying to pass two parameters to SQL storedprocedure in C# programme.
Here is the definition of the storedprocedure:
CREATE PROC product_proc;1
(@d_salary int,@u_salary int)
AS
IF @d_salary IS NULL
BEGIN
PRINT 'offer minimum salary'
RETURN -1
END
IF @u_salary IS NULL
BEGIN
PRINT 'offer maximum salary'
RETURN -2
END
IF @u_salary < @d_salary
BEGIN
PRINT 'maximum salary<minimum salary!'
RETURN -3
END
IF NOT EXISTS (SELECT * FROM Product WHERE price BETWEEN @d_salary AND @u_salary)
BEGIN
PRINT 'No records!'
RETURN -100
END
SELECT * FROM Product WHERE price>@d_salary AND price<@u_salary
RETURN 0

How to pass the two parameters "d_salary " and "u_salary" in C# programme?
part of the C# programme:

//Specific SQL Server-specific connection string
            SqlConnection thisConnection = new SqlConnection("Server=ERIC;Integrated Security=True;DataBase=pubs");

            //Open connection
            thisConnection.Open();

            //Create command for this connection
            SqlCommand thisCommand = thisConnection.CreateCommand();
            thisCommand.CommandType = CommandType.StoredProcedure;
            thisCommand.CommandText = "product_proc";

Thanks for your kind help
Eric

ERIC

__________________
ERIC

hi
for each variable in your store procedure you might write flowing code

thisConnection.Parameters.ADD("@variable Name",SqlDbType,variable size ).Value=<value for variable>

kiani,mehdi

great appreciation,angelboy!I've got it done!

ERIC

you ae wellcome
anouther way eseaier than previuse way that i saied is :

sqlCommandName.Parameters.AddWithValue('@variableN ame',<variable value>)

enjoy it
regards
kiani,mahdi