JavaScriptµ÷ÓÃdataTable²¢»ñÈ¡ÆäÖµ(ASP.Net,VS2005)
JavaScriptµ÷ÓÃdataTable²¢»ñÈ¡ÆäÖµ(ASP.Net,VS2005)
±¾¹¦ÄÜÖ÷ÒªÓõ½http://www.cnblogs.com/Hdsome/archive/2008/06/26/1230177.htmlÕâ¸öÐֵܵĴúÂ룬ÎÒÖ÷ÒªÊÇ×öÕûÀíºÍÀ©Õ¹¡£
Ê×ÏÈÔÚhttp://www.codeplex.com/AjaxPro/Release/ProjectReleases.aspx?ReleaseId=713ÍøÖ·ÏÂÔØ6.10.6.2_DLL.zip ѹËõ£¬ÔËÐÐÆäÖеÄAjaxProVSTemplate.vsi£¨±ØÐëÓÐVS2005»·¾³£©£¬È»ºó½«AjaxPro.2.dll¿½±´µ½binĿ¼ÏÂ
ÒÔÏÂÊÇÐèÒªÐ޸ĵĵط½£º
1¡¢ÐÞ¸Äweb.config
ÔÚsystem.web½ÚµãÏÂÌí¼Ó
<system.web>
<httpHandlers>
<add verb="POST,GET" path="ajaxpro/*.ashx" type="AjaxPro.AjaxHandlerFactory, AjaxPro.2"/>
</httpHandlers>
2¡¢ÔÚ.NET·½·¨ÖÐÏò¿Í»§¶Ë×¢²ájavascript£¬ÓÃÒÔjavascriptʹÓÃ
namespace MyDemo
{
public class _Default
{
protected void Page_Load(object sender, EventArgs e)
{
AjaxPro.Utility.RegisterTypeForAjax(typeof(_Default)); //_Default:´°ÌåÀàµÄÃû³Æ
}
[AjaxPro.AjaxMethod]
public DataTable GetDataTable ()
{
return ÈÎÒâÒ»¸ödatatable;
}
}
}
3¡¢ÔÚ¿Í»§¶ËÓÃjavascriptµ÷Ó÷þÎñÆ÷¶ËµÄ·½·¨£¬Óï·¨Ò²ºÜ¼òµ¥
//×Ô¶¨Òåjavascriptº¯Êý
function getGetDataTable ()
{
var dt=MyDemo._Default.GetDataTable (getServerTime_callback); // MyDemo._Default. //ÃüÃû¿Ø¼þ.´°ÌåÀàÃû³Æ
var rowCount=dt.Value.Rows.length; //»ñµÃÐÐÊý
var colCount=dt.Value.Columns.length; //»ñµÃÁÐÊý
var value=dt.Value.Rows[i].filedName; //»ñµÃdtÖÐÖ¸¶¨ÐÐÖ¸¶¨ÁУ¨filedName£©µÄÖµ
}
Ïà¹ØÎĵµ£º
ÔÚWeb±à³Ì¹ý³ÌÖУ¬´æÔÚןܶలȫÒþ»¼¡£±ÈÈçÔÚÒÔǰµÄASP°æ±¾ÖУ¬CookieΪ·ÃÎÊÕߺͱà³ÌÕß¶¼ÌṩÁË·½±ã£¬²¢Ã»ÓÐÌṩ¼ÓÃܵŦÄÜ¡£´ò¿ªIEä¯ÀÀÆ÷£¬Ñ¡Ôñ“¹¤¾ß”²Ëµ¥ÀïµÄ“InternetÑ¡Ï¬È»ºóÔÚµ¯³öµÄ¶Ô»°¿òÀïµ¥»÷“ÉèÖÔ°´Å¥£¬Ñ¡Ôñ“²é¿´Îļþ”°´Å¥£¬ÔÚµ¯³öµÄ´°¿ÚÖУ¬¾Í»áÏÔʾӲÅÌÀï ......
Ò»¡¢¸ÅÊö
Marquee£ºHtmlÖйöÆÁ¿Ø¼þ£¬¿ÉÒÔʹ°üº¬Ôڴ˱ê¼ÇÖеÄÄÚÈݽøÐи÷¸ö·½Ïò£¬¸÷ÖÖËٶȵĹö¶¯£¬Òò´ËÔÚ²»¿¼ÂÇʹÓõÚÈý·½¿Ø¼þµÄǰÌáÏ£¬¿¼ÂÇʹÓÃMarquee+xmlhttpÀ´ÊµÏÖ¶¨´Î¸üÐÂÒ³ÃæÖеĹö¶¯ÄÚÈÝ£¬´ËʵÏÖÔÚIE6.0¼°ÒÔÉϰ汾²âÊÔͨ¹ý£¬ÆäËûä¯ÀÀÆ÷ÔÝʱδ²âÊÔ¹ý¡£
MarqueeÖеÄonfinishʼþ£ºÔÚ¸øMarqueeÊôÐÔloop¸ ......
µ¼ÈëEXCELÒ»°ãÓÐ3ÖÖ·½·¨
1.ͨ¹ýExcel APIlÀ´µ¼È루ȱµã£¬ÐèÒª°²×°OFFICE×é¼þ£¬½¨Á¢¶ÔÏóºó£¬²»ÈÝÒ×ÊÍ·Å£¬´óÊý¾ÝÁ¿Ê±¶ÁÈ¡ËٶȽϵͣ©
2.ͨ¹ýOLEDBÊý¾ÝÔ´·½Ê½¶ÁÈ¡
3.ͨ¹ýµÚÈý·½×é¼þÀ´µ¼Èë£¨ÍÆ¼öʹÓÃExcelLibrary£©ÏÂÔØµØÖ·£ºhttp://code.google.com/p/excellibrary/
ͬÑùµ¼³öEXCELÒ²ÓÐ3ÖÖ·½·¨£¬ºÍµ¼ÈëÀàËÆ¡£
ÍÆ¼öʹÓõÚ3ÖÖ ......