Inserting Parameters, C#, T-Sql

Posted by jpavlov on Stack Overflow See other posts from Stack Overflow or by jpavlov
Published on 2011-01-16T01:45:24Z Indexed on 2011/01/16 1:53 UTC
Read the original article Hit count: 515

Filed under:
|

I am trying to insert a parameter through an aspx page via text box. I set my parameters up, but evertime I executenonquery, the @Username shows up in the database instead of the actual value. Below is my code. Can anyone shed a little insight?

            SqlParameter @UserName = new SqlParameter("@UserName", System.Data.SqlDbType.VarChar);
            @UserName.Direction = ParameterDirection.Input;
            @UserName.Value = txtUserName.Text;

cmd.Parameters.Add(@UserName);

© Stack Overflow or respective owner

Related posts about c#

Related posts about tsql