加入收藏 | 设为首页 | 会员中心 | 我要投稿 李大同 (https://www.lidatong.com.cn/)- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置: 首页 > 综合聚焦 > 服务器 > 安全 > 正文

前台调用WebServices的方法

发布时间:2020-12-17 02:01:26 所属栏目:安全 来源:网络整理
导读:当在解决方案/项目下新建WebServices时,会在AppCode文件夹内生成相对应的.cs类 一. 在.cs文件中写方法: ? 首先要将 [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)] 由注视状态释放掉。 ?? 目的:? //若要允许使用 ASP.NET AJAX 从脚本中调

当在解决方案/项目下新建WebServices时,会在AppCode文件夹内生成相对应的.cs类

一. 在.cs文件中写方法:
? 首先要将 [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)] 由注视状态释放掉。
?? 目的:? //若要允许使用 ASP.NET AJAX 从脚本中调用此 Web 服务,请取消对下行的注释。

? 写一个要使用的方法
[WebMethod]
??? //按不同的方式搜索书籍
??? public string[] GetSearchType(string prefixText,int count,string contextKey)
??? {
??????? SqlConnection conn = new SqlConnection("server=.;database=DB2DB;uid=sa;pwd=");
??????? string sqlStr = "";
??????? string key = "";
??????? switch (contextKey)
??????? {
??????????? case "0":
??????????????? key = "Book_Name";
??????????????? sqlStr = "select top " + count + " Book_Name from Books where Book_Name like '%" + prefixText + "%'";
??????????????? break;
??????????? case "1":
??????????????? key = "Book_Author";
??????????????? sqlStr = "select top " + count + " Book_Author from Books where Book_Author like '%" + prefixText + "%'";
??????????????? break;
??????????? case "2":
??????????????? key = "Book_Publicationda";? //按出版日期
??????????????? sqlStr = "select top " + count + " Book_Publicationda from Books where Book_Publicationda like '%" + prefixText + "%'";
??????????????? break;
??????????? case "3":
??????????????? key = "PublishName";? //按出版社
??????????????? sqlStr = "select top " + count + " PublishName from Books where PublishName like '%" + prefixText + "%'";
??????????????? break;
??????? }
??????? SqlCommand cmd = new SqlCommand(sqlStr,conn);
??????? SqlDataAdapter sda = new SqlDataAdapter(cmd);
??????? DataSet ds = new DataSet();
??????? sda.Fill(ds);

??????? int resultCount = ds.Tables[0].Rows.Count;
??????? string[] resultValue = new String[resultCount];
??????? for (int i = 0; i < resultCount; i++)
??????? {
??????????? string keywords =(string)(ds.Tables[0].Rows[i][key]);
??????????? resultValue[i] = keywords;
??????? }
??????? return resultValue;
??? }

二.前台代码:? <td style="PaDDING-LEFT: 3px" width="20">??????????????????? <asp:TextBox ID="key" runat="server" Text="" ></asp:TextBox>? ???????????????? ??????????????????? <Toolkit:TextBoxWatermarkExtender ID="TextBoxWatermarkExtender1" runat="server" TargetControlID="key" WatermarkText="请输入关键字">??????????????????? </Toolkit:TextBoxWatermarkExtender> ?????????????????? ??????????????????? <Toolkit:AutoCompleteExtender ID="AutoCompleteExtender1" runat="server"??????????????????? TargetControlID="key" ServicePath="~/WebServices/Booksearch.asmx"???????????????????? ServiceMethod="GetSearchType" MinimumPrefixLength="1" UseContextKey="true" ContextKey="0">??????????????????? </Toolkit:AutoCompleteExtender>?????? ? </td>

(编辑:李大同)

【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!

    推荐文章
      热点阅读