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

C# SqlServer - .NET¼¼Êõ / C#

C# code:

SqlConnection myConn = new SqlConnection("Server=localhost;Database=Scores;uid=sa;pwd=;");
SqlCommand cmd= new SqlCommand();;
cmd.CommandType = System.Data.CommandType.Text;
myConn.Open();
cmd.CommandText = "insert into INFO(ѧºÅ) values ('111')";
int num = cmd.ExecuteNonQuery();
cmd.Connection = myConn;


ΪʲôûÓ𡣿´ó¼Ò°ï°ï棡Êý¾Ý¿âÖеıíû±ä°¡£¡

cmd.Connection = myConn;  
·Åµ½µÚ3ÐÐÈ¥

ÒªÏÈΪSqlCommand¶ÔÏóÖ¸¶¨SqlConnectionÁ¬½Ó£¬È»ºóÔÙÖ´ÐÐÃüÁî¡£

ÒýÓÃ
cmd.Connection = myConn;
·Åµ½µÚ3ÐÐÈ¥

¶÷ UP

ȷʵȷʵ£¬Ð»Ð»¶þ룬µ«ÊÇÎªÊ²Ã´ÄØ£¿

cmd.Connection = myConn; ·ÅÔÚ int num = cmd.ExecuteNonQuery(); Ç°ÃæÖ´ÐоÍOKÁË

SqlConnection myConn = new SqlConnection("Server=localhost;Database=Scores;uid=sa;pwd=;");
  myConn.Open();
  SqlCommand cmd= new SqlCommand('insert into INFO(ѧºÅ) values ('111')',myConn);
  int num = cmd.ExecuteNonQuery();
  myConn.Close();

1¡¢2Â¥¶¼ÕýÈ· 
ÊÂʵÉϰÑcmd.Connection = myConn; 
·Åµ½num = cmd.ExecuteNonQuery();֮ǰ¾ÍÐУ¬
cmdÒªÓÐÁ¬½Ó ²¢ÇÒÁ¬½Ó´ò¿ª²ÅÄÜexcute


Ïà¹ØÎÊ´ð£º

java³ÌÐòÁ¬½ÓSQlServerµÄÎÊÌâ - Java / Java SE

import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class QueryTest&n ......

ÀûÓÃC#±àдtxtת»¯µ½xmlµÄ³ÌÐò

txt ºÍXML ¸ñʽÏàÓ¦
²»½èÖúDataSet
µ¼Èë¶ÁÈ¡TXTÎļþ
È»ºóÖ±½ÓдÈëXML(ͬһÎļþ,²»Í¬Êý¾Ý,µÝÔöÔ­Êý¾ÝûÓб»¸²¸ÇÇé¿öÏÂÔö¼ÓÊý¾Ý.)
½Ì¸öÒªµã»ò×îºÃÊÇÓиö´úÂëÌáʾµÄ
¹ý·ºÃºº °ï¸öæÈö^^
²»»á£¬°ïÂ¥Ö÷ ......

C/C++ÖÐÓÐûÓиñʽ»¯UÅ̵ĺ¯Êý - C/C++ / C++ ÓïÑÔ

´ó¼ÒºÃ£º
ÎÒÏëʵÏÖ¼ì²âµ½²åÈëSD¿¨ºó×Ô¶¯½«SD¿¨¸ñʽ»¯µÄ¹¦ÄÜ£¬²»ÖªC/C++ÖÐÓÐûÓиñʽ»¯UÅ̵ĺ¯Êý£¿
ÁíÍ⣬ÎÒ²»ÏëʹÓÃSHFormatDrive£¬ÒòΪÕâ¸öº¯Êý»áµ¯³öÊÇ·ñÒª¸ñʽ»¯µÄÌáʾ¿ò£¬ÎÒÐèÒªµÄÊÇϵͳ×Ô¶¯¸ñʽ»¯£¬¶ø²Ù×÷Õß² ......

±éÀúÒ»¸öxml²¢Êä³öÖ¸¶¨½ÚµãµÄÖµ - .NET¼¼Êõ / C#

ÎÒÓÐÒ»¸öÀàËÆµÄxmlµÄ string£¬Ïëͨ¹ý±éÀúÔõô¸öxml Êä³öÎÒÏëÒªµÄelementµÄÖµ
xml Ϊ£º
<Discover xmlns="urn:schemas-microsoft-com:xml-analysis">
  <RequestType>DISCOVER_XML_ME ......

Çë½ÌSQLSERVERµÄÁ½¸öÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

1¡£ÔõÑùʹxp_cmdshellÄÜÍêÕûÊä³ö³¬¹ý255¸ö×Ö·ûµÄ×Ö·û´®¡£
2¡£select ʱ£¬¼ìË÷ËÙ¶ÈÊÇÓëfromºóµÄ TABLE˳ÐòÓйأ¬»¹ÊÇÓëwhereÌõ¼þµÄ˳ÐòÓйØ(TABLEÊý¾Ý¶àÉÙ )
ÔÚϵͳÊôÐÔÉ趨ÀïÓиöÑ¡Ïî,¿ÉÒÔÐ޸ĵ¥×Ö¶ÎÊä³ö×ÖÊýÏÞÖÆ. ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ