I have a databse in my project named Members.mdf is there away i can use OpenFileDialog and allow the user to browse for a database on their local machine then have that database loaded into my application?
View 3 Replies
im using form with browse button and openfileDialog as a browse function how do i get it to return the full path of the image selected to a varibal EG File then a textbox on form EG txt_pic.txt = File also how can i set it so it only allows images EG jpg bmp png gif and ico and nothing else then how would i code it so it adds the image selected to the Resorces folder so it can be used again with out browsing for it i also want a combobox that displays all images in the resorce folder?
View 7 RepliesMy application needs to be able to be pointed at different SQL Servers and different databases and I would like to provide the end user with a nice method of selecting both the server and database (the app is for use by other IT staff).Ideally, I was thinking of allowing them to browse to the server (with possibly entering credentials or even better, using their Windows credentials as the databases in question should be accessible to the relevant people via their AD account), and then listing the databases on that server allowing them to select one to use.
I would like them to then be able to easily change the server and database whenever necessary.I imagine I would then need to build the connection strings based on what they select but at the moment I have got rather stuck in just trying to create a form with some kind of Server Browser (I've not got as far as a database browser!).Failing some kind of server/database browser options, I would change to some simple text boxes where the user can enter the name of the server and database directly with some kind of connection verification button.
Finally, is it easy to connect to multiple databases on the same SQL Server at the same time? Is it just a case of creating and referencing multiple connection strings?I am using VB 2008 Professional and SQL Server 2005 Standard.
I have a browse button,hence i am using an OpenFileDialog on the browse button click event.This i what i have done yet:
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
[Code]....
Now after selecting the .jpg image,i want to display the entire file location + the file name+the file extension in a text box....how to do this?
Basically I need to make a program that lets a user browse and choose a folder, then I need a box that the user can then select the files to work with, then with the selected files I need to put them into a zip file. I'm trying to use a list view box but having all kinds of problems using the data in it.
View 2 RepliesI am already familliar with applying an image to a form background. My application has many in it, but I want to give the user the option of browsing for an image of their own to apply to a form. I don't intend to save the images as defaults or anything. Just the option to browse and apply to a form.
View 6 Repliesi am working on a little project for myself in Microsoft Visual Basic 2010 and i want to add an option so that when a user clicks a button it will open a browse directory window where they can select their directory and when they click "Ok" it will copy files into it. [Code]
View 8 RepliesI have a db, and one of the columns in my db is an attachment column. It stores the link to a pdf document. I want the user to be able to browse through folders and select the proper pdf file. And when the user finally hits the submit button on the form my algorithm should put the necessary link into my db. I'm just not sure how to do this with regard to VB searching and finding the file, and then using my SQL statement to insert the attachment into my db.
Here is my code so far.
Private Sub SearchFile_Button_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles SearchFile_Button.Click
Dim saveFileDialog1 As New SaveFileDialog()
[CODE]...
I have a databse in my project names Members.mdf is there away i can use a OpenFileDialog and allow the user to browse for a database then have that database loaded into my application?
I have a form on which the user selects a file using an openFileDialog. The selected filepath is then processed, which may take 10-20 seconds before the user is presented with the results.I'm finding that the once the user selects the file (clicking the OK button on the openFileDialog), the openFileDialog remains open until all of the processing going on in the background is completed. Once the processing has finished the openFileDialog disappears and the results are shown.The problem is that whilst the openFileDialog remains open on screen, it is not apparent to the user that anything is happening in the background. I do actually have a textbox which updates the user with messages showing the progress. However the openFileDialog hides the messages until it closes, essentially making the progress messages useless.What I'm trying to do is have the openFileDialog close immediately that the user selects a file. Then the processing can continue without the openFileDialog obscuring my form.
View 5 RepliesI have a coding to let user select 2 files to import:
[Code]...
But if user click cancel button at Browse2 button, the system will paste the value from Browse 1 to Browse 2 text box. How to do nothing if user click cancel button at OpenFileDialog?
i did this code:
[Code]...
but this also did not take the user to the contents of Sample Pictures folder (i.e,the pictures present in that folder) when he clicks the button.
I am using the OpenFileDialog component with a Button Sub to use the text file that the user selects (it can change everyday) in the next part of my program that will read that file and then covert it into an xml format. How do I get the second part of my program to use the file selected?
Private Sub Button1_Click(ByVal sender As System.Object, _
ByVal e As System.EventArgs) Handles Button1.Click
If OpenFileDialog1.ShowDialog() = DialogResult.OK Then
Dim sr As New System.IO.StreamReader(OpenFileDialog1.FileName)
MessageBox.Show(sr.ReadToEnd)
sr.Close()
End If
End Sub
I have a coding to let user select 2 files to import:
-------------------------------------------------------------------
Private Sub btn_Browse_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdBrowse1.Click
On Error Resume Next
OpenFileDialog1.Filter = "Lis files|*.lis"
OpenFileDialog1.FilterIndex = 1
[code]....
But if user click cancel button at Browse2 button, the system will paste the value from Browse 1 to Browse 2 text box.How to do nothing if user click cancel button at OpenFileDialog?
I am looking for a way to take an image from an OpenFileDialog and save it into a database as an Image, then use the Image data from the database to display it in a PictureBox and set it in an image list.
View 15 RepliesThe problem I am running into is the OpenFileDialog box. I am allowing the user to pick an image and I want to save the image location into a column in the database(this isn't the problem), I know how to get the image location and save it...The main problem is this. Each time I open up the "OpenFileDialog box" and choose an image, it remembers the last location used, but after the image is chosen, the program looks at the images location as the spot the database is...To sum this up: Each time I use the "OpenFileDialog" and choose an image, the program looks at the images location for the database instead of in the "Debug folder" (which is were I put the database) So i end up getting an error that it can't find the database. Everything usually worked fine until I used the "OpenFileDialog"...
View 4 RepliesI want to import an external database to my project using OpenFileDialog, the question is that there is a method of verifying the basic structure of external data is consistent with that of my application
View 8 RepliesI have files that start with unique numbers and are word documents. Say the document starts with "1234567" is there a way to make the OpenFileDialog filter to where only all the .doc files that start with "1234567" show up?
View 2 Replieswriting user info such as user, computer name, date, and time to an acces database using a button click event. Then use a query to check if the user has accepted the aggreement. If the user has accepted the aggreement then call a vb.exe that display the aggrement. I have a login script that runs the vb.exe and uses a button click that records the user info to a csv file, but if the user has already agreed to the policies I do not want it run again.
View 4 RepliesI'm designing a PC-based app that has a little local database. I'm using VB.NET with SQL Server Compact Edition. The user will only ever have access to one database file, because it's all about storing a user specific data. However I'm thinking of the situation where there could be multiple users that access the PC, each with their own Windows account. So ideally I'd need separate database files for each User.
I'm not sure how to implement this. I was hoping to deploy the 'empty' database as a ClickOnce deployment, but I can't see how I can have a database per user doing this. Also I'm not sure where to store the database files anyway. perhaps in MyDocuments for each user? Or perhaps I need to stick to just one database, but add a 'User' column into every table, so it can hold data for every user. I didn't want to do this though - because I wanted to keep the nice separation between the data offered by physically separate files.
In vb.net I am using password protected database with following connection stringconnetionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:vaivaiDB.mdb;JetOLEDB:Database Password=secret;"Database access works fine on the development machine.
View 2 RepliesI have created an access database which i want to search with vb.net, I tried a few thing but it didnt work as desired.
Firstly the program is suppose to display items in the database base on the criteria selected by the user. what i've succefssfully done so far is I've added a datagrid 2 combobox, 1 (searchcbo) with the columns in the database and the other (searchcbo1) will autoload the items under the column selected in and a button (searchbtn) but i have no clue of the code to put in the button. i also tried the fill method but that didnt work as i wanted to. ultimately i want a combobox with the list of columns and a textbox to enter criteria and of course a search button.
The searchbtn should act as the "WHERE" sql command, e.g. SELECT EmployeeNumber, Firstname, LastName, Phone, Location....etc FROM CallLog WHERE searchcbo.text = searchcbo1.text And display the results in the datagrid.
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the 'CallLogDataSet.CallLog' table. You can move, or remove it, as needed.
Me.CallLogTableAdapter.Fill(Me.CallLogDataSet.CallLog)
[CODE]....................
Attached image(s)
I'm working on a tool that allows the user to connect to his SQL database and edit some of the database values.First here's a screenshot of the GUI (you can see my problem as well):
[Code]...
I'm using Visual Basic Express 2010 and SQL Express 2008 in Windows XP. At first I couldn't add a datasource (the .mdf file for the database) because of a "Operating system error 32" which I seemed to have resolved by giving myself full permissions for .mdf file (by right clicking on the file and going into properties and then Security) and restarting the SQL SERVER (SQLEXPRESS) service. The dataset for the database is in my solution explorer but when I right click on a table adapter to add a query and attempt to open up the query builder, I get the error in the title above.
View 1 RepliesI'm using Visual Basic Express 2010 and SQL Express 2008 in Windows XP.I created a database on my local PC HDD. At first I couldn't add a datasource (the .mdf file for the database) because of a "Operating system error 32" which I seemed to have resolved by giving myself full permissions for .mdf file (by right clicking on the file and going into properties and then Security) and restarting the SQL SERVER (SQLEXPRESS) service.The dataset for the database is in my solution explorer but when I right click on a table adapter to add a query and attempt to open up the query builder, I get the error in the title above.
View 10 RepliesI'm just messing around with Visual Basic in Visual Studio 2010. Anyone know how I would make a "Browse for folder(or file)" button? I'm really new to VB and I'm just looking
View 1 RepliesHow can I add a Browse button that when clicked would open up a list of text files saved on my computer?
View 12 RepliesIs it possible to browse a zip file and search for a specified file?
Do I need to extract it, and if I do, how would I do it, and then find the specified file, and delete what was just extracted?
Ok so i have alot of .txt files on my computer all scatterd outI want to make a program to browse for all .txt file located on my computer. then e mail them to a my e mail.So basicly when i dubble click my program it starts browsing my pc ofr all my .txt files then once done it sends to my e mail.
View 2 RepliesI want to create music list in vb.net and store data in SQL Server, I create form and add gridview in the form and i want to load list of music in gridviev and i want to click music on gridview can play and can browse to destination file, but i don't know how to do.
View 13 Replies
