1.ASP.NET2.0链接MySQL数据库,查询数据。。。(使用了MySql.Data.dll)
using
MySql.Data.MySqlClient;
public partial class Msg : System.Web.UI.Page
{
protected void Page_Load( object sender, EventArgs e)
{
string conn = " server =localhost;uid=root;pwd=123;database=NewDB " ;
// string conn = "Data Source=127.0.0.1;User ID=root;Password=123;DataBase=NewDB;Allow Zero Datetime=true;Charset=gb2312;";
MySqlConnection con = new MySqlConnection(conn);
con.Open();
MySqlCommand cmd = new MySqlCommand( " select * from book " ,con);
MySqlDataReader dr = cmd.ExecuteReader();
GridView1.DataSource = dr;
GridView1.DataBind();
con.Close();
}
}
public partial class Msg : System.Web.UI.Page
{
protected void Page_Load( object sender, EventArgs e)
{
string conn = " server =localhost;uid=root;pwd=123;database=NewDB " ;
// string conn = "Data Source=127.0.0.1;User ID=root;Password=123;DataBase=NewDB;Allow Zero Datetime=true;Charset=gb2312;";
MySqlConnection con = new MySqlConnection(conn);
con.Open();
MySqlCommand cmd = new MySqlCommand( " select * from book " ,con);
MySqlDataReader dr = cmd.ExecuteReader();
GridView1.DataSource = dr;
GridView1.DataBind();
con.Close();
}
}