表结构:
CREATE TABLE [dbo].[ExcelFile](
[FileName] [nvarchar](50) NOT NULL,
[Data] [image] NOT NULL, 注意字段类型
CONSTRAINT [PK_ProData] PRIMARY KEY CLUSTERED
(
[FileName] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
插入文件代码:
private void toolStripButtonAddFile_Click(object sender, EventArgs e)
{
OpenFileDialog ofd = new OpenFileDialog();
ofd.Multiselect = true;
if (ofd.ShowDialog() == DialogResult.OK)
{
foreach (string FileName in ofd.FileNames)
{
FileInfo info = new FileInfo(FileName);
string fileName = info.Name;
byte[] Data