saving image's path in ms access using vb.net

[lein.o16]

how can i save the path of the picture i've browsed. i'm using vb.net as my front-end and ms access as my back-end.

thanks in advance :)

[kvprajapati]

>how can i save the path of the picture i've browsed

Use OleDb provider classes,

..
 Dim filePath as String = "SampleFolder\File.Ext"
 String insQ="Insert Into TableName(id,path) Values (@id,@path)"
 ...
 Dim Cn as New OleDBConnection("put_your_connection_String")
 Dim cmd as new OledbCommand(insQ,cn)
 cmd.Parameters.AddWithValue("@id",1)
 cmd.Parameters.AddWithValue("@path",filePath)
 
 cn.Open()
 cmd.ExecuteNoneQuery()
 cn.Close()

[Max D]

how can i save the path of the picture i've browsed. i'm using vb.net as my front-end and ms access as my back-end.

thanks in advance :)

If you don't mind using an ActiveX, try AccessImagine component. Believe it, you will save a lot of hours of coding and get a UI for image submitting that is untouchable in other ways.

Here is an short article about it, don't forget to take a look at video of UI: http://access.bukrek.net/tutorial/dot-net