ÎҵĵçÄÔÖØ×°ÁËϵͳ¡£ÖØ×°ºóɾ³ýÁËһЩÒÔÇ°°²×°µÄsqlserver Îļþ¡£ÖØװϵͳºóÏë°²×°sqlserver¡£ÓÃÐéÄâ¹âÇý°²×°¾µÏñÎļþµçÄÔȴû·´Ó¦¡£Çë¸ßÊÖÖ¸µãһϡ£ºÜ¼±¡£
û·´Ó¦£¿
ʲô´íÒ²²»±¨»¹ÊÇÔõôµÄ£¿
ÄѵÀ¾µÏñÎļþ¹ýÆÚ±äÖÊÁË?
ÕÒµ½ÀàËÆÏÂÃæµÄĿ¼£¬Ö±½ÓÖ´ÐÐÀïÃæµÄsetup.exe
sql server enterprise 2005\32BIT\ ......
ÎÒÏëÔÚÁíһ̨»úÆ÷ÉÏ·ÃÎʱ¾»úµÄsqlserver 2005 ¸ÃÔõôÅäÖá£Òª·ÃÎʵĻúÆ÷°²×°ÁËsqlserver 2005ÓõIJÙ×÷ϵͳÊÇwindows 2003 £¬Òª½øÐÐÔ¶³Ì·ÃÎʵĻúÆ÷Ò²°²×°ÁËsqlserver 2005 ÓõIJÙ×÷ϵͳÊÇwindows £Ø£Ð¡£¸ÃÔõôÅäÖòÅÄÜÈÃÁ½Ì¨»úÆ÷µÄÊý¾Ý¿â»¥Ïà·ÃÎÊ¡£ÏëÇë¸ßÊÖÖ¸µãһϡ£
ͨ¹ýipµØÖ·¾Í¿ÉÒÔ·ÃÎÊ¡£
ÊäÈëIP£¬Userid£¬password¾ ......
±ÈÈçsqlÓï¾äÊÇ£º
SQL code:
select top 300
CA01.A_id as '±ä¶¯´ÎÊý',
CA01.A0188 as 'ÈËÔ±id',
CA01.apname as 'ÉóÅúÕß',
CA01.CA0100 as 'È·ÈÏ״̬',
CA01.CA0101 as '±ä¶¯ÀàÐÍ',
CA01.CA0102 as 'ÉêÇë±ä¶¯ÈÕÆÚ' from CA01
ÓÐÁ½¸öÎÊÌ⣺
1£º Òª°Ñ²éѯ³öÀ´µÄÊý¾Ý·Åµ½Ò»¸öбíÖÐ
2£º ......
ÈçÌâ
Ö»ÓÐ100·Ö¸øÁË¡£¡£¡£
ÄĸöÐÐÒµ£¿
ÎÒÏëÍøÉϵÄÔ´Âë¿Ï¶¨²»ÄÜÍêÈ«Âú×ã¸öÈËÏë·¨
×îºó»¹µÃ×Ô¼ºÕû
ÍƼöÒ»¿î×ÔÖú½¨Õ¾Èí¼þ£º·çѶ
C#+SQL
¿ÉÒÔÉè¼Æ³ö±È½ÏÁé»îµÄÍøÕ¾
ʲôÐÐÒµ°¡....
µ½51aspx.comÀï¿´¿´,һЩ³£ÓôúÂ붼ÓÐ
ʲôÐÐÒµ£¿ ÕÒ¸öÈË×ö°É
ÍøÉ쵀 ²»ºÍ×Ô¼ºÒâµÄ
µ½°Ù¶È£¬Goo ......
Êý¾Ý10WÌõÒÔÉÏ,wm6.5ƽ̨,ÄÚ´æÓÐÏÞ
C# code:
private void connserver()
{
Cursor.Current = Cursors.WaitCursor;
try
{
DataSet ds = new DataSet();
SqlCeConnection conn = new SqlCeConnection(con ......
´úÂ룺
insert into openrowset('microsoft.ace.oledb.12.0','excel 12.0;hdr=yes;database=d:\a.xslx','select * from [sheet1$]') select * from table
×¢Ò⣺µ¼³öµÄÊý¾ÝºÍ±íÍ·ÒªÒ»Ö¡£
ÎÊÌ⣺
Èç¹û°´ÕÕÕâ¸ö×ö·¨½øÐе¼³öÊý¾Ý£¬Ôòµ¼³öµÄÊý¾ÝÔòÈ«²¿ÎªÎı¾ÐÎʽ£¬¶øÇÒÊý×ÖÒ²ÊÇÎı¾ÐÎ ......