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?
i have so far set up a form to save data into a database and i am using:
[Code]....
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:
I created a project in vb.net which is connected with database. The problem appeared when i changed the path which connect with the database, i made it relative. So some of the forms which contain the connection are working properly but in one form i got this error: [Code]
View 10 RepliesI am trying to read and display a file using MapPath as follows :
Response.ContentType = "Application/pdf"
Dim FilePath As String = MapPath("../Document/123.pdf")
Response.WriteFile(FilePath)
Response.End()
This procedure will work fine and display in the browser. However, if I save the file to C:Document123.pdf, how can I access this file using relative path in MapPath function. Is there an option to access the file which is saved out of IIS server? I am using vb.net 2003.
Say URL1: http:[url].....
RelativePath: ../../hello.htm
Hence absolute path is http:[url].....
Is there a function that do that?
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 RepliesI'm trying to open a text file in a program I've created but it won't work unless I specify it as an absolute file path. I can't seem to make a relative path name.
View 3 Repliesi am trying to create an application with with a tree view on the left and a list view on the other (which functions like a explorer )but i need a folder icon in both tree vies and list view it is only working as complete path C:Documents and Settings6025DesktopAccessProviderclose.jpgbut when you deploy this application the location always changes where shall i copy my images? and how can i locate itPlease see my code
Private Sub AddAllFolders(ByVal TNode As TreeNode, ByVal FolderPath As String)
Dim imageListSmall As New ImageList()
TreeView1.ImageList = imageListSmall
[code].....
set the relative path of a exe file in .net?
View 11 RepliesI have a file path like this:
C:Documents and SettingsusernameMy DocumentsProgram NameFormDataGForm1Music.mp3
I need to change it from that to this:FormDataGForm1Music.mp3
The only problem is, that the rest of the file path could change but that.
I am working with Visual Studio 2008 to concieve a small program.pdf file is supposed to open when a button is pressed. It work great with the code:
System.Diagnostics.Process.Start("<Full File Path>")
Only, I would like to place the pdf file in the project's folder and that would open wherever the project's folder is (on the Desktop, a USB port, anywhere).
1- How to get this relative path?
2- in which folder to put the pdf?
I'm trying to write a little Jukebox application in VB Forms, and I need the pathnames of the sound files (inTracks"Insert Name Here") to be relative instead of absolute, so that it may work on a different computer to mine. At the moment, I am testing with the simple Soundplayer class, and the single line of code to play a song is this: My.Computer.Audio.Play("inTracks" & txtCurrentlyPlaying.Text) It works when, instead of inTracks, I put the full pathname (C:Documents And Settings etc.), but not when I try a relative path such as this.
View 1 RepliesPossible Duplicate: SQL Express Connection string - Relative to application location
I have a desktop application written in vb.net. The app uses an SQL Server express 2008 database (.mdf file).Currently i have the connection string as absolute path like this:
Dim ObjConnection As New SqlConnection("Data Source=.SQLEXPRESS;AttachDbFilename=C:UsersPantheoDocumentsVisual Studio 2010ProjectsFood Manager 2012(new)Food Manager 2012Food_CustomerDB.mdf;Integrated Security=True;User Instance=True")
[Code]...
Possible Duplicate: SQL Express Connection string - Relative to application location I have a desktop application written in vb.net. The app uses an SQL Server express 2008 database (.mdf file).Currently i have the connection string as absolute path like this:
Dim ObjConnection As New SqlConnection("Data Source=.SQLEXPRESS;AttachDbFilename=C:UsersPantheoDocumentsVisual Studio 2010ProjectsFood Manager 2012(new)Food Manager 2
[code].....
I have a form with a tabbed control on it. Each tab in the control simply loads an existing file in a reader to display to the user. I have added the files in a folder in my project. When I debug it works great. However, when I publish and move it to another computer, the program runs fine but none of the files show in the tab control tabs. The files do come with the solution when I publish.[code]I know there is a way to make the file path "relative" but I cannot figure out how and there really isn't many resources available to explain how this can be done.
View 2 RepliesI need to play a sound file: Soundsopen_creaky_door.wav"
However the code only works if I specify the EXACT location:
My.Computer.Audio.Play("c:soundsopen_creaky_door .wav")
Is there a way I can set the relative path to something like this?
My.Computer.Audio.Play("soundsopen_creaky_door.w av")
In VB.net when loading in XML documents using System.Xml.Xmldocument is there a way that I can specify a relative path to the file?[code]...
The XML doc I'm trying to load is in the same directory as the VB class. But I'm having trouble accessing it without using a full path to the XML doc.
I have created a sub folder (named 'Data') under my project through the solution explorer. I also have created a text file (data.txt) inside the new sub folder. This text file is used to store information such as settings and connections.
I can check the file using the full path. However, I want to avoid errors such as moving the project folder to a different location. Is there anyway to check using a relative path? File.Exists("~Datadata.txt")
Or is it better to create it under Application.StartupPath?
I have completed my VB project using vb 2008 express edition..I am not able to create a set up file for my project and I think it is because of the file path i have provided in my program
dbSource = "Data Source = C:Documents and SettingscfadminDesktopLead_managementLead_Management_ProjectLead_Management_ProjectLondon.mdb"
The above path is a fixed path which connects my program to the database. Now when I create a set up file and try to run on another machine it wont recognize this path . have placed the database in the same folder that of the program.
Firstly, I'm a Chinese Beginner of Visual Basic. I try my best to express my worries and demands. If anything is vague, I want to design a program like this: when clicking the button, the computer will play certain sound. Like this:(VB 2010) Private Sub con_sndplay_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles PLAY.Click
View 3 RepliesIn vb.net, when writting an application, I want to access a batch file that has been added to the project. My question is how to I find the relative path of this file to access it? I have used relative path on the ASP.NET side, but not on the application side. The properties that I am finding regarding the current directory and running directory and the likes are all for the bin directory its in. While I can use the CurrentDirectory() property and go up two parents (....) in the development environment, when I install the application, the structure is not the same. As in the output is in a single folder, not tiered.
Example. c:projectsMyAppindebugMyApp.exe is the running directory
My file I want to access is at c:projectsMyAppvalidate.bat
so "c:projectsMyApp" is what I am trying to capture.
i have created a batch file and have added it to the project using add items. Basically what i am aiming at is to execute this file on a button click action. I am using System.Diagnostics.Process.Start("hello.bat") command to run this file i have changed the build action to resource for this batch file. But when i run this program, it is not able to locate the batch file. I am required to give a relative path as the path my vary from machine to machine. how can i make this file accessable using a relative path?
View 1 RepliesI know that here there is a similar question but I would like, if possible, to be able to define a relative path for 'Start External Program' or any workaround that do not constrain me to add a complete new empty project to my solution. I am using VB.NET in Visual Studio 2010 environment developing WinForms apps.
View 4 RepliesI am trying to create a sort of 'personal code library' in visual studio 2010 where the form displays a list box of certain project files in vb that I have made in the past and when selected, a button can be pressed that launches the .exe files of those visual basic program project files or displays the source code (.vb file)
[Code]...
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()
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 RepliesI 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?
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 RepliesI 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
