本节介绍使用C#操作MySQL数据库中的二进制大对象BLOB,实现了位图的存储和读取。
1.建立和MySQL的连接
private void btnConnect_Click(object sender, EventArgs e)
{
if (m_con != null)
{
m_con.Close();
m_con = null;
}
m_con = new MySqlConnection();
m_con.ConnectionString = "server=localhost;user id=root;password=123456;database=test";
try
{
m_con.Open();
lblInfo.ForeColor = Color.White;
lblInfo.Text = "连接成功";
}
catch (MySqlException e1)
{
lblInfo.ForeColor = Color.Red;
lblInfo.Text = e1.Message;
}
}
2.以ASCII码编码存储位图数据
private void btnAscii_Click(object sender, EventAr