How to call Stored Procedures Parameters in List

Question

Dear All I want to call Stored Procedures Parameters in List instead of AddwithValue Method using SqlCommand Object. For Example: Generally we call a parameter using SqlCommand object cmd.Parameters.AddwithValue(@Nametxtname.Text) ; I want to call parameter in List then we insert the List value int Database. Please Help me...

Riddhi Valecha · Answer

Parameters in list as in - sending all the parameters at one time instead of using multiple lines of - cmd.parameters.addwithvalues(@abcdre);

amarnath reddy ambati · Answer

Thank you... JS Banger

Joginder Banger · Answer

i also not try this type your concept is good i will try next time as per your think

Joginder Banger · Answer

if you hate paramerts.addwithvalue then you are used sqlparameters like this type SqlParameter[] arParms = new SqlParameter[4]; arParms[0] = new SqlParameter(@UserName SqlDbType.VarChar 100); arParms[0].Value = UserName; arParms[1] = new SqlParameter(@password SqlDbType.VarChar 50); arParms[1].Value = strgivenpassword; arParms[2] = new SqlParameter(@succ SqlDbType.Int); arParms[2].Direction = ParameterDirection.Output; arParms[3] = new SqlParameter(@LoginID SqlDbType.Int); arParms[3].Direction = ParameterDirection.Output;