参数化查询的问题 [英] Problem with parameterized query
问题描述
你好我的朋友
我有这个查询,我想将图像存储到sql server数据库
Dim cmd As New SqlCommand()
cmd.CommandText =INSERT INTO Staff(姓氏,名字,父亲姓名,生日,城市,电话,照片)&_
VALUES(@ Lastname,@ Firstname,@ Fathername,@ Birthday,@ City,@ Phone ,, @ Photo)
cmd.Parameters
.Add (New SqlParameter(@ Lastname,txtLname.Text))
.Add(New SqlParameter(@ Firstname,txtFname.Text))
.Add(New SqlParameter(@ Fathername,txtFtname.Text))
.Add(New SqlParameter(@ Birthday,txtBdate.Text))
.Add(New SqlParameter( @ City,txtCity.Text))
.Add(New SqlParameter(@ Phone,txtPhone.Text))
.Add(New SqlParameter(@照片,这是什么?))
有谁知道怎么样?
提前谢谢
Hello my friends
I have this query and i want to store an image to sql server database
Dim cmd As New SqlCommand()
cmd.CommandText = "INSERT INTO Staff(Lastname,Firstname,Fathername,Birthday,City,Phone,Photo)" & _
"VALUES (@Lastname,@Firstname,@Fathername,@Birthday,@City,@Phone,,@Photo)"
With cmd.Parameters
.Add(New SqlParameter("@Lastname", txtLname.Text))
.Add(New SqlParameter("@Firstname", txtFname.Text))
.Add(New SqlParameter("@Fathername", txtFtname.Text))
.Add(New SqlParameter("@Birthday", txtBdate.Text))
.Add(New SqlParameter("@City", txtCity.Text))
.Add(New SqlParameter("@Phone", txtPhone.Text))
.Add(New SqlParameter("@Photo", What in this?))
Can anyone know how?
Thanks in advance
推荐答案
错误在这里
The error is here
VALUES (@Lastname,@Firstname,@Fathername,@Birthday,@City,@Phone,,@Photo)
//use as below remove the extra comma
VALUES (@Lastname,@Firstname,@Fathername,@Birthday,@City,@Phone,@Photo)
关于那个参数
And about that parameter
Add(New SqlParameter("@Photo", What in this?))
它可能是你需要存储的图像文件创建的字节数组
好运!!
it will probably be a byte array you would create from image file you need to store
Best of luck!!
这篇关于参数化查询的问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!