Passing a string variable to AddWithParameters method

Question

I want to insert a query and I want to pass the logged in User ID as a parameter, the UserID is a string.

I tried to do this:

  SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=project;Integrated Security=true;");
            var userId = User.FindFirstValue(ClaimTypes.NameIdentifier);
            
            SqlCommand cmd = new SqlCommand("INSERT INTO Invoice VALUES (SYSDATETIME(),'@id',0)");
           cmd.Connection= con;
            con.Open();
            cmd.Parameters.Add("@id",userId);
            cmd.ExecuteNonQuery();
            con.Close();

I am getting an error on cmd.Parameters.Add("@id",userId); that the userId needs to be of the data type "SqlDbType". How could I pass this var?

Sean · Accepted Answer · 2020-07-03 11:01:41Z

1

You can't set the value directly when adding a parameter, and the Add overload that takes 2 parameters required the name of the parameter and it's type. You can either do this:

var p = cmd.Paramaters.Add("@id", SqlDbType.VarChar);
p.Value = userId;

Or:

cmd.Paramaters.Add("@id", SqlDbType.VarChar).Value = userId;

answered Jul 3, 2020 at 11:01

Sean

62.8k11 gold badges101 silver badges138 bronze badges

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

Collectives™ on Stack Overflow

Passing a string variable to AddWithParameters method

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related