How can I add a parameter with just 1 line?

All the examples I see use 3 like the code below.

It gets very annoying when you have lots of parameters.



// Add Parameters to SPROC

SqlParameter parameterLastname = new SqlParameter

("@lname",SqlDbType.NVarChar, 50);

parameterLastname.Direction = ParameterDirection.Output;

myCommand.Parameters.Add(parameterLastname);



-Thanks

See http://www.aspalliance.com/stevesmith/articles/dotnetdataaccess.asp

which has a pMaker function for one line Parameter making.



Steve



----- Original Message -----

From: "Mike Samaras" <michaels@r...>

To: "aspx_beginners" <aspx_beginners@p...>

Sent: Thursday, September 20, 2001 9:40 PM

Subject: [aspx_beginners] Stored Procedure Parameters





> How can I add a parameter with just 1 line?

> All the examples I see use 3 like the code below.

> It gets very annoying when you have lots of parameters.

>

> // Add Parameters to SPROC

> SqlParameter parameterLastname = new SqlParameter

> ("@lname",SqlDbType.NVarChar, 50);

> parameterLastname.Direction = ParameterDirection.Output;

> myCommand.Parameters.Add(parameterLastname);

>

> -Thanks