将文件保存到数据库中

   //保存文件到SQL Server数据库中
    private void FileToSql(string fileName,string tableName,string fieldName)
    {
        SqlConnection cn=new SqlConnection ();
        FileInfo fi=new FileInfo(fileName);
        FileStream fs=fi.OpenRead();
        byte[] bytes=new byte[fs.Length];
        fs.Read(bytes,0,Convert.ToInt32(fs.Length));
        SqlCommand cm=new SqlCommand();
        cm.Connection=cn;
        cm.CommandType=CommandType.Text;
        if(cn.State==0) cn.Open();
        cm.CommandText="insert into "+tableName+"("+fieldName+") values(@file)";
        SqlParameter spFile=new SqlParameter("@file",SqlDbType.Image);
        spFile.Value=bytes;
        cm.Parameters.Add(spFile);
        cm.ExecuteNonQuery();
    }
//保存文件到Access数据库中
    private void FileToAccess(string fileName,string tableName,string fieldName)
    {
        OleDbConnection cn=new OleDbConnection ();
        FileInfo fi=new FileInfo(fileName);
        FileStream fs=fi.OpenRead();
        byte[] bytes=new byte[fs.Length];
        fs.Read(bytes,0,Convert.ToInt32(fs.Length));
        OleDbCommand cm=new OleDbCommand();
        cm.Connection=cn;
        cm.CommandType=CommandType.Text;
        if(cn.State==0) cn.Open();
        cm.CommandText="insert into "+tableName+"("+fieldName+") values(@file)";
        OleDbParameter spFile=new OleDbParameter("@file",OleDbType.Binary);
        spFile.Value=bytes;
        cm.Parameters.Add(spFile);
        cm.ExecuteNonQuery();
    }
    //保存客户端文件到数据库,fl_name为上传控件
    private void FileToDataSourse(string mailid)
    {
        string ConnStr = "";
        string sql = "update t_mail set attachfilename=@attachfilename,attachfile=@attachfile where mailid=" + mailid;
        SqlCommand myCommand = new SqlCommand(sql, new SqlConnection(ConnStr));
        string path = fl_name.PostedFile.FileName;
        string filename = path.Substring(path.LastIndexOf("") + 1, path.Length - path.LastIndexOf("") - 1);
        myCommand.Parameters.Add("@attachfilename", SqlDbType.VarChar);
        myCommand.Parameters["@attachfilename"].Value = filename;
        myCommand.Parameters.Add("@attachfile", SqlDbType.Image);
        Stream fileStream = fl_name.PostedFile.InputStream;
        int intFileSize = fl_name.PostedFile.ContentLength;
        byte[] fileContent = new byte[intFileSize];
        int intStatus = fileStream.Read(fileContent, 0, intFileSize); //文件读取到fileContent数组中
        myCommand.Parameters["@attachfile"].Value = ((byte[])fileContent);
        fileStream.Close();
        myCommand.Connection.Open();
        myCommand.ExecuteNonQuery();
        myCommand.Connection.Close();
    }