誰會用ASP.Net+MySQL寫連接數據庫的語句？

然後Dafault.aspx.cs文件開頭處加入這句 using System.Data.SqlClient;

再來就是protected void Page_Load(object sender, EventArgs e)

{

SqlConnection conn = new SqlConnection("Initial Catalog=數據庫名稱;Data Source=主機User ID=數據庫帳號;password=密碼");

SqlDataAdapter adp = new SqlDataAdapter("select * from 表名",conn);

SqlCommandBuilder scb = new SqlCommandBuilder(adp);

DataSet ds = new DataSet();

//DataTable dt = new DataTable();

adp.Fill(ds);

this.GrilView1.DataSource=ds;

this.GrilViewl.DataBind();

}