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 have so far set up a form to save data into a database and i am using:
[Code]....
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?
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 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.
So here goes, I am a college student and well in my college our lecturer has specific standards. She wanted us to use SQL Plus in order to connect to VB.NET but the problem is I don't have that program at home (as in that i mean the SQL PLUS program, i have VB.Net already just missing the other progam) and considering i have so much coding done using the program in college i can't change it now.of me going off and change entire code each time. I know there is easier ways and less code to do things properly but i'm afraid even when i'd love other ways that save in code the lecturer won't pass me on that, i even have to present it too so i need to know to explain things clearly.
View 14 RepliesSay URL1: http:[url].....
RelativePath: ../../hello.htm
Hence absolute path is http:[url].....
Is there a function that do that?
I'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 RepliesI have the following POST request:
[Code]...
Asked here in response to a request at 405 - Method Not Allowed HttpWebRequest
In 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 using VB .Net to connect to an access databse when using several connection sometimes i get this erro "unspecified error microsoft jet database engine" even though i am an administrator on my local machine.
View 1 Repliesi am new to Visual Basic, my operating system is Vista. I started a new project, tried to connect to a database, but keep getting the following error:"cannot open log for source 'VBExpress'. You may not have write access."
I searched the internet for an answer, but only found answers if I were running Windows Server 2003.
Has anyone encountered this problem before? If so, do you have a solution?
I have done a windows application VB.NET with access Database. while working on it, i had the database path
Private ConStr As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= C:\LBCvehicles.mdb;Persist Security Info=True"
But since i wanted to deploy this project and install it on another pc i dint want the DB file to stay on C so i added a new folder to my project "DB" and added to it the access file.
Private ConStr As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= .\DB\LBCvehicles.mdb;Persist Security Info=True" and i tried it before deployment everything worked fine.
I deployed the application and when running the setup file i got the following error :
"The folder path'.' contains an invalid character"
I'm using the "Add New Data Source" wizard in Visual Studio 2008 to connect to an Access database ".accdb" but I keep getting an error message when I try to finish the wizard.... "Custom Tool Error: Failed to generate code. 0 is not a valid value for Int32. Input string was not in correct format." this is my first time working with VB in conjunction with MS Access.
View 7 Repliesi got a probleam with database connection. check my coding. For info i am using server sql 2005 and microsoft visual studio 2005. I also highlight the which cause me a probleam..
[Code]...