金色約定之家

本来用Request.Form["txtnote"]就可以了，可是里面如果有逗号怎么办，这种方式是自动以逗号分开的。
string[] nameParts = Request.Params.GetValues("txtnote")可满足要求。
然后合并即可,可用FOR，据说foreach性能更佳。

            string a = "";
           // for( int i = 0; i < nameParts.Length; i++ )
            foreach (string s in nameParts)
            {
                //a +=nameParts[i].ToString() + "@";
                a += s + "@";
            }

需要返回JSon数据集。
ASPX:
$.ajax({
type: "POST",
contentType: "application/json;utf-8",
data: "{strclassid:'" + strclassid + "'}",
url: "/AutoService.asmx/Show",
success: function (msg) {
var myObject = eval('(' + msg.d + ')');
for (var i = 0; i < myObject.length; i++) {
    $("#selectabc").append(("<option value='" + myObject[i].Id + "'>" + myObject[i].Names + "</option>"));
    }

Cs文件中可用

JavaScriptSerializer js = new JavaScriptSerializer();
return js.Serialize(USERS)

序列化
直接生成JSON文件更方便：

       StringBuilder sbGoodsName = new StringBuilder();
       sbGoodsName.Append("[{\"GoodsName\":\"请选择\",\"GoodsID\":\"-1\"}");
       DbDataReader dr = db.ExecuteReader(cmd);
       while (dr.Read())
        {
            sbGoodsName.Append(",{");
            sbGoodsName.Append("\"GoodsName\":" + "\"" + dr["names"].ToString() + "\",");
            sbGoodsName.Append("\"GoodsID\":" + "\"" + dr["id"].ToString() + "\"");
            sbGoodsName.Append("}");
        }
        dr.Close();
        sbGoodsName.Append("]");
        return sbGoodsName.ToString();

今天发现多项中，其中有一项为空时，所有的数据都不显示。
加ISNULL解决:
set @tolname=@tolname+ISNULL((SELECT [names] FROM [toolist] where id=@strSQL1),'')+'<br/>'

1.第一种方法，Repeater中绑定DropDownList实现。

<asp:DropDownList ID="ddlfixs" runat="server" appenddatabounditems="true">
      <asp:ListItem Value="">请选择治具</asp:ListItem></asp:DropDownList>
      <asp:HiddenField ID="hdfixid" runat="server" Value='<%# Eval("Fixid")%>' />

        protected void myRepeater_ItemDataBound(object sender, RepeaterItemEventArgs e)
        {
            DropDownList ddlfixs = e.Item.FindControl("ddlfixs") as DropDownList;
            //HtmlSelect ddltools = e.Item.FindControl("ddltools") as HtmlSelect;

            WebClass.Toolfix tmpp = new WebClass.Toolfix();
            ddlfixs.DataSource = tmpp.ListFixShow();
            ddlfixs.DataTextField = "Names";
            ddlfixs.DataValueField = "Id";
            ddlfixs.DataBind();

            ddlfixs.SelectedValue = ((HiddenField)e.Item.FindControl("hdfixid")).Value;
        }

取值:

            string strfixs = "";
            foreach (RepeaterItem rptItem in myRepeater.Items)
            {
                DropDownList ddl = rptItem.FindControl("ddlfixs") as DropDownList;
                strfixs += ddl.SelectedValue + ",";
            }
            strfixs = strfixs.Remove(strfixs.Length - 1);

这种方法很不好，会生成;<select name="myRepeater$ctl02$ddlfixs" id="myRepeater_ddlfixs_2">类似的代码，如果javascript控制添加多行操作，很难控制。

2.第二方法，从后台生成HTML代码。

<%# BinGxData(Eval("Gxid").ToString())%>

        public string BinGxData(string strgxid)
        {
            WebClass.TooList tmp = new WebClass.TooList();
            DataTable dt=tmp.ListToolTable();
            string strMsg = "<select name='ddltools' id='ddltools'>";
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                string str1 = (strgxid == dt.Rows[i]["id"].ToString() ? "selected='selected'" : "");
                strMsg = strMsg + "<option value='" + dt.Rows[i]["id"].ToString() + "' " + str1 + ">" + dt.Rows[i]["names"].ToString() + "</option>";
            }
            strMsg = strMsg + "</select>";
            return strMsg; 
        }

取值好简单:Request.Form["ddltools"];即可。
此方法干净利索，尤其在添加多行操作中很好控制。