Hi guys! i wonder how can i save image path in a string to MySQL, i mean...what instruction i have to use...i want to save it to MySQL and then show it into a picture box. Thank you very much for your help.
If Text1 = KeyPress Then
Label = CommonDialog1.FileName
but i have an error with KeyPress event :C
This not a code i asking for..
I asked your code for save or load data from database.
or you didn't have a code for save or load data?
and for your code how you can assign a textbox with keypress ? and you try to get file name without select it.
See if this help.
This following example code is how to save image path into mysql:
Button Browse used to select an image and show the path to lblPath.
Private Sub btnBrowse_Click()
CommonDialog1.Filter = "All files (*.*)|*.*"
CommonDialog1.DialogTitle = "Select File"
lblPath.Caption = CommonDialog1.FileName ' label path to show path of image
Button Save used to store data into database.
Private Sub btnSave_Click()
.Recordset.Fields("IdAddress") = txtIdAddress.Text
.Recordset.Fields("First_Name") = txtFirstName.Text
.Recordset.Fields("Last_Name") = txtLastName.Text
.Recordset.Fields("Phone_Num") = txtPhoneNumber.Text
.Recordset.Fields("Email") = txtEmail.Text
.Recordset.Fields("PhotoPath") = lblPath.Caption ' This field will save path of selected image from common dialog.
MsgBox "Data Added"