ASP.NET

string strQuery1="insert into tbl1(column) ";
string strQuery2="insert into tbl2(column2) ";

for (int i=1;ds.tables[0].rows.count;i++)
{
	strQuery1 = strQuery1 + " SELECT " +  ds.tables[0].Rows[0]["column1"].ToString() + " UNION ALL ";
	strQuery2 = strQuery2 + " SELECT " +  ds.tables[0].Rows[0]["column2"].ToString() + " UNION ALL ";
}

 protected void Page_Load(object sender, EventArgs e)
 {
     String Color;
     if (Request.QueryString["color"] != null)
     {
         Color = Request.QueryString["color"];
     }
 }

 protected void Button1_Click1(object sender, EventArgs e)
 {
     String URL = "Default.aspx?color=" + Server.UrlEncode("#FFFFFF");
     Response.Redirect(URL);
}

paper67 wrote:

if (!string.IsNullOrEmpty(Context.Request.QueryString["color"]))

protected void bRunReport_Click1(object sender, EventArgs e)
    {
        if (Page.IsValid)
        {
            divRptView.Controls.Clear();
            #region reportviewer setting
              
            
                ReportViewer ReportViewer1 = new ReportViewer();
           

                    ReportViewer1.ProcessingMode = ProcessingMode.Local;
                    ReportViewer1.ID = "ReportViewer1";
            
                    ReportViewer1.Font.Bold = false;
                    ReportViewer1.Font.Name = "Arial";
                    ReportViewer1.ShowExportControls = false;
                    ReportViewer1.ShowBackButton = false;
                    ReportViewer1.SizeToReportContent = true;
                    ReportViewer1.BackColor = System.Drawing.Color.WhiteSmoke;
            
                    ReportViewer1.LocalReport.DataSources.Clear();
           
            #endregion reportviewer setting
            
                
                //ReportDataSource ds = new ReportDataSource();
                string _reportID = string.Empty;
                bool isnull = true;
          
            #region snapshot
            else if (ddlListofReports.SelectedValue == "1")
            {
                _reportID = "snapshot";
                List<snapshot> slist = new snapshot().GetCustomersForCountry(this.ddljobsSnapshot.SelectedValue);
                ReportViewer1.LocalReport.ReportPath = "Admin\\ReportDesigns\\" + _reportID + ".rdlc";
                if (slist != null)
                {
                    if (slist.Count > 0)
                    {
                        ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("snapshot1", slist));
                        isnull = false;
                    }
                }
            }
            #endregion snapshot
            #region VoiceAgentUtilization
            else if (ddlListofReports.SelectedValue == "2")
            {
                DateTime _dcstarttime = Convert.ToDateTime(this.txtAgetnFromDate.Text);
                string _dcstarttimestr = _dcstarttime.ToLongDateString() + " " + _dcstarttime.ToLongTimeString();
                DateTime _dctotime = Convert.ToDateTime(this.txtAgentTodate.Text);
                _reportID = "VoiceAgentUtilization";
                List<AgentDetailed> alist = new AgentDetailed().getAgentReport(this.dcagent.SelectedItem.ToString(), _dcstarttime, _dctotime);
                ReportViewer1.LocalReport.ReportPath = "Admin\\ReportDesigns\\" + _reportID + ".rdlc";
                if (alist != null)
                {
                    if (alist.Count > 0)
                    {
                        ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("AgentDetailed1", alist));
                        isnull = false;
                        ReportParameter starttime = new ReportParameter("StartTime", _dcstarttimestr);
                        ReportParameter endtime = new ReportParameter("EndTime", _dctotime.ToString());
                        ReportParameter Agent = new ReportParameter("Agent", this.dcagent.SelectedItem.ToString());
                        ReportParameter[] p = { starttime, endtime, Agent };
                        ReportViewer1.LocalReport.EnableExternalImages = true;
                        ReportViewer1.LocalReport.SetParameters(p);
                    }
                }
            }
            #endregion VoiceAgentUtilization
          
           

            if (!isnull)
            {
                lblMessageBox.Visible = false;

                if (ddlListofReports.SelectedValue != "11")
                {
                    divRptView.Controls.Add(ReportViewer1);
                    ReportViewer1.Height = 290 + (25 * 10);
                    ReportViewer1.Width = Unit.Percentage(91);
                    ReportViewer1.ShowRefreshButton = false;
                    ReportViewer1.Visible = true;
                    ReportViewer1.ShowPrintButton = true;
                    ReportViewer1.SizeToReportContent = true;
                    ReportViewer1.LocalReport.Refresh();
                }

            }
            else
            {
                lblMessageBox.Visible = true;
                lblMessageBox.Text = "No Records are avaliable.";
                ReportViewer1.Visible = false;
            }
        }
    }