sql server表结构如下:
create table DataTable
(
Id int identity(1,1) not null primary key,
FileName nvarchar(100) not null,
FilePath nvarchar(200) not null,
Data varbinary(MAX)
)
主要方法:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.IO;
using System.Data;
using System.Data.SqlClient;
using System.Windows.Forms;
using System.Drawing;
namespace DataAccess
{
public class PubFunction
{
/// <summary>
/// 把文件存入数据库
/// </summary>
/// <param name="filePaths">文件路径(含文件名)</param>
/// <returns>存入是否成功</returns>
public static bool StoreFiles(string[] filePaths)
{
try
{
for (int i = 0; i < filePaths.Length; i++)
{
string filePath = filePaths[i];
string fileName = filePath.Substring(filePath.LastIndexOf("\\") + 1);
using (SqlConnection connection = new SqlConnection(PubVariant.ConnectionString))
{
connection.Open();
FileStream pFileStream = new FileStream(filePath, FileMode.Open, FileAccess.Read);
byte[] bytes = new byte[pFileStream.Length];
pFileStream.Read(bytes, 0, (int)pFileStream.Length);