C#.NETÁ¬½Ómysql·½·¨
Ò»¡£ mysql.data.dll¿½±´µ½binÏÂÃæ²¢ÒýÓÃÒ»ÏÂ
using MySql.Data.MySqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string myConnectionString = "Database=test;Data Source=localhost;User Id=root;Password=admin";
MySqlConnection mycn = new MySqlConnection(myConnectionString);
try
{
mycn.Open();
Response.Write("<mce:script type="text/javascript"><!--
alert('Á¬½Ó³É¹¦')
// --></mce:script>");
}
catch (Exception ex)
{
Response.Write("<mce:script type="text/javascript"><!--
alert(" ex.ToString() ")
// --></mce:script>");
}
}
}
Ò²¿ÉÒÔÅäÖÃapp.config (web.config):
<appSettings>
<add key="Con" value="Provider=MySQLProv;Data Source=test;User Id=root;Password=admin;pooling=false;CharSet=utf8;port=3306"/>
</appSettings>
¶þ¡£ÒªÌí¼Ó¶ÔMySql.Data.dllµÄÒýÓá£
Á¬½Ó£º
string connStr = "server=localhost;user id=root; password=; database=aa; pooling=false";//
Á¬½Ó×Ö·û´®
ÒÔÏÂΪÒýÓõÄÄÚÈÝ£º
MySqlConnection conn = new MySqlConnection( connStr );//¹¹ÔìÊý¾Ý¿âÁ¬½Ó
try
{
conn.Open();//´ò¿ªÁ¬½Ó
MySqlCommand cmd = new MySqlCommand("select * from list",conn);//¹¹Ôì²éѯÃüÁî
this.DataGrid1.DataSource=cmd.ExecuteReader();//Ö´Ðвéѯ£¬·µ»ØÒ»¸öDataReader£¬ÉèÖÃDataGrid1µÄÊý¾ÝԴΪ¸ÃDataReader
Ïà¹ØÎĵµ£º
°²×°Íêphpmyadmin
´ó¼Ò¾³£³öÏÖµÄÎÊÌâ¾ÍÊDZ¨´í£º“ÎÞ·¨ÔØÈëmysqlÀ©Õ¹£¬Çë¼ì²éphpÅäÖÔ¡£
Èç¹ûÄãʹÓõÄÊÇphp5.2ÒÔÉϵİ汾£¬Çë×¢Ò⣺php¶Ô·þÎñµÄÀ©Õ¹¹¦ÄÜ×öÁËÒ»¶¨µÄ¸Ä¶¯£¬Ò²¾ÍÊÇ˵£¬Äã°²×°phpºÍÀ©Õ¹µÄ·½Ê½Ò²Òª×öµ÷ÕûÁË¡£
Ö÷ÒªµÄµ÷ÕûÓÐÁ½·½Ã棬һÊÇPHP5.2ÒÔÉϵİ汾ÖУ¬PHP.INIÎļþÎÞÐèÌí¼Óµ½WINDOWSĿ¼Ï¡£¶þ ......
Unix&Linux£º
1.ÓÃroot»òÕßÔËÐÐmysqldµÄÓû§µÇ¼ϵͳ£»
2£®ÀûÓÃkillÃüÁî½áÊøµômysqldµÄ½ø³Ì£»
3£®Ê¹ÓÃ--skip-grant-tables²ÎÊýÆô¶¯MySQL Server
shell>mysqld_safe --skip-grant-tables &
4.Ϊroot@localhostÉèÖÃÐÂÃÜÂë
shell>mysqladmin -u root flush-privileges password "newpassword" ......
CÊÇÃæÏò¹ý³ÌµÄ³ÌÐòÉè¼Æ£¬³ÌÐò=Êý¾Ý½á¹¹+Ëã·¨ [×îÔʼ£¬µ«±à¸ö³Ìȷʵ²»Ò×]
C++ÊÇÃæÏò¶ÔÏóµÄ³ÌÐòÉè¼Æ£¬³ÌÐò=¶à¸öÀà+ÏûÏ¢(Àà=Êý¾Ý½á+Ëã·¨)[±È½ÏÈÝÒ×ÉÏÊÖ]
C# ÊÇ´¿ÃæÏò¶ÔÏóµÄÓïÑÔ[¸ü¼Ó±È½ÏÈÝÒ×ÉÏÊÖ]
VC/VC++/VC# Ö»ÊÇÓÃÀ´¿ª·¢C/C++/C#Ó¦ÓóÌÐòµÄÈí¼þÖеÄÒ»ÖÖ¡£
......
[ת]asp.netµ¼³öExcel/Csv¸ñʽÊý¾Ý×îÓÅ·½°¸£¨C#£©
±¾ÎÄת×Ô£ºhttp://www.cnblogs.com/lovenets2008/archive/2008/05/06/1184234.html
ÔÎÄÈçÏ£º
ºÃ¾ÃûÓÐдµãʲôÁË£¬Ò²ÐíÊÇ̫æ¡£Ò»ÄêÁË£¬»ýÀÛÁ˲»ÉٺõĶ«¶«£¬Óлú»áʱ¾Íд³öÀ´Óë´ó¼Ò·ÖÏí¡£
ºÃ£¬ÑÔ¹éÕý´«¡£
µ¼³öµ½Excel/CscÎļþ²¢²»ÄÑ£¬ËùÒÔ¾ÍÓкö෽·¨£ ......
ÔÎÄÁ´½Ó£ºhttp://bbs.linuxtone.org/thread-991-1-1.html
ITÔËάר¼ÒÍø--"×ÔÓÉƽµÈ£¬»¥Öú·ÖÏí£¡"
===MySQL»ù´¡====
mysql
ÏÂÔØ
: http://www.mysql.com/
mysqld ³£¹æMySQL·þÎñÆ÷
mysqld-opt ÓÅ»¯
mysql·þÎñ
Æ÷,ÌṩһЩ¹¦ÄÜ¿ÉÒÔÍÚ¾ò¸üºÃµÄ¹¦ÄÜ
mys ......