how to check file in databse?

Question

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 14-Nov-13 20:17pm

Member 10356724

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

King Fisher · Answer 1 · 2013-11-15T01:15:00

Solution 1

SQL

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

i hope,it ll help you,

Posted 15-Nov-13 1:15am

King Fisher

v2