本文介绍了如何在数据库中检查文件?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有这个代码
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,
这篇关于如何在数据库中检查文件?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!