How to call Stored Procedures Parameters in List

amarnath reddy ambati

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("@Name",txtname.Text) ;

I want to call parameter in List then we insert the List value int Database.

Please Help me...

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Riddhi Valecha12y ago
Parameters in list as in - sending all the parameters at one time, instead of using multiple lines of -

cmd.parameters.addwithvalues("@abc","dre");
0
amarnath reddy ambati12y ago
Thank you... JS Banger
0
Joginder Banger12y ago
i also not try this type, your concept is good, i will try next time as per your think
0
Joginder Banger12y ago
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;
0