ASP.NET

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 />
		}

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

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 />
		}

Elina Blank wrote:

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

protected void SetPersonalizationDirty ()

public class MyWebPartManager : WebPartManager
{
    public void ExSetPersonalizationDirty()
    {
        SetPersonalizationDirty();
    }
}