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 + "");

}public void writefile(byte[] pics, stringfilename)

{

FileStream fs= newFileStream(filename, FileMode.Append, FileAccess.Write);

BinaryWriter bw= newBinaryWriter(fs);

bw.Write(pics,0, pics.Length);

bw.Close();

fs.Close();

}///

///将文件转换成byte数组，写入数据库///

///

///

private void button1_Click(objectsender, EventArgs e)

{

FileInfo finfo= new FileInfo("D://" + textBox1.Text); //绝对路径

if(finfo.Exists)

{

SqlConnection conn= new SqlConnection( "Data Source=IP地址服务器地址;Initial Catalog=Sun;User ID=sa;Password=1312313");

SqlCommand InsertCommand= newSqlCommand();

InsertCommand.Connection=conn;

InsertCommand.CommandText= "UPDATE FileServer SET CONTENT =@Content WHERE [FILENAME] = '" + textBox1.Text + "'";

InsertCommand.Parameters.Add("@Content", SqlDbType.Image, (int)finfo.Length, "CONTENT"); //注意，此处参数Size为写入的字节数//读取文件内容，写入byte数组

byte[] content = new byte[finfo.Length];

FileStream stream=finfo.OpenRead();

stream.Read(content,0, content.Length);

stream.Close();

InsertCommand.Parameters["@Content"].Value = content; //为参数赋值

try{

conn.Open();

InsertCommand.ExecuteNonQuery();

}finally{

conn.Close();

}

}

}