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

»òÐíÊÇSqlServer°²×°ÎÊÌâ..... Çó½Ì£¡

SqlServer°²×°µÄ¹ý³ÌÖУ¬ÊDz»ÊÇÓÐÒ»¸öÓòµÄÅäÖ㬷þÎñÆ÷Ãû³ÆÊ¹Óñ¾»ú¼ÆËã»úÃû³Æ£¿
  ÊÇÕâÑùµÄ£¬ÓиöÓ¦ÓóÌÐò£¬½øÈëµÄʱºò¾ÍÌáʾ ÕÒ²»µ½·þÎñÆ÷£¬ ÎÒ¿´ÁËÆäËûµÄÅäÖ㬳ýÁËSqlServerµÄ°æ±¾²»Ò»ÑùÍ⣬¾ÍÊÇ·þÎñÆ÷µÄÃû³Æ£¬ÎÒÔÚ°²×°µÄ¹ý³ÌÖÐʹÓõÄÊÇĬÈÏ(local)£¬¶øÁ¬½Ó·þÎñÆ÷µÄÃû³ÆÊDZ¾»úµÄÃû³Æ¡£ÊÔÎÊÈçºÎÄܹ»Ð޸ĸÃSqlµÄ·þÎñÆ÷Ãû³Æ£¿
  »¹ÊÇÓÐÆäËûµÄ·½ÃæµÄ´íÎ󣿠       лл£¡£¡£¡
Ò»頭霧Ë®£¬幫頂¡£

Â¥Ö÷¸ø³öÊý¾Ý¿âÁ¬½Ó×Ö·û´®»¹ÓзþÎñÆ÷Ãû

ÔÚSQL server°²×°ÖÐÓÐÑ¡ÔñÊDzÉÓÃÓòÓû§»¹ÊDZ¾µØ·½Ê½£¬Ò»°ã¶¼ÊÇÑ¡±¾µØµÄ

ÒýÓÃ
SqlServer°²×°µÄ¹ý³ÌÖУ¬ÊDz»ÊÇÓÐÒ»¸öÓòµÄÅäÖ㬷þÎñÆ÷Ãû³ÆÊ¹Óñ¾»ú¼ÆËã»úÃû³Æ£¿
   ÊÇÕâÑùµÄ£¬ÓиöÓ¦ÓóÌÐò£¬½øÈëµÄʱºò¾ÍÌáʾ ÕÒ²»µ½·þÎñÆ÷£¬ ÎÒ¿´ÁËÆäËûµÄÅäÖ㬳ýÁËSqlServerµÄ°æ±¾²»Ò»ÑùÍ⣬¾ÍÊÇ·þÎñÆ÷µÄÃû³Æ£¬ÎÒÔÚ°²×°µÄ¹ý³ÌÖÐʹÓõÄÊÇĬÈÏ(local)£¬¶øÁ¬½Ó·þÎñÆ÷µÄÃû³ÆÊDZ¾»úµÄÃû³Æ¡£ÊÔÎÊÈçºÎÄܹ»Ð޸ĸÃSqlµÄ·þÎñÆ÷Ãû³Æ£¿
   »¹ÊÇÓÐÆäËûµÄ·½ÃæµÄ´íÎ󣿠       лл£¡£¡£¡

ÏÈPING·þÎñÆ÷¿´¿´Äܲ»ÄÜPINGͨ£¬ÔÙ¼ì²éÁ¬½Ó×Ö·û´®£¬ÔÙ²»Ðоͳ¢ÊÔ´ò²¹¶¡£¬ÔÙ²»Ðоͱ¸·ÝÒ»ÏÂÖØ×°Ò»±é¡£

SQL code:

ÅäÖÃÎļþ²»¶Ô...



ÒýÓÃ
SQL code
ÅäÖÃÎļþ²»¶Ô...


¿´ÆðÀ´£¬ÄãÊÇ×ö¹ýÀàËÆµÄ²Ù×÷£¬
  ˵À´ÌýÌý£¬ÅäÖÃÎļþÎÒÒ²×öÁË£¬¾ø¶ÔûÓÐÎÊÌ⣡£¡£


Ïà¹ØÎÊ´ð£º

°ÑÒ»¸ösqlserverÌáÈ¡µÄdataset²åÈëµ½sqlce

Êý¾Ý10WÌõÒÔÉÏ,wm6.5ƽ̨,ÄÚ´æÓÐÏÞ

C# code:
private void connserver()
{

Cursor.Current = Cursors.WaitCursor;
try
{
......

Çó½Ì ²é¿´SqlServerÖ´ÐйýµÄ´æ´¢¹ý³Ì״̬

ÔÚSqlServerÖÐÈçºÎ²é¿´ÀúÊ·ÉÏÖ´ÐеĴ洢¹ý³ÌµÄÐÅÏ¢ÄØ£¬È磺´«Èë²ÎÊý£¬Ö´ÐÐʱ¼äµÈµÈ¡£Èç¹û²»Äܲ鿴ÀúÊ·¼Ç¼£¬ÊÇ·ñ¿ÉÒÔ×Ô¼ºÐ´´¥·¢Æ÷Ö®ÀàµÄ£¬È˹¤¿ØÖÆÄØ£¬ÔÚOracleÀïÃæÓж¯Ì¬ÊÓͼ¿ÉÒÔËæÊ±²é¿´ÀúÊ·Ö´ÐеÄsqlÓï¾ä£¬SqlSer ......

±àдsqlserver´æ´¢À©Õ¹ÓÃc#ºÃ»¹ÊÇvb.netºÃ£¿

RT!

×¼±¸Ñ§Ò»Ñù¡£ÇóÎÊ£¬ÄÄÖÖ¸üºÏÊÊ£¿£¿
¶¼Ò»ÑùµÄ.Äãϲ»¶ÄÄÖÖ¾ÍÓÃÄÄÖÖ.

ÎÒ覺µÃ學C#ºÃ¡£µ«ÊÇÓÐͬÊÂ卻說VB.netºÃ¡£

Äã×Ô¼º¾õµÃ×Ô¼ºÄĸöÇ¿¾ÍѧÄĸö ÕæµÄ ֻҪѧµÃºÃ ¶¼Ò»Ñù
......

mfc³ÌÐòÓÃADOXÁ¬½ÓSqlServerµÄÎÊÌâ

ÎÒ¿´µÄÊǰ²×°Officeʱ×Ô´øµÄMicrosoft ActiveXÊý¾Ý¶ÔÏó2.5£¨ADO£©ÆäÖеÄÄÚÈݗĿ¼ÈçÏ£º
ADO³ÌÐòÔ±²Î¿¼
  ->ADOX API²Î¿¼
    ->ADOX´úÂë·¶Àý
      -> ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ