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 )

Without knowing what type of API writestoredpro is expecting, that is pretty much impossible to answer, What is writestoredpro ? And what is Db ? — Marc Gravell
– Marc Gravell, Commented Jan 10, 2013 at 12:22
@Mahyar your "simple example code" does nothing to explain what writestoredpro wants... — Marc Gravell
– Marc Gravell, Commented Jan 10, 2013 at 12:23

Soner Gönül · Accepted Answer · 2013-01-10 12:29:44Z

4

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"
};

edited Jan 10, 2013 at 12:29

Soner Gönül

99.1k103 gold badges224 silver badges375 bronze badges

answered Jan 10, 2013 at 12:24

robrich

13.3k7 gold badges39 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Christian Phillips · Accepted Answer · 2013-01-10 12:51:42Z

1

the 'writetostoredpro' method would need to take a collection of SqlParameter objects, and then inside the method, you would need to iterate over the collection adding them to the SqlCommand.Parameters property. Take a look at this link : http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.parameters.aspx of how to use the propertied, and SqlCommand class for an idea of what to do: http://msdn.microsoft.com/en-us/library/z4956bkc.aspx

answered Jan 10, 2013 at 12:51

Christian Phillips

18.8k8 gold badges55 silver badges85 bronze badges

Collectives™ on Stack Overflow

C# Sqlparameter add

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related