关于页面传值出现的奇怪问题，急等解决！！！！！！！！！！！

[wenfeng]

页面A
SqlStr="select 联系人名称=a.Name,职位=a.Duty,部门=a.Department,办公室电话=a.ColPhone,邮箱1=a.Email1,邮箱2=a.Email2,手机=a.MobilePhone,住宅电话=a.HomePhone,地址=a.Address,生日=a.Birthday,爱好=a.Love,相关的客户=b.name,是否归档=a.LinkManPigehole,是否关键人=a.keyman,记录所有者=c.Name, LinkManId from T_LinkMan as a,T_CCustomer as b,T_CWorker as c where a.CustomerId=b.CustomerId and a.WorkerID=c.WorkerID and a.HomePhone like"+"'%"+txbSearch.Text+"%'";
...
.....
Response.Redirect ("Findlink.aspx?Info="+this.SqlStr);

页面B
NameValueCollection collection;
collection=Request.QueryString ;
str=collection.GetValues ("Info");
string SqlStr=str[0];
publicSql publicSql1= new publicSql();
SqlConnection nwindConn = new SqlConnection(publicSql1.nwindConn );
nwindConn.Open();
SqlDataAdapter da=new SqlDataAdapter(SqlStr,nwindConn);
DataSet ds=new DataSet();
da.Fill(ds,SqlStr);
DataGrid1.DataSource =ds;
DataGrid1.DataKeyField=ds.Tables [0].Columns[18].Caption ;
DataGrid1.DataBind();


问题：
在页面A中传的Sql数据：
"select 联系人名称=a.Name,职位=a.Duty,部门=a.Department,办公室电话=a.ColPhone,邮箱1=a.Email1,邮箱2=a.Email2,手机=a.MobilePhone,住宅电话=a.HomePhone,地址=a.Address,生日=a.Birthday,爱好=a.Love,相关的客户=b.name,是否归档=a.LinkManPigehole,是否关键人=a.keyman,记录所有者=c.Name, LinkManId from T_LinkMan as a,T_CCustomer as b,T_CWorker as c where a.CustomerId=b.CustomerId and a.WorkerID=c.WorkerID and a.ColPhone like' %4567%'and a.WorkerId in (select WorkerId from T_CWorker where DepartmentId='1')"

在页面B中的接收的SQl数据为：
"select 联系人名称=a.Name,职位=a.Duty,部门=a.Department,办公室电话=a.ColPhone,邮箱1=a.Email1,邮箱2=a.Email2,手机=a.MobilePhone,住宅电话=a.HomePhone,地址=a.Address,生日=a.Birthday,爱好=a.Love,相关的客户=b.name,是否归档=a.LinkManPigehole,是否关键人=a.keyman,记录所有者=c.Name, LinkManId from T_LinkMan as a,T_CCustomer as b,T_CWorker as c where a.CustomerId=b.CustomerId and a.WorkerID=c.WorkerID and a.ColPhone like' E67%'and a.WorkerId in (select WorkerId from T_CWorker where DepartmentId='1')"

为什么传递前后Like后的数据会出现明显的错误？？

[lkk2073]

webconfig 里面是否有:
<?xml version="1.0" encoding="utf-8"?>

[kerry803]

UP

[storm97]

当然明显有错误了！%好是有特殊含义的在URL中，而且单引号也会引起自负的不完整，你传的时候这个用Session来解决吧！不要在B页面Request[]了！那样容易出问题。

[rgbcn]

不要用%号在url 中传递参数。