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#Ö´ÐÐÕâ¸öÅú´¦Àí¡£
²éѯ·ÖÎöÆ÷Ö´ÐоÍÐÐÁË
Ïà¹ØÎÊ´ð£º
select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......
Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......
ÓÐ2¸ö±í°¡£º
±íÃû£ºyh
Óû§±àÂë Óû§Ãû³Æ
001 a
002 b
003 c
±íÃû£ºys
Óû§±àÂë ±¾ÆÚÖ¸Êý ³±íʱ¼ä
001 ......
DataSetµ¼³öxml Åú´¦Àí(Ñ»·)µÃÔõô´¦Àí
XMLÎļþ
<A>
<B>
<C>
</C>
&nb ......