Passing Variables to sql command text-Newbe

[Mike]

Hello,
How do I pass variables to a command text.(C#)Becaus e of the quotes,it
seems that the values are not passed.
Thanks,
Mike

[Mark R. Dawson]

Hi Mike,
are you using a stored procedure or creating dynamic sql? If you are
using a stored procedure and using SQL Srver you can do something like:

SqlCommand command = new SqlCommand();
command.Command Text = "myStoredProced ureName";

//set the connection object
command.Connect ion = objConn;
command.Command Type = System.Data.Com mandType.Stored Procedure;

//create parameter and add it to the command
SqlParameter param = new SqlParameter("@ UserName",
System.Data.Sql DbType.VarChar, 30);
command.Paramet ers.Add(param);
If you are writing dynamic SQL then you could do something like:

string sqlCommand = "Select * from tblX WHERE UserName='" + userName + "'"
SqlCommand command = new SqlCommand(sqlC ommand, objConn);

Hope that helps
Mark R Dawson

"Mike" wrote:

Hello,
How do I pass variables to a command text.(C#)Becaus e of the quotes,it
seems that the values are not passed.
Thanks,
Mike