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
Ïà¹ØÎĵµ£º
InnoDBÊÇmysqlÊý¾Ý¿âÖÐΨһһ¸öÖ§³ÖÍâ¼üµÄÒýÇæ£¬µ«ÊDzîÖµµÄʱºòÈ´µÃ×¢ÒâÒ»ÏÂ
±ÈÈçÓÐÁ½ÕÅ±í£¬album(id,name,path) £¬picture(id,name,path,parent_album)£¬ÆäÖбí2ÖÐparent_albumÊÇÍâ¼ü
´Ëʱ²îÖµinsert into picture (name,path,parent_album) values ("pic","path",68) (68ÊÇÒ»¸öÏà²áµÄid)
mysql»á±¨´í"Failed to read a ......
[ת]asp.netµ¼³öExcel/Csv¸ñʽÊý¾Ý×îÓÅ·½°¸£¨C#£©
±¾ÎÄת×Ô£ºhttp://www.cnblogs.com/lovenets2008/archive/2008/05/06/1184234.html
ÔÎÄÈçÏ£º
ºÃ¾ÃûÓÐдµãʲôÁË£¬Ò²ÐíÊÇ̫æ¡£Ò»ÄêÁË£¬»ýÀÛÁ˲»ÉٺõĶ«¶«£¬Óлú»áʱ¾Íд³öÀ´Óë´ó¼Ò·ÖÏí¡£
ºÃ£¬ÑÔ¹éÕý´«¡£
µ¼³öµ½Excel/CscÎļþ²¢²»ÄÑ£¬ËùÒÔ¾ÍÓкö෽·¨£ ......
×î½üÔÚѧϰSSH£¬ÓÉÓÚΪÁ˽ÚÔ¼Äڴ棬ËùÒÔ¾Í×¼±¸Ê¹ÓÃMYSQL´úÌæOracle£¬ÎªÁ˸üÉîÒ»²½µØÁ˽âMySQL£¬ÓÚÊǾͼƻ®°²×°noinstall°æ±¾£¬Õâ°æ±¾±È°²×°°æ¿ÉÂ鷳һЩ£¬ÌرðÊÇÅäÖ÷½Ã棬Èç¹ûÅäÖúõϰ¾Í¿ÉÒÔÔÚһ̨»úÆ÷ÉÏÔËÐжà¸ö°æ±¾µÄMYSQL£¬ÔÚÍøÉÏÕÒÁËǰ±²ÃǵıʼǺóѧϰÍê±ÏºóÔټǼһ±Ê£¬¾ÍÎÒÕâ¼ÇÐÔ£¬¹À¼ÆÃ ......
Java ºÍ C#µÄ±È½Ï
1¡£·ÃÎÊ¿ØÖÆ·½Ã棺C#ÓÐpublic¡¢internal¡¢protected¡¢private£¬±Èjava¶àÁ˸öinternal£¬ÆäʵËü¸újavaµÄ°ü·ÃÎʲ¶à£¬internal±íʾͬһ¸ö±àÒ뼯ºÏ£¨Èçexe¡¢dll£©ÏµÄÀà¿ÉÒÔ»¥·Ã¡£
¶ÔÓÚprotected£¬javaºÍC#ÓÐÇø±ð¡£ÔÚjavaÖУ¬protectedºÍ°ü·ÃÎʼ¶±ð²î²»¶à£¬¼´²»ÊÇ˽Óеġ£¶øÔÚC#ÖУ¬protectedºÍpriv ......
ΪʲôѡÔñÔ´Âë±àÒë°²×°mysql£ºÎÒÔÚʹÓÃrpm»òÕßÊÇyum°²×°Ê±myql£¬ÀÏÊÇÌáʾÎÒÕÒ²»µ½*.sockÎļþ£¬ÕÒÁ˵ã
×ÊÁÏ˵ÊǸðüÊǷǹٷ½°æ±¾£¨Ã÷Ã÷Êǹٷ½ÏÂÔØ µÄ£©£¬ÆäÖÐÔÒòµ½ÏÖÔÚ»¹Ã»ÓиãÇå³þ¡£Ï£ÍûÖªÇéÈËÊ¿¸æÖª¡££¨¿ªÊ¼±àÒëµÄʱºò£¬ÏµÍ³»·¾³Ò»¶¨ÒªÅäÖúã¬GCC£¬GC++...µÈµÈµÄ±àÒëÆ÷Ò»¶¨Òª×öºÃ,±¾È˵ÄcentosÓÉÓÚ¿ªÊ¼
ϵͳ»·¾³Ã»ÅäÖ ......