C# Sqlparameter add

Question

i have a class for my sql duety, and have problem for my how could i do something like this

SqlParameter storedparam = new SqlParameter();
SqlParameter param1 = new SqlParameter("@userid", SqlDbType.BigInt);
param1.Value = "87";
SqlParameter param2 = new SqlParameter("@ip",SqlDbType.VarChar,40);
param2.Value = "192.168.1.1";
storedparam = param1 + param2;  //this parth have problem
Db myobject = new Db(myconection);
myobject.writestoredpro("nameofsotred",storedparam )

Answer 1

In the sql duety, take in params SqlParameter[] like so:

public void WriteStoredProcedure( string Query, params SqlParameter[] SqlParameters ) {
    // do it
}

For cases where you're defining a parameter and want to run it in one go, you can also define it like so:

SqlParameter storedParam = new SqlParameter("@ip",SqlDbType.Varchar,40) {
    Value = "192.168.1.1"
};