我在后台拼接了一个table传到前台显示了出来，但是不知道怎么把查到的数据也插进表格，请问该怎么办

[讲道理叫我软件工程师]

public string GetTable()
        {
            StringBuilder sb = new StringBuilder();
            sb.Append("<table id=\"table_top\"  class=\"tableCss\" style=\"color:#ffffff\">");
            sb.Append("<tr><td class=\"auto-style1\">任务编码</td><td class=\"auto-style6\"> </td><td class=\"auto-style1\">任务数量</td><td> </td></tr>");
            sb.Append("<tr><td class=\"auto-style1\">产品名称</td><td colspan=\"3\"> </td></tr>");
            sb.Append("<tr><td class=\"auto-style1\">组托规范</td><td colspan=\"3\"> </td></tr>");
            sb.Append("</table>￥");
            sb.Append("<table class=\"auto-style3\" id=\"table2\">");
            sb.Append("<tr><td class=\"auto-style1\">任务状态</td><td class=\"auto-style4\" id=\"renwu\"></td></tr>");
            sb.Append("<tr><td class=\"auto-style1\">托盘状态</td><td class=\"auto-style4\" id=\"tuopan\"><span id=\"zhengchang\">正常</span><span id=\"cuowu\">错误</span></td></tr>");
            sb.Append("<tr><td class=\"auto-style1\">累计失败</td><td> </td></tr>");
            sb.Append("<tr><td class=\"auto-style1\">当前数量</td><td> </td></tr>");
            sb.Append("<tr><td class=\"auto-style1\">累计成功</td><td> </td></tr>");
            sb.Append("</table>￥");
            sb.Append(" <table class=\"auto-style3\" id=\"table3\" style=\"color:#ffffff\">");
            sb.Append("<tr><td class=\"auto-style1\">托盘识别码</td><td colspan=\"2\"> </td></tr>");
            sb.Append("<tr><td rowspan=\"7\" class=\"auto-style1\">扫描队列</br>滚动记录</td><td class=\"auto-style5\">1</td><td> </td></tr>");
            sb.Append("<tr><td class=\"auto-style5\">2</td><td> </td></tr>");
            sb.Append("<tr><td class=\"auto-style5\">3</td><td> </td></tr>");
            sb.Append("<tr><td class=\"auto-style5\">4</td><td> </td></tr>");
            sb.Append("<tr><td class=\"auto-style5\">5</td><td> </td></tr>");
            sb.Append("<tr><td class=\"auto-style5\">6</td><td> </td></tr>");
            sb.Append("<tr><td class=\"auto-style5\">7</td><td> </td></tr>");
            sb.Append("</table>");
            return sb.ToString();
        }

上面是我拼的表，下面是我前台的

function table() {
            $.ajax({
                url: "Ash/index.ashx",
                type: "GET",
                dataType: "text",
                data: {"ID":""},
                error: function (XMLHttpRequest, textStatus, errorThrown) {
                
                },
                success: function (sb) {
                    var table1 = '<table class="tableCss" style="color:#FFFFFF">'
                    $("#top").html(sb.split("￥")[0]);
                    $("#middle_left").html(sb.split("￥")[1]);
                    $("#mieele_right").html(sb.split("￥")[2]);
                    
                }
            });
        }

这是现在的界面图


这是要求的界面



这是我的ajax后台查询语句

 public void ProcessRequest(HttpContext context)
        {
            context.Response.Write(GetTable()+"￥");
            //查询状态为开始的任务
            DataTable dtStar = _lzbll.GetList(1,"flag=2","").Tables[0];
            string a = ToJson(dtStar);
            if (dtStar.Rows.Count > 0)
            {
                context.Response.Write(a);
            }
            //没查到，则按时间顺序查找最后面的数据
            else
            {
                dtStar = _lzbll.GetList(1, "", "CreatedOn").Tables[0];
                context.Response.Write(a);
            }
        }

请问怎么把我查到的数据插进相应的表格

[fleetingevent]

帮你顶一顶。。。。

[娃都会打酱油了]

Jquery找到对应dom，然后赋值啊

[stherix]

后台为什么要涉及到html Table这种界面方面的呢 传个json到前台 让前台自己负责界面不好吗

[以专业开发人员为伍]

前端编程设计模式类似这样（这里是用了微软的 ko 框架）： http://knockoutjs.com/examples/gridEditor.html http://knockoutjs.com/examples/cartEditor.html 前后台通讯就是两个进程之间的简单通讯，而不是 asp.net 这种编程设计模式。

[慢步前行]

后台传这么多数据

[EnForGrass]

直接在前天处理数据不行么

[王志威丶]

1.三个表格分为三个方法去操作，可以直接在后台拼接table的同时，将数据一同拼接进去，返回给页面后直接显示。 2.如果数据需要前台ajax获取，可以在后台拼接table 的时候，在相关的td上做上标识(ID,或者Name)，ajax获取到数据后，根据相对应的ID或者name给td赋值。 3.如果table是固定的，可以直接在页面上写好，根据需求显示隐藏。

[liulei68211]

string sqlselect = "select s.pk_iID as 项目编号,s.pk_iSXID as 销售合同编号,s.cprojectName as 项目名称,s.csell_department as 销售单位,s.tcontract_time as 签订时间,s.clinkman as 联系人,s.fcontract_value as 合同金额,p.tcollection_time as 收款时间,p.fpayment_amount as 收款金额,p.cpay as 支付形式,fcollection_amounts as 总收款金额,s.foutstanding_amount as 未结算金额,s.cpayment_rate as 付款率,s.fgross_margin as 毛利润,i.cinvoice_number as 发票号,i.tticket_time as 开票时间,i.finvoice_balance as 发票结余,s.cpayment_method as 付款方式,s.cremark as 备注 from sell_contract as s inner join collection_payments as p on s.pk_iSXID=p.pk_iSXID inner join collection_invoice as i on s.pk_iSXID=i.pk_iSXID where s.pk_iID='" + txt1.Text + "' union all select c.pk_iID as 项目编号,c.pk_iPURID as 采购合同编号,c.cprojectName as 采购项目,c.cpur_department as 采购单位,c.tcontract_time as 签订时间,c.clinkman as 联系人,c.fcontract_value as 合同金额,p.tpayment_time as 付款时间,p.fpayment_amount as 付款金额,p.cpay as 支付形式,c.fpayment_amounts as 总付款金额,c.funsettled_amount as 未结算金额,c.cpayment_rate as 付款率,NULL,i.cinvoice_number as 发票号,i.tticket_time as 开票时间,i.finvoice_balance as 发票结余,c.cpayment_method as 付款方式,c.cremark as 备注 from purchasing_contract as c inner join purchasing_payments as p on c.pk_iPURID=p.pk_iPURID inner join purchasing_invoice as i on c.pk_iPURID=i.pk_iPURID where c.pk_iID='" + txt1.Text + "'"; SqlDataAdapter myda = new SqlDataAdapter(sqlselect,mycon); DataSet myds = new DataSet(); myda.Fill(myds, "mydt"); DataTable mydt = myds.Tables["mydt"]; dgv1.DataSource = myds.Tables[0];