using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.IO;

namespace 创建数据库图像表
{
    class Program
    {
        string imageFileLocation = @"E:\图片\难忘的初恋\";
        int maxImageSize = 10000;
        SqlConnection conn = null;
        SqlCommand cmd = null;
        static void Main(string[] args)
        {   
            int i;
            Program pg = new Program();
            pg.OpenConn();
            pg.Command();
            pg.CreateImageTable();
            pg.PrepareInsertImages();
            for (i = 1; i < 17; i++)
            { pg.ExecuteInsertImages(i); }

        }
        void OpenConn()
        {
            conn = new SqlConnection(@"server=PC-201001021356;integrated security=true;database=demo");
            conn.Open(); 
        }
        void CloseConn()
        { 
            conn.Close(); 
        }
        void Command()
        {
            cmd = new SqlCommand();
            cmd.Connection = conn;
        }
        void ExecuteCommand(String cmdText)
        { 
            cmd.CommandText = cmdText;
            cmd.ExecuteNonQuery();
         }
        void CreateImageTable()
        {
            ExecuteCommand(@"create table 图像表 (图形文件 nvarchar(20),图形数据 varbinary(max))");
        }
        void PrepareInsertImages()
        {
            cmd.CommandText = @"insert into 图像表 (图形文件,图形数据) values(@imagefile,@imagedata)";
            cmd.Parameters.Add("@imagefile", SqlDbType.NVarChar, 20);
            cmd.Parameters.Add("@imagedata", SqlDbType.Image, 1000000);
            cmd.Prepare();
        }
        void ExecuteInsertImages(int imageFileNumber)
        {
            string imageFileName = "图片" + imageFileNumber.ToString() + ".gif";
            byte[] imageData = loadimageFile(imageFileName, imageFileLocation, maxImageSize);
            cmd.Parameters["@imagefile"].Value = imageFileName;
            cmd.Parameters["@imagedata"].Value = imageData;
        }
        byte[] loadimageFile(string fileName, string fileLocation, int maxSize)
        { 
            byte[] imagebytes = null;
            string fp = fileLocation + fileName;
            FileStream fs = new FileStream(fp, FileMode.Open, FileAccess.Read);
            BinaryReader br = new BinaryReader(fs);
            imagebytes = br.ReadBytes(maxSize);
            return imagebytes;
        }
    }
}
其中这一句string imageFileName = "图片" + imageFileNumber.ToString() + ".gif";我一运行 它就会提示我没有找到图片路经 我确定 我的文件名字正确 路径也是对的 为什么就是找不到呢 数据库里的表也创建出来了很正常 就是找不到图片路径   求教高手啊