jquery给页面所有<select></select>赋值，并能设置选中项，其中数据为数据库读取(非runat="server")

jquery给页面所有<select></select>赋值，并能设置选中项，其中数据为数据库读取(非runat="server")
最好是写成方法的，可以在脚本中灵活调用的那种，感谢大虾们

解决方案 »

免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货

<%@ WebHandler Language="C#" Class="getGoodsInfo" %>
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
using System.Text;
public class getTime : IHttpHandler {
    public void ProcessRequest (HttpContext context) {
        context.Response.ContentType = "application/octet-stream";
        context.Response.Write(GetGoodsName());
    }
    public bool IsReusable {
        get {
            return false;
        }
    }
    private static string GetGoodsName()      //返回值是一个json格式的字符串
    {
        string sql = "Data Source=.;Initial Catalog=HcitPos;Integrated Security=True";
        SqlConnection conn = new SqlConnection(sql);
        string selectStr = "select * from GoodsInfo";
        SqlCommand cmd = new SqlCommand(selectStr, conn);
        StringBuilder sbGoodsName = new StringBuilder();
        sbGoodsName.Append("[{/"GoodsName/":/"请选择/",/"GoodsID/":/"-1/"}");
        conn.Open();
        SqlDataReader dr = cmd.ExecuteReader();
        while (dr.Read())
        {
            sbGoodsName.Append(",{");
            sbGoodsName.Append("/"GoodsName/":" + "/"" + dr["GoodsName"].ToString() + "/",");
            sbGoodsName.Append("/"GoodsID/":" + "/"" + dr["GoodsID"].ToString() + "/"");
            sbGoodsName.Append();
            sbGoodsName.Append("}");
        }
        dr.Close();
        conn.Close();
        sbGoodsName.Append("]");
        return sbGoodsName.ToString();
    }
}

Default.aspx的内容   （前台代码）

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>无标题页</title>
    <script src="js/jquery-1.4.4.js" type="text/javascript"></script>//这里是jQuery的引用
<script language="javascript" type="text/javascript">//jQuery代码
$(document).ready(function(){
    GetGoodsName();
});
function GetGoodsName()
{
     $.getJSON("getTime.ashx", function (data){
            for (var i = 0; i < data.length; i++) {
                $("#selectGoodsName").append($("<option value=/""+data[1].GoodsID+"/">"+data[i].GoodsName+"</option>"));
            }
    });
}
</script></head>
<body >
    <form id="form1" runat="server" >
    商品条码：<input id="txtBarcode" type="text" />   商品名称：<select
        id="selectGoodsName" name="D1">
    </select>  商品单位：<input id="txtUnit" type="text" />  商品单价：<input
        id="txtPrice" type="text" /></form>
</body>
</html>