javascript解析webserver返回的DataSet，DataTable，DataRow

最新推荐文章于 2021-11-19 11:19:51 发布

白云水涧

最新推荐文章于 2021-11-19 11:19:51 发布

阅读量708

点赞数

分类专栏： JavaScript asp.net Ajax 文章标签： dataset javascript webservice button function null

asp.net 同时被 3 个专栏收录

13 篇文章 0 订阅

订阅专栏

JavaScript

11 篇文章 0 订阅

订阅专栏

Ajax

2 篇文章 0 订阅

订阅专栏

1.首先先web.config中务必内含下列设置

<system.web.extensions> <scripting> <webServices> <jsonSerialization maxJsonLength="50000000"> <converters> <add name="DataSetConverter" type="Microsoft.Web.Preview.Script.Serialization.Converters.DataSetConverter, Microsoft.Web.Preview, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/> <add name="DataRowConverter" type="Microsoft.Web.Preview.Script.Serialization.Converters.DataRowConverter, Microsoft.Web.Preview, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/> <add name="DataTableConverter" type="Microsoft.Web.Preview.Script.Serialization.Converters.DataTableConverter, Microsoft.Web.Preview, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/> </converters> </jsonSerialization> </webServices> </scripting> </system.web.extensions>

其实maxJsonLength可以根据所要传输的数据量大小自行加大和减小~~~默认是500

2.在BIN文件夹中添加Microsoft.Web.Preview.dll的引用

配置好以后就可以使用了~~~

前台页面主要代码：

<body> <form id="form1" runat="server"> <asp:ScriptManager ID="ScriptManager1" runat="server"> <Scripts> </Scripts> <Services> <asp:ServiceReference Path="WebService.asmx" /> </Services> </asp:ScriptManager> <div align="center"> <span style="font-size: medium; font-weight: bold" mce_style="font-size: medium; font-weight: bold">输入客户编号：</span> <input id="Text1" type="text" /> <input id="Button1" type="button" value="查询返回DataSet" οnclick="GetDataSet()"/> <input id="Button2" type="button" value="查询返回DataTable" οnclick="GetDataTable()"/> <input id="Button3" type="button" value="查询返回DataRow" οnclick="GetDataRow()"/> <br /> <fieldset> <legend>查询结果</legend> <div id="resultcontent"> </div> </fieldset> <fieldset> <legend>全部客户信息<input id="Button4" type="button" value="显示全部客户信息" οnclick="GetAll()" /></legend> <div id="resultall"> </div> </fieldset> </div> </form> </body>

javascript代码：

webserver服务代码：

using System; using System.Collections; using System.Linq; using System.Web; using System.Web.Services; using System.Web.Services.Protocols; using System.Xml.Linq; using System.Data; using System.Data.SqlClient; using System.Web.Configuration; using System.Web.Script.Services; /** <summary> ///WebService 的摘要说明 /// </summary> [WebService(Namespace = "http://tempuri.org/")] [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)] //若要允许使用 ASP.NET AJAX 从脚本中调用此 Web 服务，请取消对下行的注释。 [System.Web.Script.Services.ScriptService] public class WebService : System.Web.Services.WebService { public WebService () { //如果使用设计的组件，请取消注释以下行 //InitializeComponent(); } [WebMethod] public DataSet GetDataSet(string id) { using (SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["Personal"].ConnectionString)) { DataSet dataset = new DataSet(); SqlDataAdapter adapter = new SqlDataAdapter("select [公司名称],[地址] from [客户] where [客户编号] = '"+id+"'",conn); adapter.Fill(dataset, "客户"); return dataset; } return null; } [WebMethod] public DataTable GetAll() { using (SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["Personal"].ConnectionString)) { DataSet dataset = new DataSet(); SqlDataAdapter adapter = new SqlDataAdapter("select [客户编号],[地址] from [客户]", conn); adapter.Fill(dataset, "客户"); DataTable datatable = dataset.Tables[0]; return datatable; } return null; } [WebMethod] public DataTable GetDataTable(string id) { using (SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["Personal"].ConnectionString)) { DataSet dataset = new DataSet(); SqlDataAdapter adapter = new SqlDataAdapter("select [公司名称],[地址] from [客户] where [客户编号] = '"+id+"'",conn); adapter.Fill(dataset, "客户"); DataTable datatable = dataset.Tables[0]; return datatable; } return null; } [WebMethod] public DataRow GetDataRow(string id) { // 取得 web.config 中的数据库联机字符串设定来创建 SQL 联机对象。 using (SqlConnection cn = new SqlConnection(WebConfigurationManager.ConnectionStrings["Personal"].ConnectionString)) { SqlCommand SQLCmd = cn.CreateCommand(); // 设定查询语句。 SQLCmd.CommandText = "select [公司名称],[地址] from [客户] where [客户编号] ='" + id + "'"; // 开启数据库连接并将数据读入数据读取器中。 cn.Open(); using (SqlDataReader dr = SQLCmd.ExecuteReader()) { if (dr.HasRows) { DataTable myTable = new DataTable("客户"); myTable.Load(dr, LoadOption.OverwriteChanges); return myTable.Rows[0]; } } } return null; } }

白云水涧

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
javascript解析webserver返回的DataSet，DataTable，DataRow

<br />1.首先先web.config中务必内含下列设置<br /><system.web.extensions> <scripting> <webServices> <jsonSerialization maxJsonLength="50000000"> <converters> <add name="DataSetConverter" type="Microsoft.Web.Preview.Script.Ser
复制链接

扫一扫

专栏目录