asp textbox取得顯示mysql資料範例程式碼

這篇文章主要介紹了asp textbox如何取得顯示mysql數據,需要的朋友可以參考下

複製代碼代碼如下:

using MySql.Data.MySqlClient;

MySqlConnection conn = new MySqlConnection("server=(local);database=abc;uid=;pwd=");

conn.Open();

MySqlCommand com = new MySqlCommand("select * from tb_xxjj",conn);

MySqlDataReader dr = com.ExecuteReader();

dr.Read();

TB_xxjj.Text = dr["title"].ToString();

content.Text = dr["content"].ToString();