asp.net visual web developer 第二天 之 mysql连接

Default.aspx对应的cs文件内容

mysql官网下载 mysql-connector-net ，目前版本6.4.5，安装好后，将安装目录下的mysql.data.dll拷贝到asp.web工程目录的Bin目录，在visual web developer或者vs2008里的解决方案里新建Bin目录并添加mysql.data.dll文件即可使用了(ususing MySql.Data.MySqlClient;)

1. MySqlConnection（）// mysql连接

2. MySqlCommand（）//sql命令：sql语句

3. ExecuteReader（） //读取结果，表内容

 

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;

using MySql.Data.MySqlClient;

 

public partial class _Default : System.Web.UI.Page
{
            public   void   MessageBox(string   strText   ,Page   objPage)
        {  

            string   scriptStr,alertStr; 
            alertStr = "window.alert( ' "+strText+ " ') "; 
            scriptStr   =   " <script> "+alertStr+ " </script> ";
            objPage.RegisterClientScriptBlock( "failure ",IidScript);
        } 
       
         protected void Page_Load(object sender, EventArgs e)
         {

             string connStr = "server=127.0.0.1;uid=root;" + "pwd=123456;database=test;";

             MySqlConnection conn = new MySqlConnection(connStr);

             try
             {
                 Response.Write("hello");
                 conn.Open();

                 //DataTable table = conn.GetSchema("MetaDataCollections");
                 //DataTable table = conn.GetSchema("UDF");
                 //DisplayData(table);

                 
             }
             catch (MySql.Data.MySqlClient.MySqlException ex)
             {
                 //出错情况下才会进入

                 switch (ex.Number)
                 {
                     case 0:
                         MessageBox("Cannot connect to server.  Contact administrator",Page);
                         break;
                     case 1045:
                         MessageBox("Invalid username/password, please try again",Page);
                         break;
                 }

             }
             Response.Write("open database ok!");

             MySqlCommand cmd = new MySqlCommand();
            cmd.CommandText = "testtable";
            cmd.Connection = conn;
            cmd.CommandType = CommandType.TableDirect;
            MySqlDataReader reader = cmd.ExecuteReader();
            while (reader.Read())
            {
                Response.Write(reader[0] );       //第一字段
                Response.Write(" " + reader[1] );   //第二字段

              }

 

            conn.Close();

         }  //end page_load()
}

//更多的数据库操作api参考mysql-connection-net安装包里的mysql.data.chm帮助文档