代码之家 › 专栏 › 技术社区 › Ronnie Overby

ASP。NET商店上传的文件sql server表

varbinary sql-server-2005 sql-server asp.net c#

3

Ronnie Overby · 技术社区 · 16 年前

以下是我目前所掌握的:

protected void btnUpload_Click(object sender, EventArgs e)
{
    for (int i = 0; i < Request.Files.Count; i++)
    {
        StoreFile(Request.Files[i]);
    }
}

private void StoreFile(HttpPostedFile file)
{
    // what do i do now?
}

谢谢

4 回复 | 直到 16 年前

1

3

Jose Basilio 16 年前

关于如何将文件直接上传到数据库,有一个很好的教程在 4GuysFromRolla

2

Ronnie Overby 16 年前

FilesDataContext db = new FilesDataContext();

protected void btnUpload_Click(object sender, EventArgs e)
{
    for (int i = 0; i < Request.Files.Count; i++)
    {
        StoreFile(Request.Files[i]);
    }

    db.SubmitChanges();
}

private void StoreFile(HttpPostedFile file)
{
    byte[] data = new byte[file.ContentLength];
    file.InputStream.Read(data, 0, file.ContentLength);

    File f = new File();
    f.Data = data;
    f.Filename = file.FileName;
    db.Files.InsertOnSubmit(f);
}

3

1

Spencer Ruport 16 年前

4

0

InteXX 12 年前

Public Shared Sub SaveUploadedFile(File As HttpPostedFile)
  Dim oFile As Db.File

  oFile = New Db.File
  oFile.Data = File.ToBytes
End Sub

<Extension()>
Public Function ToBytes(File As HttpPostedFile) As Byte()
  ToBytes = New Byte(File.ContentLength - 1) {}

  Using oStream As Stream = File.InputStream
    oStream.Read(ToBytes, 0, File.ContentLength)
  End Using
End Function