Passing 2 variables as criteria in a stored procedure

Question

Hello I have created a stored procedures with 2 where criteria. How can i pass two parameters to a stored procedure as criteria from c# coding? Thank you in advance.

Roei Bar · Answer

hey there well there are 2 options which i will show in the following code sample: using (SqlConnection connection = new SqlConnection(connectionString)) { SqlCommand command = new SqlCommand(commandText connection); // in this whay we need to declare the SQLDBType in // advance command.Parameters.Add( @ID  SqlDbType.Int); command.Parameters[ @ID ].Value = customerID; // Use AddWithValue to assign Demographics. // SQL Server will implicitly convert strings into XML. command.Parameters.AddWithValue( @demographics  demoXml); try { connection.Open(); Int32 rowsAffected = command.ExecuteNonQuery(); Console.WriteLine( RowsAffected: {0}  rowsAffected); } catch (Exception ex) { Console.WriteLine(ex.Message); }

Dealy · Answer

I solved the error i was trying to pass a textbox instead of a string (silly me!!) Thanks for all the help :)

Dealy · Answer

I get the following error any ideas what that means? No mapping exists from object type System.Web.UI.WebControls.TextBox to a known managed provider native type.

Roei Bar · Answer

yep just make sure that the SP parameters match those in your code and that the parameters order and count is the same also like command.Parameters.AddWithValue( @demographics  demoXml); command.Parameters.AddWithValue( @demographics2  demoXml); command.Parameters.AddWithValue( @demographics3  demoXml); means that you have 3 parameters in your SP in that order : @demographics Xml @demographics2 Xml @demographics3 Xml hope this helps

Dealy · Answer

First of all thank you for the answer. So with your code i pass @parameters ID and @demographics into my stored procedure? And if i want to pass more than 2 i just add this line of code with the variables i need? command.Parameters.AddWithValue( @demographics  demoXml);