不同业面传值与搜索

页面一

protected void ImageButton1_Click(object sender, ImageClickEventArgs e)   

{      

  if (this.TextBox1.Text.Trim() == "")   

     {         

   Response.Write("<script>alert(/"请输入要搜索的关键字！/");</script>");    

    }        else    

    {       

     Session["Sostring"] = this.TextBox1.Text.Trim();     

       if (this.DropDownList1.SelectedItem.Text == "同学姓名")   

         {            

    Response.Redirect("~/windows/so/soXM.aspx");       

     }       

     else         

   {            

    Response.Redirect("~/windows/so/soXX.aspx");      

      }    

     }

  页面二

private SqlConnection con;  

  protected void Page_Load(object sender, EventArgs e)   

 {       

 con = new SqlConnection("server=.;uid=sa;pwd=wojiushixihuan;database=studb");      

  con.Open();      

  string str = Session["Sostring"].ToString();    

    //Response.Write(str);     

   SqlDataAdapter da = new SqlDataAdapter("select schoolname as 学校,schoolurl as 学校地址 schoolJJ as 学校简介 from School where schoolname like '%" + str + "%'", con);     

   DataSet ds = new DataSet();     

   da.Fill(ds, "users");    

    if (ds.Tables["users"].Rows.Count > 0)   

     {       

     this.GridView1.DataSource = ds.Tables[0];  

          this.GridView1.DataBind();      

   }      

  else      

  {          

  //this.GridView1.EmptyDataText = "ovjjdsdfsd";       

     this.GridView1.Visible = false;  

          this.Label1.Visible = true;    

    }   

  }