user con't entered the parameter value in reportviewer refers to ssrs report

See more:

reporting-services

I have reportview refers to ssrs report in this report I have 3 parameter one of them take it value from query string and others take the value by users entered the problem is : after the user put the value for 2 parameter (not from query string) the parameter become empty when click the view report i put this code in page load

try { x = Request.QueryString[0]; SqlConnection co = new SqlConnection("Data source=myData source; Initial Catalog =mydatabase;User ID=sa;password=mypassword"); SqlCommand sqlCMD; SqlDataReader reader; co.Open(); sqlCMD = new SqlCommand("SELECT * FROM admin WHERE username ='" + x + "'", co); reader = sqlCMD.ExecuteReader(); if (reader.HasRows) {while (reader.Read()) {USER_CODE1 = reader["Role"].ToString(); if (USER_CODE1 == "2") { ReportParameter p = new ReportParameter("Parameter1", x); ReportViewer1.ServerReport.SetParameters(new ReportParameter[] { p }); ReportViewer1.ServerReport.Refresh(); } else { } } } reader.Close(); } catch (Exception o) { } 

any help plz