Çë½ÌÒ»¸öC#Á¬½ÓMysqlµÄÎÊÌâ
ÎÒ°²×°ÁËMySQL Connector Net 6.2.2£¬ÏëÓÃC#À´Á¬½ÓmysqlÊý¾Ý¿â¡£ÒÔÏÂÊÇÁ¬½Ó²¿·ÖµÄ´ú
Â룺
string connStr =
String.Format("server={0};uid={1};pwd={2};database={3};charset=utf8",
"localhost", "root", "", "mysqldb");
conn = new MySqlConnection(connStr);
conn.Open();
ÎÒÔÚxpÏÂÓÃc# 2008expressÔËÐÐÕý³££¬µ«ÔÚwin7(64λ)ÏÂÓÃvs 2010beta»áÓС°¸ø¶¨¹Ø¼ü×Ö
²»ÔÚ×ÖµäÖС£¡±ÕâÑùµÄ´íÎó¡£Âé·³ÄÄλָµãһϣ¬·Ç³£¸Ðл£¡
My sqlÓÐÒ»¸öMySql.Data.dll
²Î¿¼FortuneBaseÖеĴúÂë,²Î¿¼www.cnblogs.com/mail-ricklee
ÎÒÒýÓõľÍÊÇÕâ¸ödllÁË.
¸Õ²Å·¢ÏÖÕâÑùд¿ÉÒÔÔËÐУº
MySqlConnectionStringBuilder connBuilder = new MySqlConnectionStringBuilder();
connBuilder.Add("Database", "mysqldb");
connBuilder.Add("Data Source", "localhost");
connBuilder.Add("User Id", "root");
connBuilder.Add("Password", "");
conn = new MySqlConnection(connBuilder.ConnectionString);
anyway¶àл¶àл
Ïà¹ØÎÊ´ð£º
DataSetµ¼³öxml Åú´¦Àí(Ñ»·)µÃÔõô´¦Àí
XMLÎļþ
<A>
<B>
<C>
</C>
&nb ......
ÒÔÏÂÊÇÒ»¶ÎJavsScript½Å±¾£¬µ«ÔËÐÐʱ×Ü»á²úÉú ¡°Microsoft JScript ÔËÐÐʱ´íÎó: 'null' Ϊ¿Õ»ò²»ÊǶÔÏó¡±Òì³££¬´ó¼Ò°ï¿´Ò»Ï¡£
<form id="form1" runat="server">
< ......
ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ
javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test
ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......
String SQL="insert into ѧÉúÐÅÏ¢±í values(StudentNumber,StudentName,StudentAge)";ÆäÖÐStudentNumber,StudentName,StudentAge¶¼ÊDZäÁ¿¡£ÕâÑùд²»¶Ô¡¡µ½µ×¸Ãզд°¡
Íò·Ö¸Ðл£¡
String SQL=&q ......
ÎÒÃÇC#×öÒ»¸ö´°Ìå ÍùÊý¾Ý¿âÀï²åÈëÊý¾Ý
SqlConnection cn = new SqlConnection("Data Source=20090713-1752\\SQLEXPRESS;Initial Catalog=goods;Integrated Security=True");
......