参数传递的问题
cer 2003-07-17 07:55:24 我的WEB服务程序如下:
<WebMethod()> Public Function findschool(ByVal xian As String, ByVal zhen As String) As String '加入学校的WEB服务
Try
Dim conn As SqlConnection = New SqlConnection(ConnStringAll)
Dim adapter As SqlDataAdapter
Dim mytable As DataTable
Dim ssql As String
Dim returnstr As String
ssql = "select * from userhouse where 所属市='" & CStr(Trim(xian)) & "' and 所属镇='" & CStr(Trim(zhen)) & "'"
conn.Open()
adapter = New SqlDataAdapter(ssql, conn)
mytable = New System.Data.DataTable("mydb")
adapter.Fill(mytable)
Dim i As Integer = 0
For i = 0 To mytable.Rows.Count() - 1
If returnstr = "" Then
returnstr = Trim(mytable.Rows(i)("学校名称"))
Else
returnstr = returnstr & "|" & Trim(mytable.Rows(i)("学校名称"))
End If
Next
Return returnstr
mytable.Clear()
conn.Close()
Catch ex As Exception
findschool = ex.ToString() & xian & zhen & ConnStringAll
End Try
End Function
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
我的xian和zhen内容是汉字的,返回时returnstr为空,但我用xian和zhen的实际内容代替ssql = "select * from userhouse where 所属市='" & CStr(Trim(xian)) & "' and 所属镇='" & CStr(Trim(zhen)) & "'" 中的xian和zhen后
使ssql="select * from userhouse where 所属市='蓬江区' and 所属镇='环市镇'"
查录的结果不为空,returnstr为一个字符串了我找了很久,有可能是,用javascript调用这个函数时,参数是汉字.
我的疑问就是:WEB服务的参是不是不能为汉字?如果用汉字怎么办?