如何在数据库中检查文件？ [英] how to check file in databse?

问题描述

我有这个代码

i have this code

lblSignFile.Visible = False
            oSDR = objDB.CreateSDRFromSQLSelect("select signfile from appuserdtl where uid ='" & sUID & "'")
            Dim chkFile As New IO.FileInfo(oSDR.ToString)
            If chkFile.Exists() = True Then
                Console.WriteLine("Is ReadOnly:{0}", chkFile)
                lblSignFile.Visible = True
                lblSignFile.Text = "Yes"
            ElseIf chkFile.Exists() = False Then
                Console.WriteLine("Is ReadOnly:{0}", chkFile)
                lblSignFile.Visible = True
                lblSignFile.Text = "No"
            End If
        End If

i want check the file in after insert in databse sql server..and then in the form asp.net i want show status that file with component label.. please helpme..

regards arif pratama

推荐答案

if not exists
( select signfile from appuserdtl  where uid ='" ) select 'inserted'
else
select  'exists'

i希望，它会帮助你，

i hope,it ll help you,

这篇关于如何在数据库中检查文件？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！