Inserting record into dataset

[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.

[David Young]

Why don't you just concatenate the string values:

stringFullFilePath = stringPath & "\" & stringFileName

"ht" <zo*******@vip.hr> wrote in message news:d8**********@ss405.t-com.hr...

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.

[David Young]

Why don't you just concatenate the string values:

stringFullFilePath = stringPath & "\" & stringFileName

"ht" <zo*******@vip.hr> wrote in message news:d8**********@ss405.t-com.hr...

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.

[ht]

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

"David Young" <RE******************@yahoo.com> wrote in message
news:eB**************@TK2MSFTNGP09.phx.gbl...

Why don't you just concatenate the string values:

stringFullFilePath = stringPath & "\" & stringFileName

"ht" <zo*******@vip.hr> wrote in message
news:d8**********@ss405.t-com.hr...

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.

[ht]

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

"David Young" <RE******************@yahoo.com> wrote in message
news:eB**************@TK2MSFTNGP09.phx.gbl...

Why don't you just concatenate the string values:

stringFullFilePath = stringPath & "\" & stringFileName

"ht" <zo*******@vip.hr> wrote in message
news:d8**********@ss405.t-com.hr...

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.

[Cor Ligthert]

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

[Cor Ligthert]

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