public void ProcessRequest(HttpContext context) { int test; #region 抓取目標tb欄位資料 DataTable dt = new DataTable(); DataColumn column; DataRow row; column = new DataColumn(); column.DataType = System.Type.GetType("System.Int32"); column.ColumnName = "empno"; dt.Columns.Add(column); column = new DataColumn(); column.DataType = System.Type.GetType("System.String"); column.ColumnName = "name"; dt.Columns.Add(column); string[] earray = cc1.connectionofc008_selectasarray("select empl from ecsfc000_emplrole", "empl", Convert.ToInt32(cc1.connectionofc008_select("select count(*) as cte from ecsfc000_emplrole", "cte"))); string[] col_array = { "empl", "t_name" }; int emplct = Convert.ToInt32(cc1.connectionofc008_select("select count(*) as ct from ecsfc000_emplrole", "ct")); var enarray = cc1.mstrarray("select empl,t_name from ecsfc000_emplrole as t1 inner join ecpsl010 as t2 on t1.empl=t2.t_empl", emplct, col_array); for (int k = 0; k < emplct; k++) { row = dt.NewRow(); row["empno"] = Convert.ToInt32(enarray.Item1[0, k]); row["name"] = enarray.Item1[1, k].ToString(); dt.Rows.Add(row); } //for (int i = 0; i < earray.Length; i++) //{ // row = dt.NewRow(); // row["empno"] = i; // row["name"] = earray[i]; // dt.Rows.Add(row); //} #endregion string result = Newtonsoft.Json.JsonConvert.SerializeObject(dt); context.Response.ContentType = "application/json"; context.Response.Charset = "utf-8"; context.Response.Write(result); }