ÏÂÔØµÄasp.netÕ¾ 2ÖÖ·½·¨¶¼Á¬½Ó²»ÉÏsql05Êý¾Ý¿â...
ÓÖÊÇÕâ¸öÀÏÎÊÌâ¡£¡£¡£ÎÒ´ÓÕâÏÂÔØµÄÕâ¸öasp.netµÄOAϵͳ http://www.51aspx.com/CV/SimpleOA/
ÔËÐбðµÄasp.netÊý¾Ý¿â¶¼Ã»Ê£¬ ¾ÍÕâ¸ö´úÂëÁ¬²»ÉÏÊý¾Ý¿â
˵ÊÇsql2005Êý¾Ý¿â£¬µ«ÔõôҲÁ¬²»ÉÏ
²»ÊÇÓÐ2ÖÖÁ¬½Ó·½·¨Âð£¬windowsµÄ£¬ ºÍsqlµÄuid pwdµÄ£¬µ«2ÖÖ¶¼²»ÐÐ(ÎÒ»ú×Ósql2005·þÎñÆ÷Ãû³ÆA2F33A0BEBA34D7£©
<add name="SimpleOAConnectionString" connectionString="Data Source=A2F33A0BEBA34D7;Initial Catalog=SimpleOA;Integrated Security=True" providerName="System.Data.SqlClient"/>
<add name="SimpleOAConnectionString" connectionString="server=A2F33A0BEBA34D7;database=SimpleOA;uid=sa;password=sa" providerName="System.Data.SqlClient"/>
´íÎóʱ£º
¡°/SimpleOAVS2005¡±Ó¦ÓóÌÐòÖеķþÎñÆ÷´íÎó¡£
--------------------------------------------------------------------------------
ÔÚ½¨Á¢Óë·þÎñÆ÷µÄÁ¬½Óʱ³ö´í¡£ÔÚÁ¬½Óµ½ SQL Server 2005 ʱ£¬ÔÚĬÈϵÄÉèÖÃÏ SQL Server ²»ÔÊÐí½øÐÐÔ¶³ÌÁ¬½Ó¿ÉÄܻᵼÖ´Ëʧ°Ü¡£ (provider: SQL ÍøÂç½Ó¿Ú, error: 26 - ¶¨Î»Ö¸¶¨µÄ·þÎñÆ÷/ʵÀýʱ³ö´í)
ºóÒ»ÖÖ·½·¨ server=.;database=db;uid=sa;pwd=sa;ÊÔÊÔ
¶Ô·½Ã»ÓпªÔ¶³ÌÁ¬½Ó£¬»òÕß¶Ô·½µÄÔ¶³ÌÁ¬½Ó¶Ë¿Ú²»ÊÇ1433£¬ÉèÖõIJο¼Â¥ÉÏ¡£¡£¡£
ÔÎÁË£¬»¹ÊDz»Ðа¡¡£¡£¡£
¹Ø¼üÎÊÌâÊÇ£¬±ðµÄ´úÂë¶¼¿ÉÒÔ£¬ ¾ÍÕâ¸öOA´úÂë²»ÐУ¬ ÐÖµÜÃÇÄܰïÎÒÊÔÑéÒ»ÏÂÂ𣬠¾ÍÄǸö51aspxÏÂÔØµØÖ·£¬ ÎÒ»úÆ÷ÊÇ.net2008ºÍsql2005
±ðµÄÊý¾Ý¿â¶¼Á¬½ÓµÄºÃºÃµÄ£¬¾ÍÕâ¸öOA²
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......
±¾ÈËĿǰÓöµ½Ò»¸öÄÑÌ⣬Çë¸÷λ¸ßÊÖ¡¢´óÏÀ°ï°ïæ¡£
ÎÒµ¥»÷Ò»¸ö°´Å¥Ê±Òª°ÑgridviewÖеÄÊý¾ÝÒ»¸öÒ»¸öµÄÈ¡³ö²¢°Ñ¶ÔÓ¦²ÎÊý´«µÝ¸øÇ°Ì¨µÄjs¡£
ÎÒÊÔÁ˼¸ÖÖºǫ́µ÷ǰ̨µÄ·½Ê½¶¼Ã»Óгɹ¦£¬ËùÒÔÇë´óÏÀÃǰï°ïСµÜ¡£
лл¡£
²» ......
<table style="width: 1000px"><tr>
<td style="height: 38px; width: 35px;">
ÐÕÃû</td>
......
½ñÌì×öÁËÒ»¸ö´æ´¢¹ý³Ì »·¾³ÊÇSQL2000Êý¾Ý¿â
´óÖÂÈçÏÂ
½¨Á¢ÁÙʱ±í
¶¨ÒåÔ±¹¤Óαê
Ñ»·Ô±¹¤£¨ÊôÓÚ1¸ö¹«Ë¾)
......
´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked&qu ......