学步园

解压后只需要把mysql.data.dll引入到项目里就可以用了

代码示例:

using MySql.Data.MySqlClient;

protected void btn_login_Click(object sender, EventArgs e)
{
    string mySqlCon = ConfigurationManager.ConnectionStrings["MySqlCon"].ConnectionString;

    MySqlConnection myCon = new MySqlConnection(mySqlCon);

    try
    {
        myCon.Open();

        MySqlCommand selSql = new MySqlCommand("Select * From tt.table Where uname=@uname", myCon);

        selSql.Parameters.Add("@uname", MySqlDbType.VarChar, 32).Value = this.txt_name.Text.Trim();

        MySqlDataReader mydr = selSql.ExecuteReader();

        while (mydr.Read())
        {
            if (mydr.HasRows)
            {
                Response.Write("<script type='text/javascript'>alert('" + mydr.GetString(0) + "') </script>");
            }
        }
        myCon.Close();
        mydr.Close();
    }
    catch (Exception ex)
    {
        Response.Write("<mce:script type='text/javascript'>alert(" + ex.ToString() + ")</mce:script>");
    }
}

//<connectionStrings>
//  <add name="MySqlCon" connectionString="Database=dbname;Data Source=127.0.0.1;User Id=root;Password=root;pooling=false;CharSet=utf8;port=3306" />
//</connectionStrings>

using MySql.Data.MySqlClient;

protected void btn_login_Click(object sender, EventArgs e)
{
	string mySqlCon = ConfigurationManager.ConnectionStrings["MySqlCon"].ConnectionString;

	MySqlConnection myCon = new MySqlConnection(mySqlCon);

	try
	{
		myCon.Open();

		MySqlCommand selSql = new MySqlCommand("Select * From tt.table Where uname=@uname", myCon);
			
		selSql.Parameters.Add("@uname", MySqlDbType.VarChar, 32).Value = this.txt_name.Text.Trim();

		MySqlDataReader mydr = selSql.ExecuteReader();

		while (mydr.Read())
		{
			if (mydr.HasRows)
			{
				Response.Write("<script type='text/javascript'>alert('" + mydr.GetString(0) + "') </script>");
			}
		}
		myCon.Close();
		mydr.Close();
	}
	catch (Exception ex)
	{
		Response.Write("<mce:script type='text/javascript'>alert(" + ex.ToString() + ")</mce:script>");
	}
}

//<connectionStrings>
//	<add name="MySqlCon" connectionString="Database=dbname;Data Source=127.0.0.1;User Id=root;Password=root;pooling=false;CharSet=utf8;port=3306" />
//</connectionStrings>

转载自黑色头发:http://heisetoufa.javaeye.com/

我的淘宝：http://shop58816553.taobao.com/