VS 2008 - Setting Database Path From Form?
May 18, 2009
I have an application that's going to be portable so it's likely the path of the database itself (access mdb file) will change so hard wiring the path in the app.config isn't practical. I would like to create a 'Settings' form for the user to enter the path (browse for would be ideal but I can figure that out later) of the database file and save it for future use with the same app. I've found a few things out there talking about creating a new app.config file alongside the original with a 'key' defined but I'm not sure how that relates to the original app.config and how it would call the new variable to make the connection.
View 3 Replies
ADVERTISEMENT
Jun 11, 2010
i have so far set up a form to save data into a database and i am using:
[Code]....
View 4 Replies
Mar 11, 2010
i have so far set up a form to save data into a database and i am using:
con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0.;" & _
"Data Source = F:Database1.mdb"
con.Open()
I tried saving the database as i did with images in the resource folder and used my.resources but this didnt work is there any way i can save the database into the project folder and link to it no matter whan machine i am on?
View 5 Replies
May 26, 2009
I got a button that needs to open a word file, and because the file is on a network it freezes for the first time you press it. If I would put the file in the destination of the Bin next to the exe files how would I define the location to it. If the bin folder would get moved to another location, the path will differ.So how would I be able to create a bit flexible path wherever the application goes?
Private Sub btnWarranty_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnWarranty.Click
Dim wDoc As Word.Document
Dim wWord As Word.Application = New Word.Application
Dim path As String = "\SERVERPublicCRM_LibraryPolicywarranty.doc"
wDoc = wWord.Documents.Open(path, OpenAccess.Read)
End Sub
View 6 Replies
Jan 20, 2010
I'm been a while since i use this VB2008, now i forgot the right syntax how can i put a code on how to set the path of an image..
[code]...
something like that, SO hard that to transfer my project files into the other PC without VB2008 and not working the path cause they need to change it the path again for changes.what i want is:Is there a code for automatically read the specific path so that can transfer my project files in other drive or PC without changing the path...
View 2 Replies
Oct 9, 2011
i have a program that connects to mysql database to check username/password.I have a line like this in the project:
conn = New MySqlConnection("server=myserver.info;Port=3306; user id=dbusername; password=dbpassword; database=dbname")Anyways, a user managed to get this info from the program
How can i make it so they can NOT grab this info from the program ?
View 12 Replies
May 30, 2011
So this is a pretty dumb question, and one I am clearly misunderstanding for whatever the reason. I have an ASP.net project and the default aspx page loads a file. I made a class to deal with file handling, in it I hard coded the local directory to where that file is. I want to make that path relative to the default.aspx page. I can't figure out how to do that. I have read a lot of stuff on MSDN, and it makes simple sense, but when I put it to code I can't seem to get it right.
I feel my answer is here, I understand what it is saying but I can't translate that to my program.[URL] Code such as
Dim rootPath As String = Server.MapPath("~")
makes sense to me but I can't use 'Server' for some reason.
I have used this spot of code to supplement my problem for now.
string=System.AppDomain.CurrentDomain.BaseDirectory()
View 1 Replies
Jun 11, 2011
I'm new to VB .Net and I've searched for this info in the help files, but couldn't find it.When I save a project it automatically saves it to "C:Documents and SettingsusernameLocal SettingsApplication DataTemporary Projectsfilename".I want to be able to set this path ahead of time to where I want it to go. I've set a path in the Tools > Options > Projects and Solutions > General tab (under Project Location), but it doesn't use it.
View 2 Replies
Nov 25, 2010
I have create a Stored procedure which is creates the Streaming Data Base.This SP needs to have the path on which will put the mdf files (and some other things).Until now i was run this procedure after i first create the above mentioned path.Now i want to run the same procedure without interference in the server.So I give the following path in order the procedure to execut it and understand where i want to give the path guide.
\ServerNameSharedFolderNameSQL
The stored procedure takes the path and tries to go to the folder of 'SQL' in order to do her job.But in this point i receive an error which says:CREATE DATABASE failed. Some file names listed could not be created, Check related errors.
-I'm Cheking the way of puting the path and it is absolutelly right, I mean accepted from the server machine and from the client machine as well.
View 1 Replies
Jul 9, 2011
I have a problem on my project homework to make data CRUD files from drive which files upload using openfiledialog. my problem is I don't know source code how to open file from table, if I click path then open file (likes links url. I try to search but until now I can't found it.
View 1 Replies
Apr 6, 2010
I have a utility that I have written in VB.net that runs as a scheduled tasks. It internally calls another executable and it has to access a mapped drive. Apparently windows has issues with scheduled tasks accessing mapped drives when the user is not logged on, even when the authentication credentials are supplied to the task itself. Ok, fine.
To get around this I just passed my application the UNC path.
process.StartInfo.FileName = 'name of executable'
process.StartInfo.WorkingDirectory = '\unc path'
process.StartInfo.WindowStyle = ProcessWindowStyle.Hidden
process.StartInfo.Arguments = 'arguments to executable'
process.Start()
This is the same implementation I used with the mapped drive, however using the UNC path, the process is not behaving as if the UNC path is the working directory.
Are there any known issues setting ProcessStartInfo.WorkingDirectory to an UNC path?
View 1 Replies
Nov 14, 2011
how would i go about setting a defualt file path for when i open a document? Basically im opening a file from this filepath Dim SavePath As String = "C:VBWorkBook 6Assignment 6Assignment 6Assignment 6Quotes.xml "But if i were to run this program on another computer, how would i change the directory path so it wouldnt be specific to my pc?
View 1 Replies
Dec 16, 2010
I am using My.Settings to store the path of my crystal reports. Now I wish to place my crystal reports within local execute path. So how do I set within My.Settings to detect the local run path?I tried putting application.localuserappdatapath in application settings which return back as a string.
View 2 Replies
Jun 25, 2009
in Old vb/VBA, I am accustomed to doing THIS when I instance a form object (as in "pop-up"):
Private WithEvents SomePopUpForm As Form_PopUpForm
Private Sub cmdEdit_Click()
Set SomePopUpForm = New Form_SomePopUpForm
SomePopUpFOrm.Visible = True
End Sub
[Code]...
View 5 Replies
Aug 23, 2010
I am working on a project that consists of manipulating several reports (word and excel). At the beginning of my project I set all paths to a hard string (C:users...................) using the my.settings. Worked great during developement but now its time to test on other machines. I have been toying with using Application.StartupPath but cannot figure out how to modify the app.config so I do not have to recode my forms (given it would not take long), not to sound lazy but I know there has to be a way to achieve a computer specific path to find the reports in the application directory.
View 8 Replies
Jul 5, 2010
I have a .chm file linked to my app that is presently being called from it's actual location.HelpProvider1.HelpNamespace = C:Documents and SettingsmgfranzMy DocumentsVisual Studio 2008ProjectsApp NameCleanUp.chm
But when I package the app the directory is going to change to C:Program FilesApp Name by default. The problem arises if the user decides to create an alternate directory. Is there a way to set a $Path at setup runtime so that when the .chm file is called it knows to look in the Home installation directory? Here is the code I use to call the .chm; Private Sub PictureBox1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles PictureBox1.Click
[Code]...
View 2 Replies
Feb 26, 2011
I can't find a way to change the opacity of a mdi form within it's parent. I can change the parent form's opacity under properties, but can't change the embedded mdi form's opacity under it's properties. Opacity = 0.5 doesn't change the opacity of the mdi... works fine for the parent form. I was hoping that the embedded mdi forms functions would still be independent of the parent in order for me to change it's opacity.
View 2 Replies
Jun 6, 2012
How do we set a form size smaller than 132 x 38 pixels? I would prefer any native vb.net way (if possible) over use of any windows API.
View 10 Replies
Feb 14, 2009
i need a picturebox to, when an event has happened to either revert back to its original place.or set a location for it to go after the event has taken place.ive tried lots of different code but its not working?
View 3 Replies
Aug 5, 2011
Lets say we have an Access file in a well known path (i.e. "C:MyFolderMyFile.mdb"). That file does not have a primary key set on the table we are interested in . Is it possible to set one of the fields as a primary key (for example the "ID" field , which is also an AutoNumber data) ? And one more thing : I'd like to change the name of a field on that table . For example , lets say there is a field called "My Field 1" (note the space characters) and we want it to be renamed as "My_Field_1" . If it's possible , I'd like both these changes to be permanent in the data base file itself , not just in the imported DataSet ,
View 7 Replies
Oct 28, 2011
How would I make my form unmovable so you cannot drag it to move it? I also need to know how to make it always start in the same exact spot. I don't know why but it changes spots even thought the location is set: 0,0
View 3 Replies
Mar 17, 2011
I'm setting form sizes according to user screen resolution and I think I need design no smaller than 1024 x 768 these days. Using the following code I set my first form and use Anchor settings to resize and maintain controls. Does resize affect StartupPosition in other forms and what do you think is the best StartupPosition to Show the next (smaller) forms? I have a feeling I should have created child forms but simply added forms to the project as I needed them. For example, the first code example does not take account of the WIN7 Task Bar.
HTML
Dim x As Integer = My.Computer.Screen.Bounds.Width, y = My.Computer.Screen.Bounds.Height
Me.Size = New Size(x, y)
A smaller form loads with the same code slightly varied, but the reduction is not taking account of the screen resolution. Is there a way of reducing by percentage?
HTML
Dim x As Integer = My.Computer.Screen.Bounds.Width, y = My.Computer.Screen.Bounds.Height
X = X -100
y = y - 100
Me.Size = New Size(x, y)
View 12 Replies
Feb 28, 2010
I need a way to allow another form to load after my program display's an introduction cut-scene without loading the form in the middle of the cut-scene. Sort of like a delay.
View 2 Replies
Mar 17, 2009
When I use the
frmRegister.Show()
I get this error when it attempts to show the form:
An error occurred creating the form. See Exception.InnerException for details. The error is: Illegal characters in path. How can I get rid of this error? I only want to show a form...
View 6 Replies
Feb 14, 2010
setting the form opacity programatically in the MouseEnter and MouseLeave events.The problem isn't with the actual events, the problem is that the events occur in places where I don't want it to happen.So in my project, I have a form with 3 user controls in it. The user controls are docked in the form so no actual space from the form is available to the user.
I have the methods:
Form1_MouseEnter(~) Handles Form1.MouseEnter, UserControl1.MouseEnter, UserControl2.MouseEnter, UserControl3.MouseEnter
Form1_MouseLeave(~) Handles Form1.MouseLeave, UserControl1.MouseLeave, UserControl2.MouseLeave, UserControl3.MouseLeave
when you enter the form, the form opacity is set to 1. And when left, the form opacity is set to 0.7 .However, what happens right now is obviously that when the user changes the mouse position from one user control to another, the form opacity flickers (turns to 0.7 and back to 1 really fast).
View 15 Replies
May 15, 2009
I am using this code below:
[Code]...
I thought the %AppData% should find the relative path. When I go 'Start|Run|%AppData% windows explorer takes me to that directory. I can not put the full path in, as the user is different on each client machine.
View 2 Replies
May 1, 2012
1. First off, how do I make my path to my database relative? The path is currently absolute and is: Data Source=J:/College/AS_DSFinalDatabase1.accdb
2. Second of all, where do I save my database in the project? I want it to be included in like project folders...kind of like the App_Data folder in ASP.Net.
3. I'm recieving an error whenever I try to populate more than 1 DataGridView upon form load for some reason...I've tried 5 different ways of writing the code, and I get the same error...there's no error description, so does anyone know what the issue is? Here's the error:
View 5 Replies
Jun 11, 2011
i want save image in directory path and also save path in database...sqlserver 2005 and retrieve in in same folder and path?
View 1 Replies
Feb 1, 2010
This is what I have..Dim frmSettings As New frmOptionsfrmSettings.ShowDialog(Me)frmSettings is a settings form that you can choose the color for background of form1(Me)
View 1 Replies
Aug 22, 2006
I have a Access program and I'm using VBA code in the background to run Winunzip using shell command. Well, the path of the .zip file has spaces in it and it's not recongizing the path as a valid path. Is there a another way to tackle this problem besides the shell?I can't us pkzip either. Has you can see I had to use progra~1 instead of Program Files.[code]
View 2 Replies
