c# mysql 文件存储_C# 文件在数据库 的 存取

///

///获取数据库Image字段数据，保存到本地///

///

///

private void button2_Click(objectsender, EventArgs e)

{string constr = "Data Source=IP地址服务器地址;Initial Catalog=SunS;User ID=sa;Password=1321654";

SqlConnection con= newSqlConnection(constr);

SqlCommand cmd= newSqlCommand();

cmd.CommandText= "Select * from FileServer With (NoLock) Where FileName = '" + textBox1.Text + "'";

cmd.CommandType=CommandType.Text;

cmd.Connection=con;

con.Open();

DataTable dt= newDataTable();

SqlDataAdapter ad= new SqlDataAdapter(cmd);//cmd.EndExecuteReader();

ad.Fill(dt);

con.Close();

cmd.Dispose();byte[] pics1 = (byte[])dt.Rows[0]["CONTENT"];//的值强制转换;

writefile(pics1, "D://" + textBox1.Text + "");