asp.netºÍsql2005ÔõôÅжÏÊÇ·ñÕý³£Á¬½Ó
.netÊÇÐÂÊÖ
×î½ü²Åѧϰ
²»ÖªµÀÊDz»ÊǺÍsql2005Á¬ÉÏû
try
{
using(Connection con=new (Á¬½Ó×Ö·û´®))
{
con.Open();//²»±¨´í¾Í±íʾÁ¬½Ó³É¹¦ÁË¡£
}
}
catch
{
}
ÐÂÊÖÍÆ¼öÓÃsqldatasource¿Ø¼þ,ÕâÑù¿ÉÒÔÖ±¹ÛµÄ¿´µ½Á¬½ÓÊÇ·ñ³É¹¦¡£
ÓÃvs2008+sql2005
²»ÓÃÒýÈëʲô³ÌÐò¼¯Âð£¿
ÎҼǵÃc#ÓÃvs2005+sql2000Á¬½ÓµÄʱºò£¬ÐèÒªÒýÈëSqlClientÕâ¸ö.dll
ʱ¼äÓе㳤ÁË£¬ÍüÁËÊDz»ÊÇÕâôƴµÄÁË
using System.Data.SqlClient;
Õâ¸çÃÇÎóµ¼ÐÂÊÖŶ£¬ÒªÊÇÕâÑùÒ»Ö±Óÿռä ÎÒ¹À¼ÆÄãÒÔºó¶¼²»»áдºǫ́¡£¡£¡£
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......
ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º
......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked&qu ......
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿
3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......