<script language="javascript" type="text/javascript">
(function gettable() {
WebService005.GetTable(onss, err);
})();
function onss(info) {
var ss = new Sys.StringBuilder();
ss.append ("<div>");
for (var i = 0; i < info.rows.length; i++) {
ss.append(String.format("{0} {1} {2} {3}</br>", info.rows[i]["sh_tiringadminid"], info.rows[i]["sh_tiringadminName"], info.rows[i]["Sh_tiringadminsex"], info.rows[i]["sh_tiringadmiage"]));
}
ss.append("</div>");
document.getElementById("div").innerHTML = ss.toString();
}
function err(dd) {
alert(dd.get_message);
}
</script>
//webservice的方法
[WebMethod]
[ScriptMethod]
public DataTable GetTable() {
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["xu"].ConnectionString))
{
SqlCommand com = new SqlCommand("select sh_tiringadminid,sh_tiringadminName,Sh_tiringadminsex,sh_tiringadmiage from V_schooladminuser2", conn);
SqlDataAdapter adap = new SqlDataAdapter(com);
DataSet set = new DataSet();
adap.Fill(set);
return set.Tables[0];
}
}