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

C#ÀûÓÃsql½Å±¾Éú³ÉÊý¾Ý¿â

ÏÖÔÚÓиöa.sqlÎļþ£¬c#ÖÐÔõôִÐÐËüÉú³ÉÊý¾Ý¿â£¿
Ö´ÐÐËü°¡

ÔõôִÐУ¿´úÂ룿

ExecuteNonQuery()

ÓÐÍêÕûµÄÂð£¿


string sql="¶ÁÈ¡txtµÃµ½µÄ×Ö·û´®"


ExecuteNonQuery()

pr.StartInfo.Arguments = "-U sa -P sa -d master -s 127.0.0.1 -i Sql.sql";

Õâ¸ö¿ÉÒÔÓÃwindowsµÄµÇ½Âð£¬ÒòΪsaδ±ØÄÜÓÃ

System.Diagnostics.Process sqlProcess = new System.Diagnostics.Process();
sqlProcess.StartInfo.FileName = "osql.exe";
sqlProcess.StartInfo.Arguments = string.Format(" -U {0} -P {1} -d {2} -i {3}/db.sql", this.Context.Parameters["user"], this.Context.Parameters["pwd"], this.Context.Parameters["dbname"], this.Context.Parameters["targetdir"]);
sqlProcess.StartInfo.WindowStyle = System.Diagnostics.ProcessWindowStyle.Hidden;
sqlProcess.Start();
sqlProcess.WaitForExit();

²»ÒªÔ¶³ÌµÄ£¬Ö»ÒªÔÚ±¾µØÉú³ÉÊý¾Ý¿â

°ï¶¥Ò»¸ö £¡£¡£¡£¡

дһ¸öÅú´¦Àí.batÎļþ£¬Åú´¦Àíµ÷ÓÃSQLÎļþ£¬È»ºóC#Ö´ÐÐÕâ¸öÅú´¦Àí¡£

²éѯ·ÖÎöÆ÷Ö´ÐоÍÐÐÁË


Ïà¹ØÎÊ´ð£º

sqlת»»ÎÊÌ⣬¼±£¡ - ÉçÇøÖ§³Ö / ¡¶³ÌÐòÔ±¡·ÔÓÖ¾

select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......

c#¿ØÖÆMysql ʵÏÖ×Ô¶¯É¾³ý¹¦ÄÜ - .NET¼¼Êõ / C#

Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......

sqlÓï¾äµÄÎÊÌâ - MS-SQL Server / »ù´¡Àà

ÓÐ2¸ö±í°¡£º 
±íÃû£ºyh 
Óû§±àÂë Óû§Ãû³Æ  
001 a 
002 b 
003 c 
±íÃû£ºys 
Óû§±àÂë ±¾ÆÚÖ¸Êý ³­±íʱ¼ä 
  001 ......

C# DataSetµ¼³öxml Åú´¦Àí(Ñ­»·)µÃÔõô´¦Àí

DataSetµ¼³öxml Åú´¦Àí(Ñ­»·)µÃÔõô´¦Àí
XMLÎļþ
<A>
      <B>
        <C>
        </C>
  &nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ