Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÏÂÔØµÄ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²


Ïà¹ØÎÊ´ð£º

asp.net·ÖÒ³ÎÊÌâ

select top 12 * from Product where [id] not in (select top 12 [id] from Product)
ÕâÑù¿ÉÒÔ·ÖÒ³£¬µ«ÊÇÎÒÔÚºóÃæÏë¼Ó¸öÌõ¼þ
select top 12 * from Product where [id] not in (select top 12 [id] from Prod ......

sqlÓï¾ä¶à±í¶à×ֶβéѯ - MS-SQL Server / »ù´¡Àà

ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд 

ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......

sqlת»»ÎÊÌ⣬¼±£¡ - ÉçÇøÖ§³Ö / ¡¶³ÌÐòÔ±¡·ÔÓÖ¾

select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......

ÔÚasp.netÀïÃæ½Å±¾³ö´í - .NET¼¼Êõ / ASP.NET

function CheckOpwd(){//ÑéÖ¤Óû§Ãû
var pwd=document.all.txtOpwd;

var div1=document.getElementById("divPwd");

if (pwd.value=="")
{
......

sql ËÑË÷Óï¾ä - .NET¼¼Êõ / ASP.NET

<table style="width: 1000px"><tr>
  <td style="height: 38px; width: 35px;">
  ÐÕÃû</td>
  ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ