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

asp.netºÍsql2005ÔõôÅжÏÊÇ·ñÕý³£Á¬½Ó

.netÊÇÐÂÊÖ
×î½ü²Åѧϰ
²»ÖªµÀÊDz»ÊǺÍsql2005Á¬ÉÏû
try
{
  using(Connection con=new (Á¬½Ó×Ö·û´®))
    {
        con.Open();//²»±¨´í¾Í±íʾÁ¬½Ó³É¹¦ÁË¡£
    }
}
catch
{
}

ÐÂÊÖÍÆ¼öÓÃsqldatasource¿Ø¼þ,ÕâÑù¿ÉÒÔÖ±¹ÛµÄ¿´µ½Á¬½ÓÊÇ·ñ³É¹¦¡£

ÒýÓÃ
try
{
    using(Connection con=new (Á¬½Ó×Ö·û´®))
    {
        con.Open();//²»±¨´í¾Í±íʾÁ¬½Ó³É¹¦ÁË¡£
      }
}
catch
{
}

ÓÃvs2008+sql2005
²»ÓÃÒýÈëʲô³ÌÐò¼¯Âð£¿
ÎҼǵÃc#ÓÃvs2005+sql2000Á¬½ÓµÄʱºò£¬ÐèÒªÒýÈëSqlClientÕâ¸ö.dll
ʱ¼äÓе㳤ÁË£¬ÍüÁËÊDz»ÊÇÕâôƴµÄÁË

ÒýÓÃ
ÒýÓà 1 Â¥ huming_h µÄ»Ø¸´:

ÓÃvs2008+sql2005
²»ÓÃÒýÈëʲô³ÌÐò¼¯Âð£¿
ÎҼǵÃc#ÓÃvs2005+sql2000Á¬½ÓµÄʱºò£¬ÐèÒªÒýÈëSqlClientÕâ¸ö.dll
ʱ¼äÓе㳤ÁË£¬ÍüÁËÊDz»ÊÇÕâôƴµÄÁË


using System.Data.SqlClient;

ÒýÓÃ
ÐÂÊÖÍÆ¼öÓÃsqldatasource¿Ø¼þ,ÕâÑù¿ÉÒÔÖ±¹ÛµÄ¿´µ½Á¬½ÓÊÇ·ñ³É¹¦¡£


Õâ¸çÃÇÎóµ¼ÐÂÊÖŶ£¬ÒªÊÇÕâÑùÒ»Ö±Óÿռä ÎÒ¹À¼ÆÄãÒÔºó¶¼²»»áдºǫ́¡£¡£¡£

ÒýÓÃ
ÒýÓà 3 Â¥ cainiao66 µÄ»Ø¸´:
ÒýÓà 1 Â¥ huming_h µÄ»Ø¸´:

&n


Ïà¹ØÎÊ´ð£º

csvÎļþת»»³Ésqlµ¼Èëµ½Êý¾Ý¿â£¬Ã»ÓÐÊý¾ÝΪºÎ£¿

Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......

Asp+sql serverÎÊÌâ - Web ¿ª·¢ / ASP

ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º ......

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

Êý¾ÝÒÔxml¸ñʽ·µ»Ø - MS-SQL Server / Ó¦ÓÃʵÀý

´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked&qu ......

pl/sql - Oracle / ¿ª·¢

СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿

3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ