Session variable as a SqlParameter

Question

I've got this all except for my...

cmd.Parameters["@CAssetID"].Value.ToString();

Line of code where I am trying to assign the session variable to SqlParameter to pass it in to a stored procedure. I just can't seem to get the syntax right. I've tried several different things here is my last attempt.

SqlConnection RejectConnecton = new SqlConnection("Data Source=GBAPTCCSR01;Initial Catalog=CInTracDB;Integrated Security=True");
SqlCommand cmd = new SqlCommand();
SqlDataReader reader;

cmd.CommandText = "usp_RejectSubmission";
cmd.Parameters["@CAssetID"].Value.ToString();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = RejectConnecton;

RejectConnecton.Open();
reader = cmd.ExecuteReader();
RejectConnecton.Close();

Thanks for any help you can offer!

What session variable? There's no session variable there. You're converting the value of a parameter (that isn't there) to a string and discarding it. What session variable? — 15ee8f99-57ff-4f92-890c-b56153
– 15ee8f99-57ff-4f92-890c-b56153, Commented Nov 7, 2016 at 17:31
This line does nothing: cmd.Parameters["@CAssetID"].Value.ToString(); is that where you're trying to set the value? — D Stanley
– D Stanley, Commented Nov 7, 2016 at 17:31
Change cmd.Parameters["@CAssetID"].Value.ToString(); to cmd.Parameters.Add(new SqlParameter("@CAssetID", Session["MySessionVar"])); - may need a little tweaking based on your session variable. — Darren Wainwright
– Darren Wainwright, Commented Nov 7, 2016 at 17:33

mybirthname · Accepted Answer · 2016-11-07 17:36:05Z

2

cmd.Parameters.AddWithValue("@CAssetID", Session["YourSessionParamName"]);

answered Nov 7, 2016 at 17:36

mybirthname

18.2k3 gold badges35 silver badges59 bronze badges

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

1 Comment

Ken Carter Over a year ago

The exact final code was:......cmd.Parameters.AddWithValue("@CAssetID",Session["CAssetID"]); Thanks to all for the responses and mybirthname nailing it. I could have sworn I was there before but I must have had something crosseyed. Works perfect!

Collectives™ on Stack Overflow

Session variable as a SqlParameter

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related