将图像存储在Sqlserver表中 [英] Storing Image in Sqlserver table

问题描述

我想将图像列添加到我正在SqlServer中工作的数据库表中...谁能告诉我如何将图像添加到表中?

I want to add the image column in a table of database which i am working in SqlServer... Can any one tell me how can we add an image to a table?

推荐答案

您可以将图像存储在sql server 2005中.
正如Srinivaskumar先生所解释的，数据库中的存储图像可能会带来很多问题...您可以在DB中存储小尺寸图像.
如果将较大尺寸的图像存储在DB中，则稍后可能会引起一些问题.如果图像太大，像从服务器下载可能会花费很多时间..

我建议Srinivaskumar先生说的解决方案

you can store images in sql server 2005.

As Mr.Srinivaskumar explained , storin images in database may give lot of problem...You can store small size images in DB..

If you store images in DB that are larger in size may later cause some problems. Like downloading from the server may take lot of time if the image size is too big..

I suggest the solution to follow said by Mr.Srinivaskumar

不要将图像数据存储在sqlserver中

尝试将图像文件名存储在sqlserver中

在根目录中创建一个新文件夹"images"(解决方案资源管理器)

尝试将选定的图像文件移到图像文件夹中

然后将图像文件名存储在sql server的表colunm中


这是在服务器中存储图像的更好方法

可以像

将图像转换为varbinary并存储在db中

Dont Store image data in sqlserver

try to store image file name in sqlserver

create one new folder ''images'' in root (solution explorer)

try move selected image file into images folder

and then store the image filename in colunm of table in sql server


which is the better way to store image in server

that can be like

converting image into varbinary and to store in db

在这里，你去了

将上传的文件存储在数据库或使用ASP.NET的文件系统中 [

Here you go

Storing Uploaded Files in a Database or in the File System with ASP.NET[^]

Also my suggestion is File system.

这篇关于将图像存储在Sqlserver表中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！