前台代码:
<div class="fitem">
<label>户主名称:</label>
<input id="Name" name="holderName" class="easyui-combobox"
data-options="valueField:'holder_id', textField:'holderName',panelHeight:'70', url:'ashx/GetName.ashx' " />
</div>
后台代码:
public void Query(HttpContext context)
{
//调用B层的方法从而获取数据库的Dataset
ADO.SqlAdo ado = new ADO.SqlAdo();
string sql = "select holder_id,holderName from t_householdsInfo";
DataSet ds = ado.getTable(sql);
//将Dataset转化为Datable
DataTable dt = ds.Tables[0];
int count = dt.Rows.Count;
string strJson = Dataset2Json(ds, count);//DataSet数据转化为Json数据
context.Response.Write(strJson);//返回给前台页面
context.Response.End();
返回的json:
{"total":5,"rows":[{"holder_id":"2","holderName":"王晓宇"},{"holder_id":"3","holderName":"小苏"},{"holder_id":"4","holderName":"万面"},{"holder_id":"7","holderName":"我的家"}