Inserting record into dataset

  • Thread starter Thread starter ht
  • Start date Start date
H

ht

Hi!

i have a problem.
i'm using Visual Basic .Net 2003
Here's the thing.

I need to select one folder, without subdirs. (I know that)

For every file in that folder i need to create a record in dataset,
I displayed all files in listbox.(for preview), that works.
Here's the problem, I dont know insert statement
I need to insert string in a single record in a column, like this:

Location of the file and file name are two separate things, how do I put
them into one column ?

'C:\temp\picture.jpg'



When all files are loaded in, I wil make some changes in records and than
save it all to database.
 
Why don't you just concatenate the string values:

stringFullFilePath = stringPath & "\" & stringFileName
 
I am using IO.FileInfo() for retreaving filename, wich does not returns
string value.
Directori path is given by FolderBrowserDialog1

So I got string value (path) and filename (IO type).
I want to write them to string variable (dim temp as string)

So i can value of temp write to column in record (witch is string)


Thanx
 
Zoltan,

And what is than wrong with the answer from David, I would have given the
same answer.

I think that we don't see your problem.
If you have the name in the listbox
You have the path,

In my opinion it is than only looping throug the listbox and do what David
wrote.
(The items are Datarowview when you are searching for that).

Cor
 
Back
Top