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

C#Ò»´ÎÁ¬½ÓÊý¾Ý¿âÖ´ÐжàÌõsqlÓï¾ä(ÈýÖÖ·½·¨)

µÚÒ»ÖÖ·½·¨:
            string str="server=.;uid=sa;pwd=111111;database=text_db";//Á¬½Ó×Ö·û´®
            SqlConnection SCON = null;//Á¬½Ó¶ÔÏó
            SqlCommand SCom=new SqlCommand();//ÃüÁî¶ÔÏó
            SCON=new SqlConnection(str);
            SCON.Open();
            SCom.CommandText = "insert into cum(nm,age,sex,addr) values(‘”+name1+”’, ‘”+age1+”’, ‘”+sex1”’,’”+addr1+”’); insert into cum(nm,age,sex,addr) values(‘”+name1+”’, ‘”+age1+”’, ‘”+sex1”’,’”+addr1+”’)";
            SCom.Connection = SCON;
            SCom.CommandType = CommandType.Text;
            int num = SCom.ExecuteNonQuery();
            SCON.Close();
            ×¢Ò⣺Õâ¾ÍÊÇÓ÷ֺŸô¿ª£¬°Ñ¶àÌõsqlÓï¾äд³ÉÁËÒ»ÌõsqlÓï¾äÀ´Ö´ÐУ¬ÒòΪûÓÐÓòÎÊý£¬¿ÉÄÜÓÐsql×¢Èë·çÏÕ¡£
µÚ¶þÖÖ·½·¨:
            string str="server=.;uid=sa;pwd=111111;database=text_db";//Á¬½Ó×Ö·û´®
            SqlConnection SCON;
            SqlCommand SCom1=new SqlCommand();//ÒªÖ´ÐÐsqlÓï¾äµÄµÚÒ»¸öÃüÁî¶ÔÏó
            SqlCommand SCom2=new SqlCommand();//Ò


Ïà¹ØÎĵµ£º

Sql Server ÖÐÒ»¸ö·Ç³£Ç¿´óµÄÈÕÆÚ¸ñʽ»¯º¯Êý

Sql Server ÖÐÒ»¸ö·Ç³£Ç¿´óµÄÈÕÆÚ¸ñʽ»¯º¯Êý
Select CONVERT(varchar(100), GETDATE(), 0): 05 16 2006 10:57AM
Select CONVERT(varchar(100), GETDATE(), 1): 05/16/06
Select CONVERT(varchar(100), GETDATE(), 2): 06.05.16
Select CONVERT(varchar(100), GETDATE(), 3): 16/05/06
Select CONVERT(varchar(100), GE ......

SQL ServerÈÕÖ¾ÎļþÌ«´óµÄ½â¾ö·½·¨

Çå¿ÕÈÕÖ¾
1£®´ò¿ª²éѯ·ÖÎöÆ÷£¬ÊäÈëÃüÁî
 
DUMP TRANSACTION Êý¾Ý¿âÃû WITH NO_LOG
 
2.ÔÙ´ò¿ªÆóÒµ¹ÜÀíÆ÷--ÓÒ¼üÄãҪѹËõµÄÊý¾Ý¿â--ËùÓÐÈÎÎñ--ÊÕËõÊý¾Ý¿â--ÊÕËõÎļþ--Ñ¡ÔñÈÕÖ¾Îļþ--ÔÚÊÕËõ·½Ê½ÀïÑ¡ÔñÊÕËõÖÁXXM,ÕâÀï»á¸ø³öÒ»¸öÔÊÐíÊÕËõµ½µÄ×îСMÊý,Ö±½ÓÊäÈëÕâ¸öÊý,È·¶¨¾Í¿ÉÒÔÁË¡£
 
  ......

C#ÖÐÓÃXmlTextReader¶ÔÏó²Ù×÷XMLÎļþ

sd.xmlÎļþ:
<?xml version="1.0" encoding="gb2312"?>
<!--ÕâÊÇÒ»¸öxmlÎļþ-->
<xml1>
  <item name="1">µÚÒ»¸öitem</item>
  <item name="2">
      <item name="1">Õâ¸ö½áµã(1) ......

ÔÚC#Àï´´½¨ºÍʹÓÃC·ç¸ñÊý¾Ý½á¹¹

ÔÚC#Àï´´½¨ºÍʹÓÃC·ç¸ñÊý¾Ý½á¹¹£¬¼´·ÇÍйܵÄÊý¾Ý½á¹¹£¬¿ÉÒÔÌá¸ßÐÔÄÜ¡£
1 Êý¾Ý½á¹¹µÄ¶¨Òå
¿´ÏÂÃæÀý×Ó£º
    unsafe struct A {
        public int x;
    }
    unsafe struct B {
        pu ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ