后台变量jsondata
public StringBuilder jsondata =new StringBuilder("{\"ClassRoot\":[");
protected void Page_Load(object sender, EventArgs e)
{
db.initDB();
ds = db.QueryData("select * from tb_bigClass order by bClassID", "bigclass");
if (ds.Tables["bigclass"] != null)
{
bigclass = ds.Tables["bigclass"];
if (bigclass.Rows.Count > 0)
{
for (int i = 0; i < bigclass.Rows.Count; i++)
{
jsondata.Append("{\"bClassID\":" + bigclass.Rows[i][0].ToString() + ",\"bClassName\":\"" + bigclass.Rows[i][1].ToString() + "\",\"son\":[");
int bclassid = i + 1;
ds = db.QueryData("select * from tb_smallClass where bClassID=" + bclassid + " order by sClassID", "smallclass");
if (ds.Tables["smallclass"].Rows.Count > 0)
{
for (int j = 0; j < ds.Tables["smallclass"].Rows.Count; j++)
{
if (j == ds.Tables["smallclass"].Rows.Count - 1)
{
jsondata.Append("{\"sClassID\":" + ds.Tables["smallclass"].Rows[j][0].ToString() + ",\"sClassName\":\"" + ds.Tables["smallclass"].Rows[j][1].ToString() + "\"}");
}
else
{
jsondata.Append("{\"sClassID\":" + ds.Tables["smallclass"].Rows[j][0].ToString() + ",\"sClassName\":\"" + ds.Tables["smallclass"].Rows[j][1].ToString() + "\"},");
}
}
jsondata.Append("]"); }
else
{
jsondata.Append("\"none\"]");
} if (i == bigclass.Rows.Count - 1)
{
jsondata.Append("}");
}
else
{
jsondata.Append("},");
}
}
}
jsondata.Append("]}");
}
}前台js调用<script type="text/javascript">
var json=<%=jsondata%>;
alert(json);
for( var j in json ) { alert(json[b].bClassName); }
</script>
public StringBuilder jsondata =new StringBuilder("{\"ClassRoot\":[");
protected void Page_Load(object sender, EventArgs e)
{
db.initDB();
ds = db.QueryData("select * from tb_bigClass order by bClassID", "bigclass");
if (ds.Tables["bigclass"] != null)
{
bigclass = ds.Tables["bigclass"];
if (bigclass.Rows.Count > 0)
{
for (int i = 0; i < bigclass.Rows.Count; i++)
{
jsondata.Append("{\"bClassID\":" + bigclass.Rows[i][0].ToString() + ",\"bClassName\":\"" + bigclass.Rows[i][1].ToString() + "\",\"son\":[");
int bclassid = i + 1;
ds = db.QueryData("select * from tb_smallClass where bClassID=" + bclassid + " order by sClassID", "smallclass");
if (ds.Tables["smallclass"].Rows.Count > 0)
{
for (int j = 0; j < ds.Tables["smallclass"].Rows.Count; j++)
{
if (j == ds.Tables["smallclass"].Rows.Count - 1)
{
jsondata.Append("{\"sClassID\":" + ds.Tables["smallclass"].Rows[j][0].ToString() + ",\"sClassName\":\"" + ds.Tables["smallclass"].Rows[j][1].ToString() + "\"}");
}
else
{
jsondata.Append("{\"sClassID\":" + ds.Tables["smallclass"].Rows[j][0].ToString() + ",\"sClassName\":\"" + ds.Tables["smallclass"].Rows[j][1].ToString() + "\"},");
}
}
jsondata.Append("]"); }
else
{
jsondata.Append("\"none\"]");
} if (i == bigclass.Rows.Count - 1)
{
jsondata.Append("}");
}
else
{
jsondata.Append("},");
}
}
}
jsondata.Append("]}");
}
}前台js调用<script type="text/javascript">
var json=<%=jsondata%>;
alert(json);
for( var j in json ) { alert(json[b].bClassName); }
</script>
var js=<%=jsondata%>;
var json = eval(js);
for( var j in json ) { alert(json[b].bClassName); }
</script>
<script type="text/javascript">
var jsondata='<%=jsondata%>';
var json = eval(jsondata);
for( var j in json ) { alert(json[j].bClassName); }
</script>
希望对初学者能帮助下:)