Click here to Skip to main content
15,882,412 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
i have this code

VB
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


SQL
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
Posted

1 solution

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


i hope,it ll help you,
 
Share this answer
 
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900