using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Web;
using?System.Web.UI;
using?System.Web.UI.WebControls;

using?System.Data.SqlClient;
using?System.Data;
using?System.Configuration;
using?System.Web.Configuration;
using?System.Text;

using?System.Web.Services;

namespace?jqueryproj_ADO
{
????public?partial?class?WebForm1?:?System.Web.UI.Page
????{
????????public?static?SqlConnection?myConnection?=?new?SqlConnection（WebConfigurationManager.ConnectionStrings[“ConnectionString“].ConnectionString）;
????????protected?void?Page_Load（object?sender?EventArgs?e）
????????{
????????????if?（!IsPostBack）
????????????{
????????????????//SelectInfo（）;
????????????????//Select1
????????????????//Select1.DataSourceID?=?“SqlDataSource1“;
????????????????//Select1.DataTextField?=?“CustomerID“;
????????????????//Select1.DataValueField?=?“CustomerID“;
????????????}

????????}
????????[WebMethod]
????????public?static?string?getSelectInfo（）?{
????????????string?sql?=?“select?*?from?CustomerInfo“;
????????????SqlCommand?myCommand?=?new?SqlCommand（sql?myConnection）;
????????????SqlDataAdapter?Adapter?=?new?SqlDataAdapter（）;
????????????Adapter.SelectCommand?=?myCommand;
????????????DataSet?myDs?=?new?DataSet（）;
????????????Adapter.Fill（myDs）;
????????????if?（myDs.Tables[0].Rows.Count?>?0）
????????????{
????????????????//return?DataTable2Json（myDs）;
????????????????return?DataTableTo2Json（myDs.Tables[0]）;
????????????????//return?“1“;
????????????}
????????????else
????????????????return?“0“;
????????}
????????public?static?string?DataTableTo2Json（DataTable?dt）
????????{
????????????StringBuilder?jsonBuilder?=?new?StringBuilder（）;
????????????jsonBuilder.Append（“{\““）;
????????????jsonBuilder.Append（dt.TableName）;
????????????jsonBuilder.Append（“\“:[“）;
????????????for?（int?i?=?0;?i?????????????{
????????????????jsonBuilder.Append（“{“）;
????????????????for?（int?j?=?0;?j?????????????????{
????????????????????jsonBuilder.Append（“\““）;
????????????????????jsonBuilder.Append（dt.Columns[j].ColumnName）;
????????????????????jsonBuilder.Append（“\“:\““）;
????????????????????jsonBuilder.Append（dt.Rows[i][j].ToString（））;
????????????????????jsonBuilder.Append（“\““）;
????????????????}
????????????????jsonBuilder.Remove（jsonBuilder.Length?-?1?1）;
????????????????jsonBuilder.Append（“}“）;
????????????}
????????????jsonBuilder.Remove（jsonBuilder.Length?-?1?1）;
????????????jsonBuilder.Append（“]“）;
????????????jsonBuilder.Append（“}“）;
????????????return?jsonBuilder.ToString（）;
????????}
????????[WebMethod]
????????public?static?string?toAddData（string?id?string?cname）
????????{
????????????string?result?=?null;
????????????myConnection.Open（）;
????????????string?str?=?“insert?into??CustomerInfo?values（“?+?id?+?“‘“?+?cname?+?“‘‘x1‘‘x2‘‘x3‘‘x4‘）“;
????????????SqlCommand?com?=?new?SqlCommand（str?myConnection）;
?????????

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-01-02?17:35??jqueryproj_ADO\
?????目錄???????????0??2018-01-02?17:35??jqueryproj_ADO\jqueryproj_ADO\
?????目錄???????????0??2018-01-02?17:35??jqueryproj_ADO\jqueryproj_ADO\Properties\
?????文件????????1330??2017-10-16?12:18??jqueryproj_ADO\jqueryproj_ADO\Properties\AssemblyInfo.cs
?????文件????????1245??2017-10-16?12:18??jqueryproj_ADO\jqueryproj_ADO\Web.Debug.config
?????文件????????1306??2017-10-16?12:18??jqueryproj_ADO\jqueryproj_ADO\Web.Release.config
?????文件?????????756??2017-10-16?12:56??jqueryproj_ADO\jqueryproj_ADO\Web.config
?????文件????????1220??2017-10-22?20:53??jqueryproj_ADO\jqueryproj_ADO\WebForm1.aspx
?????文件????????5270??2017-10-23?15:18??jqueryproj_ADO\jqueryproj_ADO\WebForm1.aspx.cs
?????文件?????????471??2017-10-16?13:03??jqueryproj_ADO\jqueryproj_ADO\WebForm1.aspx.designer.cs
?????目錄???????????0??2018-01-02?17:35??jqueryproj_ADO\jqueryproj_ADO\bin\
?????文件????????7680??2017-10-23?15:18??jqueryproj_ADO\jqueryproj_ADO\bin\jqueryproj_ADO.dll
?????文件?????????756??2017-10-16?12:56??jqueryproj_ADO\jqueryproj_ADO\bin\jqueryproj_ADO.dll.config
?????文件???????19968??2017-10-23?15:18??jqueryproj_ADO\jqueryproj_ADO\bin\jqueryproj_ADO.pdb
?????文件????????5427??2017-10-16?12:25??jqueryproj_ADO\jqueryproj_ADO\jqueryproj_ADO.csproj
?????文件????????1088??2017-10-23?10:30??jqueryproj_ADO\jqueryproj_ADO\jqueryproj_ADO.csproj.user
?????目錄???????????0??2018-01-02?17:35??jqueryproj_ADO\jqueryproj_ADO\js\
?????目錄???????????0??2018-01-02?17:35??jqueryproj_ADO\jqueryproj_ADO\js\jquery-1.8.3\
?????文件??????267739??2014-09-15?11:01??jqueryproj_ADO\jqueryproj_ADO\js\jquery-1.8.3\jquery.js
?????文件???????93637??2014-09-15?11:00??jqueryproj_ADO\jqueryproj_ADO\js\jquery-1.8.3\jquery.min.js
?????文件?????????119??2013-11-29?12:33??jqueryproj_ADO\jqueryproj_ADO\js\jquery-1.8.3\jquery插件庫.url
?????文件?????????111??2013-11-29?12:33??jqueryproj_ADO\jqueryproj_ADO\js\jquery-1.8.3\www.jq22.com.txt
?????文件????????6619??2017-10-23?15:18??jqueryproj_ADO\jqueryproj_ADO\js\my.js
?????目錄???????????0??2018-01-02?17:35??jqueryproj_ADO\jqueryproj_ADO\obj\
?????目錄???????????0??2018-01-02?17:35??jqueryproj_ADO\jqueryproj_ADO\obj\Debug\
?????文件????????9738??2018-01-03?09:24??jqueryproj_ADO\jqueryproj_ADO\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache
?????目錄???????????0??2018-01-03?10:48??jqueryproj_ADO\jqueryproj_ADO\obj\Debug\TempPE\
?????文件???????????0??2017-10-16?12:18??jqueryproj_ADO\jqueryproj_ADO\obj\Debug\TemporaryGeneratedFile_036C0B5B-1481-4323-8D20-8F5ADCB23D92.cs
?????文件???????????0??2017-10-16?12:18??jqueryproj_ADO\jqueryproj_ADO\obj\Debug\TemporaryGeneratedFile_5937a670-0e60-4077-877b-f7221da3dda1.cs
?????文件???????????0??2017-10-16?12:18??jqueryproj_ADO\jqueryproj_ADO\obj\Debug\TemporaryGeneratedFile_E7A71F73-0F8D-4B9B-B56E-8E70B10BC5D3.cs
?????文件????????2348??2017-10-23?10:27??jqueryproj_ADO\jqueryproj_ADO\obj\Debug\jqueryproj_ADO.csproj.FileListAbsolute.txt
............此處省略5個文件信息