ASP.NET

27-Jun-06 6:24

I've read some previous posts but am a bit confused. (Imagine that...) I have a webpage in an asp.net application in which the user enters a part number in a textbox.
strPartNumberInputReference = txtPartNumberInput.Text;

What I want to do is make this a session variable so that other pages can access this number. Basically the second web page will load data based on that part number entered.

Where within the code do I do this? Do I just put it in the first page? Within which function? Can I just do Session ["ptNum"] = strPartNumberInputReference and use it in the other pages. (I assume not as this doesn't seem to be working.) If I do the session in a function, does it have to be a public function?

As always, big thanks.

Re: How to get session variable to work [modified]

WebWeaver102127-Jun-06 6:59

WebWeaver1021

27-Jun-06 6:59

You may need to check your IIS settings to make sure session variables are enabled. Also check for session pooling for sessions to persist throughout the webspace. I have to believe that it must be a global setting in IIS.

Elina Blank27-Jun-06 7:55

27-Jun-06 7:55

leckey wrote:
If I do the session in a function, does it have to be a public function?

No, you can do it in any function you want, in any page you want.
When you retrieve your object from session, be sure to cast it, as it is returned back as object

Sincerely,
Elina

Life is great!!!
Enjoy every moment of it! Blush | :O

-- modified at 9:04 Wednesday 28th June, 2006

leckey27-Jun-06 8:20

27-Jun-06 8:20

Elina Blank wrote:
be sure to cast it, as it is returned back as string

Could you give me an example of what you mean?

Thanks!

Elina Blank27-Jun-06 8:26

27-Jun-06 8:26

Sure.
Here you are:
MyObjectType myObj = (MyObjectType)Session[myObjSessionIndex]

Sincerely,
Elina

Life is great!!!
Enjoy every moment of it! Blush | :O

leckey27-Jun-06 8:55

27-Jun-06 8:55

Okay, so something like this?
string strPartNum = (string)Session(what the heck would my index be? Don't I give it a name or something in parenthesis?)

Thanks again for your help!

Elina Blank27-Jun-06 8:59

27-Jun-06 8:59

your index is the name in of your variable.

Store object in session
Session[name] = object

Retrieve from session

object = Session[name].ToString()

name is any string variable
ex:
name= "myObjectSessionKey";

Sincerely,
Elina

Life is great!!!
Enjoy every moment of it! Blush | :O

leckey28-Jun-06 4:14

28-Jun-06 4:14

Okay, I don't think I'm doing this right. In my first .aspx.cs page I declared:

private void Page_Load(object sender, System.EventArgs e)<br />
		{<br />
			Session["ptNum"] = strPartNumberInputReference;<br />
			if (Page.IsPostBack)<br />
			{<br />
				<br />
				BindData();<br />
			}<br />
		}

In the second aspx.cs page I did:

Session["test"] = object;<br />
			object = Session["test"].ToString();

But the compiler doesn't like object just hanging out like that. What am I missing?

Elina Blank28-Jun-06 4:46

28-Jun-06 4:46

leckey wrote:
Session["test"] = object;
object = Session["test"].ToString();

What type is your object?
try
object = (myObjectType)Session["test"];

Sincerely,
Elina

Life is great!!!
Enjoy every moment of it! Blush | :O

leckey28-Jun-06 5:23

28-Jun-06 5:23

I placed the following in the second .aspx.cs page:
object = (string)Session["test"];

I get the error "identifier expected"

Elina Blank28-Jun-06 5:30

28-Jun-06 5:30

Can you send code snippet, please?

Sincerely,
Elina

Life is great!!!
Enjoy every moment of it! Blush | :O

leckey28-Jun-06 5:31

28-Jun-06 5:31

No problem! Here is page one aspx.cs:

protected string strPartNumberInputReference;<br />
.<br />
.<br />
.<br />
<br />
private void Page_Load(object sender, System.EventArgs e)<br />
		{<br />
			Session["ptNum"] = strPartNumberInputReference;<br />
			if (Page.IsPostBack)<br />
			{<br />
				<br />
				BindData();<br />
			}<br />
		}

Page 2 code behind:

private void Page_Load(object sender, System.EventArgs e)<br />
		{<br />
			object = (string)Session["ptNum"];<br />
			if (!Page.IsPostBack)<br />
			{<br />
				<br />
				BindData2();<br />
				test2 = txtTest.Text; <br />
			}<br />
		}

Elina Blank28-Jun-06 5:35

28-Jun-06 5:35

On which line the compiler complains?
Have you declared/initialized object variable?
But first check, that it is not a keyword?

Sincerely,
Elina

Life is great!!!
Enjoy every moment of it! Blush | :O

leckey28-Jun-06 5:55

28-Jun-06 5:55

Now the session variable is giving me a different problem

Basically what I'm trying to do: On the first page user enters a partnumber and the datagrid populates based on that partnumber. User goes to second page, second page already recognizes part number and populates a new grid based on that partnumber.

The BindData function for the first page works fine:

private void BindData()<br />
		{<br />
			strPartNumberInputReference = txtPartNumberInput.Text;<br />
			<br />
			<br />
						string SQLString = "SELECT w.weight, wt.Description AS wtDescription, p.PartNumber from weights w INNER JOIN weighttypes wt on wt.ID = w.weighttypeid INNER JOIN Parts p on w.PartID = p.ID WHERE p.PartNumber = @PartID"; <br />
			SqlCommand cmd = new SqlCommand();<br />
			cmd.Connection = new SqlConnection(strConnectSQL);<br />
			cmd.CommandText = SQLString;<br />
			cmd.Parameters.Add ("@PartID", strPartNumberInputReference);<br />
			SqlDataAdapter adapter = new SqlDataAdapter(cmd);<br />
			adapter.Fill(ds);<br />
			<br />
			dgParts.DataSource = ds;<br />
			dgParts.DataBind();<br />
<br />
		<br />
		}

Page Load where session variable is:

private void Page_Load(object sender, System.EventArgs e)<br />
		{<br />
			Session["ptNum"] = strPartNumberInputReference;<br />
			if (Page.IsPostBack)<br />
			{<br />
				<br />
				BindData();<br />
			}<br />
		}

So on the second page I have:

public string test2;<br />
private void Page_Load(object sender, System.EventArgs e)<br />
		{<br />
			test2 = (string)Session["ptNum"];<br />
			if (!Page.IsPostBack)<br />
			{<br />
				<br />
				BindData2();<br />
			; <br />
			}<br />
		}<br />
<br />
		private void BindData2()<br />
		{		<br />
			string SQLString = "SELECT w.weight, wt.Description AS wtDescription, p.PartNumber from weights w INNER JOIN weighttypes wt on wt.ID = w.weighttypeid INNER JOIN Parts p on w.PartID = p.ID WHERE p.PartNumber = @PartID";<br />
			SqlCommand cmd = new SqlCommand();<br />
			cmd.Connection = new SqlConnection(strConnectSQL);<br />
			cmd.CommandText = SQLString;<br />
			cmd.Parameters.Add ("@PartID", test2);<br />
			SqlDataAdapter adapter = new SqlDataAdapter(cmd);<br />
			adapter.Fill(ds2);			<br />
			ds2.Tables[0].TableName = "Weights";<br />
			dgWeights.DataSource = ds2;<br />
			dgWeights.DataBind();<br />
			//txtPartNumberInput.Text = "";<br />
		<br />
		}

But I'm getting the error:

Prepared statement '(@PartID nvarchar(4000))SELECT w.weight, wt.Description AS wtDes' expects parameter @PartID, which was not supplied

I'm trying to pass the test2 as the parameter which should be the strInputNumberReference from page 1.

So I think I still have something incorrect.

Again, thank you SOOO much for helping me with this!

Elina Blank28-Jun-06 6:01

28-Jun-06 6:01

You are welcome.
Check with the debugger, where exactly you fall down.
Unfortunatelly, I have to do my staff now.
Can not figure out the problem straight.
Just one thing: shouldn't you specify command type? Text/SP

Sincerely,
Elina

Life is great!!!
Enjoy every moment of it! Blush | :O

Elina Blank28-Jun-06 5:31

28-Jun-06 5:31

One more note
"object" is a keyword, if I remember it correctly

Sincerely,
Elina

Life is great!!!
Enjoy every moment of it! Blush | :O

Guffa27-Jun-06 8:52

Guffa

27-Jun-06 8:52

Elina Blank wrote:
When you retrieve your object from session, be sure to cast it, as it is returned back as string

Well, actually not a string, but an object.

---
b { font-weight: normal; }

Elina Blank27-Jun-06 8:57