使用SaveFileDialog将Image保存到SQL Server数据库中 [英] Using SaveFileDialog to save Image into SQL server Database

问题描述

嗨我有一个名为rdoFP_JD的radioButton，它使用SaveFileDialog来选择图片。我想知道在开始插入命令后如何将选择的图像文件存储到数据库中。

Hi i Have a radioButton called rdoFP_JD, which is using a SaveFileDialog to select a picture. I want to know how to store that image file selected into the database once it begins the insert command.

insertCommand.Parameters.AddWithValue("@ASAM_FIRMA", SqlDbType.Image).Value = rdoFP_JD.Image

我已经尝试过这个但它给了我这个错误



参数化查询''（@ASAm_FECHA datetime，@ ASAS_VER

nvarchar（60，@ ASAS_LUGAR nvar''表示参数

''@ ASAm_FIRMA_PRES_JD''，未提供。



谢谢。

I have already tried with this but it gives me this error

The parameterized query ''(@ASAm_FECHA datetime, @ASAM_VER
nvarchar(60, @ASAM_LUGAR nvar''expects the parameter
''@ASAm_FIRMA_PRES_JD'', which was not supplied.

Thanks.

推荐答案

您提供的错误消息表明预期参数为@ ASAm_FIRMA_PRES_JD''但您在示例代码中显示您将参数名称设置为ASAM_FIRMA。



添加参数时使用的名称必须为匹配SQL的名称服务器期望。_ PRES_JD在SQL Server期望的末尾，但在调用AddWithValue方法时不在参数名称的末尾。

The error message that you provided says that the expected parameter is "@ASAm_FIRMA_PRES_JD'' but you show in your example code that you are setting the parameter name to "ASAM_FIRMA".

The name that you use when you add the paramater has to match the name that the SQL Server expects. "_PRES_JD" is on the end of what the SQL Server expects but is not on the end of the parameter name when you call the AddWithValue method.

这篇关于使用SaveFileDialog将Image保存到SQL Server数据库中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！