Rss & SiteMap

Foxtable(狐表) http://www.foxtable.com

新一代数据库软件,完美融合Access、Foxpro、Excel、vb.net之优势,人人都能掌握的快速软件开发工具!
共4 条记录, 每页显示 10 条, 页签: [1]
[浏览完整版]

标题:这个代码怎么写??

1楼
hongye 发表于:2025/1/16 11:08:00

cmd.CommandText = "SELECT 款图 Fro m {订单主表} where [_Identify] = " & r("_Identify").款图 IsNot NULL

 

 


图片点击可在新窗口打开查看此主题相关图片如下:提问图片2.jpg
图片点击可在新窗口打开查看
2楼
有点蓝 发表于:2025/1/16 11:25:00

cmd.CommandText = "SELECT 款图 Fro m {订单主表} where 款图 Is Not NULL"

3楼
hongye 发表于:2025/1/16 11:54:00

    Dim cmd As New SQ LCommand
    Dim ds As DataTable
    cmd.C
    cmd.CommandText = "SE LECT 款图 Fr om {订单主表} where [_Identify] = " & r("_Identify")
    ds = cmd.ExecuteReader()
    If ds.datarows.count > 0 Then
        If ds.DataRows(0)("款图") IsNot "NULL" Then
            Dim imageByte() As Byte = ds.DataRows(0)("款图")
            Dim ms As New system.IO.MemoryStream(imageByte) '将字节数组转换为二进制流
            Dim image As Image = Image.FromStream(ms)
            pbxz.Image = image
        Else
            pbxz.ImageFile = nim
        End If
        Dim rfz As String = r("合同数量")
        lb1.text = "款号: " + r("款号") + " 订单数量: " + rfz + r("单位") + vbcrlf + vbcrlf + "合同交期: " + r("合同交期") + " 担当姓名: " + r("业务担当")
    Else
        pbxz.ImageFile = nim
        lb1.text = ""
    End If

 

 


图片点击可在新窗口打开查看此主题相关图片如下:提问图片2.jpg
图片点击可在新窗口打开查看

 

 

这个代码怎么写,不然老是出错

4楼
有点蓝 发表于:2025/1/16 12:03:00
……
    cmd.CommandText = "SELECT 款图 From {订单主表} where [_Identify] = " & r("_Identify") & " and  款图 Is Not NULL"
    ds = cmd.ExecuteReader()
    If ds.datarows.count > 0 Then
            Dim imageByte() As Byte = ds.DataRows(0)("款图")
……
共4 条记录, 每页显示 10 条, 页签: [1]

Copyright © 2000 - 2018 foxtable.com Tel: 4000-810-820 粤ICP备11091905号

Powered By Dvbbs Version 8.3.0
Processed in .03516 s, 2 queries.