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

C#Á¬½ÓmysqlÊý¾Ý¿â

using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using MySql.Data.MySqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
string mySqlConnectionString="Database=newdb;Data Source=localhost;User Id=root;Password=";
using (MySqlConnection myCon = new MySqlConnection(mySqlConnectionString))
{
using (MySqlCommand cmd = new MySqlCommand("INSERT INTO Test(uid,regdate,remark) values(@uid,curdate(),@remark)", myCon))
{
cmd.Parameters.Add(new MySqlParameter("@uid",this.TextBox1.Text.Trim()));
cmd.Parameters.Add(new MySqlParameter("@remark",this.TextBox2.Text.Trim()));
myCon.Open();
if(cmd.ExecuteNonQuery()==1)
{
Response.Write("<mce:script type="text/javascript"><!--
alert('³É¹¦Ìí¼ÓÁËÒ»Ìõ¼Ç¼')
// --></mce:script>");
}
else
{
Response.Write("<mce:script type="text/javascript"><!--
alert('Ìí¼Óʧ°Ü£¡£¡£¡')
// --></mce:script>");
}
}
}
}
}


Ïà¹ØÎĵµ£º

[MySQL 5.1 ÌåÑé]MySQL ʼþµ÷¶ÈÆ÷(Event Scheduler)

http://hi.baidu.com/tianxia_1209/blog/item/a2613822fec7e7f6d6cae267.html
MYSQLµÄʼþÊÇ5.1ÐÂÔö¼ÓµÄ£¬Èç¹ûÏëÌåÑ飬½¨ÒéÉý¼¶°æ±¾¡£
ÖÁÓÚÓï·¨ÎҾͲ»¶à˵ÁË£¬ÊÖ²áÉϽ²µÄºÜÏêϸ£¬ÎÒÀ´ËµËµ¼¸¸öÒªµãÒÔ¼°Ò»Ð©ÊµÀý¡£
×¢ÒâÊÂÏ
1¡¢EVENTȨÏÞÊÇÕë¶ÔģʽµÄ£¨ÔÚMYSQLÖÐÒ²¾ÍÊÇ¿âµÄ¼¶±ð£©£¬²»ÄܶԵ¥¶À±íÀ´¸³ÓèȨÏÞ¡£
2¡¢±ØÐëÔÚ ......

MySQLÊý¾Ý¿â±¸·ÝµÄ»ù´¡ÖªÊ¶´óÈ«

ƽʱÎÒÃÇÔÚʹÓÃMySQLÊý¾Ý¿âµÄʱºò¾­³£»áÒòΪ²Ù×÷ʧÎóÔì³ÉÊý¾Ý¶ªÊ§£¬MySQLÊý¾Ý¿â±¸·Ý¿ÉÒÔ°ïÖúÎÒÃDZÜÃâÓÉÓÚ¸÷ÖÖÔ­ÒòÔì³ÉµÄÊý¾Ý¶ªÊ§»ò×ÅÊý¾Ý¿âµÄÆäËûÎÊÌâ¡£
¡¡¡¡Ò»¡¢Êý¾Ý±¸·Ý½Ý¾¶
¡¡¡¡ÒòΪÕâ¸ö·½·¨Ã»Óеõ½¹Ù·½ÕýʽÎĵµµÄÑéÖ¤£¬ÎÒÃÇÔݳÆÎªÊÔÑé°É¡£
¡¡¡¡Ä¿µÄ£º±¸·ÝhostAÖ÷»úÖÐÒ»¸öMySQLÊý¾Ý¿â±¸·ÝTestA£¬²¢»Ö¸´µ½µ½hostB»úÖÐ ......

C# µ¥ÊµÀýÉè¼ÆÄ£Ê½

SingletonģʽµÄʵÏÖ
SingletonģʽµÄʵÏÖ»ùÓÚÁ½¸öÒªµã£º
1£©²»Ö±½ÓÓÃÀàµÄ¹¹Ô캯Êý£¬¶øÁíÍâÌṩһ¸öPublicµÄ¾²Ì¬·½·¨À´¹¹ÔìÀàµÄʵÀý¡£Í¨³£Õâ¸ö·½·¨È¡ÃûΪInstance¡£Public±£Ö¤ÁËËüµÄÈ«¾Ö¿É¼ûÐÔ£¬¾²Ì¬·½·¨±£Ö¤Á˲»»á´´½¨³ö¶àÓàµÄʵÀý¡£
2£©½«ÀàµÄ¹¹Ô캯ÊýÉèΪPrivate£¬¼´½«¹¹Ô캯Êý"Òþ²Ø"ÆðÀ´£¬ÈÎºÎÆóͼʹÓù¹Ô캯Êý´´½¨Ê ......

C#¾«Ë衾Ô¶ùÔ­´´¡¿µÚËĽ² GridView 72°ã¾ø¼¼

˵Ã÷£º×¼±¸³öÒ»¸öϵÁУ¬Ëùν¾«Ëè½²C#ÓïÑÔÒªµã¡£Õâ¸öϵÁÐûÓÐÏȺó˳Ðò£¬²»¹ý¾¡Á¿×öµ½¾«¡£¿ÉÄܻ᲻¶ÏÔöɾÕûÀí£¬±¾ÏµÁÐ×îԭʼ³ö´¦ÊÇcsdn²©¿Í,лл¹Ø×¢¡£
C#¾«Ëè
µÚËĽ² GridView 72°ã¾ø¼¼
×÷ÕߣºÇåÇåÔ¶ù
Ö÷Ò³£ºhttp://blog.csdn.net/21aspnet/           ʱ¼ä£º2007. ......

MySQL 5.1.42 ·¢²¼

MySQL 5.1 ÊÇ MySQL Êý¾Ý¿âĿǰ·¢²¼µÄ×îеÄÎȶ¨°æ±¾£¨5.5ÊÇbeta״̬£¬6.0ÊÇalpha״̬£©¡£
¸Ã°æ±¾Ôö¼ÓÁ˶ÔÏÂÃæ¼¸¸öƽ̨µÄÖ§³Ö£º
Mac OS X 10.6 x86/x64
HP-UX 11.31 IA64
SLES 11 x86/x64
InnoDB ²å¼þÉý¼¶µ½ 1.0.6 °æ±¾£¬ÁíÍâͨ¹ý¶Ô²éѯ»º´æµÄË鯬ÓÅ»¯ÌáÉýÁËÐÔÄÜ£¬¸ü¶àÏêϸµÄÄÚÈÝÇë¿´ÕâÀï¡£
ÏÂÔØµØÖ·£ºhttp://dev. ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ