Read a value from dataset

Hello I am trying to read a value from dataset check it file image exists based on value if not then use default image.
I am getting an error message of
BC30311: Value of type 'System.Data.DataRowCollection' cannot be converted to 'String'.
is there another way to get the value from the dataset?

 MyCommand.Fill(DS, "mytable")
      Dim FilePath As String
      Dim i as integer
      for i=0 to DS.Tables("mytable").Rows.Count-1
'***Error stops here**      FilePath =Server.MapPath(DS.Tables("mytable").Rows[i]["picture"]))
    If File.Exists(FilePath)  Then
      
    'picture available
    Else
       DS.Tables("mytable").Rows[i]["picture"]= "images/none.jpg"
         end if
      Next
LVL 1
fbetagAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

hismightinessCommented:
Have you tried this:

MyCommand.Fill(DS, "mytable")
     Dim FilePath As String
     Dim i as integer
     for i=0 to DS.Tables("mytable").Rows.Count-1
     FilePath =Server.MapPath(CType(DS.Tables("mytable").Rows[i]["picture"]), String))
    If File.Exists(FilePath)  Then
     
    'picture available
    Else
       DS.Tables("mytable").Rows[i]["picture"]= "images/none.jpg"
        end if
     Next
0
gbelken99Commented:
Try this

ds.Tables("mytable").Rows(i).Item("picture")
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
fbetagAuthor Commented:
hismightiness I still get this error with your sugguestion.
BC30196: Comma expected


gbelken99
Ah thanks your sugguestion works great it was just a matter of formatting Thanks you made my week....
0
hismightinessCommented:
Had I known you were getting an error, I would have ammended my example.  Thanks.
0
gbelken99Commented:
.NET Can really be picky with Syntax but once you get past the learning curve its far and beyond classic ASP Thanks for the points
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP.NET

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.