js刷新页面:JS无刷新更新页面同步数据库来源: 发布时间:星期四, 2009年2月12日 浏览:649次 评论:0
JS无刷新更新页面同步数据库代码 <script type=\"text/javascript\"> //<![CDATA[ // 163 AJAX Tab // update 2006.10.18 // 增加鼠标延迟感应特性 function test(rs) { Yin.Default.GetSelectedValues(rs, get_country_Result_CallBack); } function test_call_back(res) { //alert(res.value); //document.getElementById(\"ware\").innerHTML = res.value; res = null; } function get_country_Result_CallBack(res){ (typeof(res.value) \'object\'){ var ds = res.value; var msg = document.getElementById(\"ware\"); var msTab = ds.Tables[0]; var n = 1; for (var i=0; i < msTab.Rows.length; i){ (n % 4 0) var s = s +\"<div>\"+msTab.Rows[i].infoName+\"<br /><img src=\"+msTab.Rows[i].infoImg+\" width=115 height=90></div></ul><ul>\"; var s = s +\"<div>\"+msTab.Rows[i].infoName+\"</span><span><img src=\"+msTab.Rows[i].infoImg+\" width=115 height=90></div>\"; n; //var s = s + \"<tr><td>\"+msTab.Rows[i].infoName+\"</td></tr><tr><td><img src=\"+msTab.Rows[i].infoImg+\" width=115 height=90></td></tr>\"; }; alert(s); msg.innerHTML =\"<ul>\"+s+\"\"; } } //]]> </script> using ; using .Data; using .Data.SqlClient; using .Configuration; using .Web; using .Web.Security; using .Web.UI; using .Web.UI.WebControls; using .Web.UI.WebControls.WebParts; using .Web.UI.HtmlControls; using AjaxPro; using .Collections.Generic; Yin{ public partial Default : .Web.UI.Page{ protected void Page_Load(object sender, EventArgs e){ AjaxPro.Utility.RegisterTypeForAjax(typeof(Default)); } protected Chars( str, num){ str.Trim; (str.Length < num)[Page] str; str.Sub(0, num)+\"...\"; } [AjaxMethod] public DataSet GetSelectedValues( yzs) { DataSet s = DataSet; switch (yzs) { \"雅砻\": s = myData(2); ; \"奇正\": s= myData(4); ; \"甘露\": s = myData(3); ; \"金诃\": s = myData(26); ; \"晶珠\": s = myData(28); ;[Page] \"其它\": s = myData(30); ; default: s = myData(2); ; } s; } #region 该过程用来绑定数据 public DataSet myData( num) { //首先建立DataSet对象注意这里读取了全部数据 strSql = \"select infoName,infoImg,buyprice from WareInfo where infoType in (select typeId from WareType where typeFatherId =\" + num + \")\"; SqlDataAdapter adp = SqlHelper.ExecuteAdapter(CommandType.Text, strSql, null); DataSet dst = DataSet; adp.Fill(dst, \"WareInfo\"); dst; //DataView dv = DataView; //dv.Table = dst.Tables[0]; //dv.RowFilter = \"infoType =\" +chars;//in ((select typeId from WareType where typeFatherId=\"+\"))\"; //+ \"and isView = \" + true; } #endregion } } 0
相关文章读者评论发表评论 |