session variable and aspx problem

Question

my Customer_TotalSales.aspx page have 4 control such as.....DropdownList1,DropdownList2,Datepicker1,Datepicker2 and 1 button

button_click event code of Customer_TotalSales.aspx are below...

protected void Button1_Click1(object sender, EventArgs e)

{

Session["@FromCustomerName"] = DropDownList1.SelectedValue;

Session["@ToCustomerName"] = DropDownList2.SelectedValue;

Session["@FromDate"] = DatePicker1.SelectedDate;

Session["@ToDate"] = DatePicker2.SelectedDate;

Response.Redirect("SessionVariable.aspx");

}

Another aspx SessionVariable.aspx its have 4 lable control which hold the session variable value and pass these value to crystal report Viewer control...

public partial class SessionVariable : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

LabFromCustomer.Text = Session["@FromCustomerName"].ToString();

LabToCustomer.Text = Session["@ToCustomerName"].ToString();

LabFromDate.Text = Session["@FromDate"].ToString();

LabToDate.Text = Session["@ToDate"].ToString();

CrystalReportViewer1.Visible = false;

CrystalReportViewer1.Visible = true;

CrystalReportSource1.Report.FileName = Server.MapPath("Reports/Customer_totalsalesTest.rpt");

ParameterDiscreteValue objDiscreteValue;

ParameterField objParameterField;

//Set value for first parameter.....

objDiscreteValue = new ParameterDiscreteValue();

objDiscreteValue.Value = LabFromDate.Text;

objParameterField = CrystalReportViewer1.ParameterFieldInfo["@FromDate"];

objParameterField.CurrentValues.Add(objDiscreteValue);

CrystalReportViewer1.ParameterFieldInfo.Add(objParameterField);

objParameterField = CrystalReportViewer1.ParameterFieldInfo["@ToDate"];

//Set value for second parameter......

objDiscreteValue = new ParameterDiscreteValue();

objDiscreteValue.Value = LabToDate.Text;

objParameterField.CurrentValues.Add(objDiscreteValue);

CrystalReportViewer1.ParameterFieldInfo.Add(objParameterField);

//Set value for Third parameter......

objDiscreteValue = new ParameterDiscreteValue();

objDiscreteValue.Value = LabFromCustomer.Text;

objParameterField = CrystalReportViewer1.ParameterFieldInfo["@FromCustomerName"];

objParameterField.CurrentValues.Add(objDiscreteValue);

CrystalReportViewer1.ParameterFieldInfo.Add(objParameterField);

objDiscreteValue = new ParameterDiscreteValue();

objParameterField = CrystalReportViewer1.ParameterFieldInfo["@ToCustomerName"];

objDiscreteValue.Value = LabToCustomer.Text;

objParameterField.CurrentValues.Add(objDiscreteValue);

CrystalReportViewer1.ParameterFieldInfo.Add(objParameterField);

CrystalReportViewer1.ReportSourceID = "CrystalReportSource1";

}

when i Execute First page then asking for 4 value DropdownList1,DropdownList2,Datepicker1,Datepicker2 ..i choose these value when i click button then SessionVariable.aspx execute and show the crystal report everything working nice till now ...

when i want change the value of parameter then i need to close the page and Re-Execute the page ........

please help me ...how can i Changed the parameter value to change theese value DropdownList1,DropdownList2,Datepicker1,Datepicker2 in one time execution.....whats i edit in my code for that.......

Bryian Tan · Answer

Hello Are you trying to open the page on a new window? if that the case try something like: add this markup on top of function OpenPage(var1) { window.open(var1 New Page resizable=1 width=100height=100); } and protected void Button1_Click1(object sender EventArgs e) { Random rnd = new Random(); Session[@FromCustomerName] = null; Session[@ToCustomerName] = null; Session[@FromDate] = null; Session[@ToDate] = null; Session[@FromCustomerName] = DropDownList1.SelectedValue; Session[@ToCustomerName] = DropDownList2.SelectedValue; Session[@FromDate] = DatePicker1.SelectedDate; Session[@ToDate] = DatePicker2.SelectedDate; // Response.Redirect(SessionVariable.aspx?r= + rnd.Next(1000 999999).ToString()); string strURL =  SessionVariable.aspx ?r= + rnd.Next(1000 999999).ToString(); Page.ClientScript.RegisterStartupScript(this.GetType() somekey  OpenPage (' + strURL + '); true); } The Button1.Attributes.Add.. will execute the client side code first which is the window.open  but the Session value on the server side is not available yet and it will cause null exception error on SessionVariable.aspx page. So what we doing now is set the session variable first and then open a new window through the JavaScript. Hope that help. Thanks Bryian Tan

Bryian Tan · Answer

hello I think that caused by the browser cache. To bypass that include a QueryString with different value for each request. For instance protected void Button1_Click1(object sender EventArgs e) { Random rnd = new Random(); Session[@FromCustomerName] = null; Session[@ToCustomerName] = null; Session[@FromDate] = null; Session[@ToDate] = null; Session[@FromCustomerName] = DropDownList1.SelectedValue; Session[@ToCustomerName] = DropDownList2.SelectedValue; Session[@FromDate] = DatePicker1.SelectedDate; Session[@ToDate] = DatePicker2.SelectedDate; Response.Redirect(SessionVariable.aspx?r= + rnd.Next(1000 999999).ToString()); } Thanks Bryian Tan

Bryian Tan · Answer

hello That kind of odd because the session should get over written by the new selected value the second time you click on the button. Anyway try setting the session to null before assigning them any value and see how it goes. Session[@FromCustomerName] = null; Session[@ToCustomerName] = null; Session[@FromDate] = null; Session[@ToDate] = null; Session[@FromCustomerName] = DropDownList1.SelectedValue; Session[@ToCustomerName] = DropDownList2.SelectedValue; Session[@FromDate] = DatePicker1.SelectedDate; Session[@ToDate] = DatePicker2.SelectedDate; Thanks Bryian Tan

vaquas khan · Answer

hi rekha mam i have two page first.aspx which have four control DropdownList1DropdownList2Datepicker1Datepicker2 ..and Button and code behind file is like.... first.aspx.cs.. protected void Button1_Click1(object sender EventArgs e) { Session[@FromCustomerName] = DropDownList1.SelectedValue; Session[@ToCustomerName] = DropDownList2.SelectedValue; Session[@FromDate] = DatePicker1.SelectedDate; Session[@ToDate] = DatePicker2.SelectedDate; Button1.Attributes.Add(onclick window.open('Second.aspx''''height=1000width=1000');return false); In Second.Aspx i have 4 lable control (hidden)which hold the value of session variable and pass crystal report desecrate value... Second.aspx.cs.... protected void Page_Load(object sender EventArgs e) { CrystalReportViewer1.Visible = false; LabFromCustomer.Text = Session[@FromCustomerName].ToString(); LabToCustomer.Text = Session[@ToCustomerName].ToString(); LabFromDate.Text = Session[@FromDate].ToString(); LabToDate.Text = Session[@ToDate].ToString(); CrystalReportViewer1.Visible = true; CrystalReportSource1.Report.FileName = Server.MapPath(Reports/Customer_totalsalesTest.rpt); ParameterDiscreteValue objDiscreteValue; ParameterField objParameterField; //Set value for first parameter..... objDiscreteValue = new ParameterDiscreteValue(); objDiscreteValue.Value = LabFromDate.Text; objParameterField = CrystalReportViewer1.ParameterFieldInfo[@FromDate]; objParameterField.CurrentValues.Add(objDiscreteValue); CrystalReportViewer1.ParameterFieldInfo.Add(objParameterField); objParameterField = CrystalReportViewer1.ParameterFieldInfo[@ToDate]; //Set value for second parameter...... objDiscreteValue = new ParameterDiscreteValue(); objDiscreteValue.Value = LabToDate.Text; objParameterField.CurrentValues.Add(objDiscreteValue); CrystalReportViewer1.ParameterFieldInfo.Add(objParameterField); //Set value for Third parameter...... objDiscreteValue = new ParameterDiscreteValue(); objDiscreteValue.Value = LabFromCustomer.Text; objParameterField = CrystalReportViewer1.ParameterFieldInfo[@FromCustomerName]; objParameterField.CurrentValues.Add(objDiscreteValue); CrystalReportViewer1.ParameterFieldInfo.Add(objParameterField); objDiscreteValue = new ParameterDiscreteValue(); objParameterField = CrystalReportViewer1.ParameterFieldInfo[@ToCustomerName]; objDiscreteValue.Value = LabToCustomer.Text; objParameterField.CurrentValues.Add(objDiscreteValue); CrystalReportViewer1.ParameterFieldInfo.Add(objParameterField); CrystalReportViewer1.ReportSourceID = CrystalReportSource1; // CrystalReportViewer1.RefreshReport(); } when i Run First.aspx and pass the value to these control DropdownList1DropdownList2Datepicker1Datepicker2 .. and click the Button1 the pop up windows show the report according to my parameter...everything nice working till now ....but when i closed the pop up windows of report and again choose the another value of parameter and then click button1 but its give the previous value how can i solve this problem...............please help me....

Gaurish Kumar · Answer

Hi try this or use back button in your second page. protected void Button1_Click1(object sender EventArgs e) { Session[@FromCustomerName] = DropDownList1.SelectedValue; Session[@ToCustomerName] = DropDownList2.SelectedValue; Session[@FromDate] = DatePicker1.SelectedDate; Session[@ToDate] = DatePicker2.SelectedDate; LabFromCustomer.Text = Session[@FromCustomerName].ToString(); LabToCustomer.Text = Session[@ToCustomerName].ToString(); LabFromDate.Text = Session[@FromDate].ToString(); LabToDate.Text = Session[@ToDate].ToString(); CrystalReportViewer1.Visible = false; CrystalReportViewer1.Visible = true; CrystalReportSource1.Report.FileName = Server.MapPath(Reports/Customer_totalsalesTest.rpt); ParameterDiscreteValue objDiscreteValue; ParameterField objParameterField; //Set value for first parameter..... objDiscreteValue = new ParameterDiscreteValue(); objDiscreteValue.Value = LabFromDate.Text; objParameterField = CrystalReportViewer1.ParameterFieldInfo[@FromDate]; objParameterField.CurrentValues.Add(objDiscreteValue); CrystalReportViewer1.ParameterFieldInfo.Add(objParameterField); objParameterField = CrystalReportViewer1.ParameterFieldInfo[@ToDate]; //Set value for second parameter...... objDiscreteValue = new ParameterDiscreteValue(); objDiscreteValue.Value = LabToDate.Text; objParameterField.CurrentValues.Add(objDiscreteValue); CrystalReportViewer1.ParameterFieldInfo.Add(objParameterField); //Set value for Third parameter...... objDiscreteValue = new ParameterDiscreteValue(); objDiscreteValue.Value = LabFromCustomer.Text; objParameterField = CrystalReportViewer1.ParameterFieldInfo[@FromCustomerName]; objParameterField.CurrentValues.Add(objDiscreteValue); CrystalReportViewer1.ParameterFieldInfo.Add(objParameterField); objDiscreteValue = new ParameterDiscreteValue(); objParameterField = CrystalReportViewer1.ParameterFieldInfo[@ToCustomerName]; objDiscreteValue.Value = LabToCustomer.Text; objParameterField.CurrentValues.Add(objDiscreteValue); CrystalReportViewer1.ParameterFieldInfo.Add(objParameterField); CrystalReportViewer1.ReportSourceID = CrystalReportSource1; }

Rekha Singh · Answer

session variable ends when u close the page.. wat u can do is give a button on ur report page (Text as 'BACK')which navigates back to ur parameters page and in this button_click u can assign null values to ur session vaiables.. do let me know if any doubts.. ****************************************** Mark Accepted if u find it helpful

vaquas khan · Answer

hi gaurish its not working............... its return blank report.... please refer another way......my code is working well but when i try to another parameter then i have to run again.......

Gaurish Kumar · Answer

Hi why are you redirecting to another page. do code in first page like this: protected void Button1_Click1(object sender EventArgs e) { LabFromCustomer.Text = DropDownList1.SelectedValue.ToString(); LabToCustomer.Text = DropDownList2.SelectedValue.ToString(); LabFromDate.Text = DatePicker1.SelectedDate.ToString(); LabToDate.Text = DatePicker2.SelectedDate.ToString(); CrystalReportViewer1.Visible = false; CrystalReportViewer1.Visible = true; CrystalReportSource1.Report.FileName = Server.MapPath(Reports/Customer_totalsalesTest.rpt); ParameterDiscreteValue objDiscreteValue; ParameterField objParameterField; //Set value for first parameter..... objDiscreteValue = new ParameterDiscreteValue(); objDiscreteValue.Value = LabFromDate.Text; objParameterField = CrystalReportViewer1.ParameterFieldInfo[@FromDate]; objParameterField.CurrentValues.Add(objDiscreteValue); CrystalReportViewer1.ParameterFieldInfo.Add(objParameterField); objParameterField = CrystalReportViewer1.ParameterFieldInfo[@ToDate]; //Set value for second parameter...... objDiscreteValue = new ParameterDiscreteValue(); objDiscreteValue.Value = LabToDate.Text; objParameterField.CurrentValues.Add(objDiscreteValue); CrystalReportViewer1.ParameterFieldInfo.Add(objParameterField); //Set value for Third parameter...... objDiscreteValue = new ParameterDiscreteValue(); objDiscreteValue.Value = LabFromCustomer.Text; objParameterField = CrystalReportViewer1.ParameterFieldInfo[@FromCustomerName]; objParameterField.CurrentValues.Add(objDiscreteValue); CrystalReportViewer1.ParameterFieldInfo.Add(objParameterField); objDiscreteValue = new ParameterDiscreteValue(); objParameterField = CrystalReportViewer1.ParameterFieldInfo[@ToCustomerName]; objDiscreteValue.Value = LabToCustomer.Text; objParameterField.CurrentValues.Add(objDiscreteValue); CrystalReportViewer1.ParameterFieldInfo.Add(objParameterField); CrystalReportViewer1.ReportSourceID = CrystalReportSource1; } so whenever you will change the value of dropdown and datepicker control  it also changes the parameter value for crystal reports.

vaquas khan · Answer

hi Bryian Tan thanks lot.... its working very nicely................ thanks again.........

vaquas khan · Answer

hi bryian............ ya its working with Response.Redirect(SessionVariable.aspx?r= + rnd.Next(1000 999999).ToString());... can you tell me how to implement with Button1.Attributes.Add(onclick window.open(' SessionVariable.aspx ''''height=1000width=1000');return false); thanks bryian.....

vaquas khan · Answer

hi gaurish its not working.... Can anyone give me any example which solve my problem ...... thanks for your post..............

vaquas khan · Answer

hi bryian..... thank for your post ... but this is not working.................