我想将图片上传到ftp，并将路径填入SQL的款式图片当前行中（项目里没有表）
Dim dlg As new OpenFileDialog
If dlg.ShowDialog = DialogResult.OK Then
Dim ftp1 As New FtpClient
ftp1.Host="binyang.66ip.net"
ftp1.Account = "byftpuser"
ftp1.Password = "654321"
Dim filters As String = "合同号 = '" & e.Form.Controls("合同号").Text & "'And 款号 = '" & e.Form.Controls("款号").Text & "' And 业务担当 = '" & e.Form.Controls("业务担当").Text & "' And 合同交期 = '" & e.Form.Controls("合同交期").Text & "' And 客户名称 = '" & e.Form.Controls("客户名称").Text & "' And 品名 = '" & e.Form.Controls("品名").Text & "'"
Dim cmd As New SQLCommand
cmd.CommandText = "From {订单主表} where " & filters
Dim dtsj As DataTable
dtsj = cmd.ExecuteReader(True) '记得将参数设置为True
If ftp1.Upload(dlg.FileName, "/kst/"& dtsj("合同号")& dtsj("款号")& ".jpg") = True Then
dtsj.("款式图片") &= IIF(dtsj.IsNull("款式图片"), "", vbcrlf) & "/kst/"& r("合同号")& r("款号")& ".jpg"
Messagebox.show("上传完成!","提示",MessageBoxButtons.OK,MessageBoxIcon.Information)
Else
Messagebox.show("上传失败!","提示",MessageBoxButtons.OK,MessageBoxIcon.Information)
End If
ftp1.close
End If
加好友 
发短信
Post By：2020/1/2 14:34:00 [显示全部帖子]
