I have vb.net application which is using Vistadb with following connection string. I am able to export data to excel also. But after exporting to report different than to application directory, program crashes and says that database not found in exported directory. i believe that there is something wrong in connection string but I van't find. [cpde]...
View 1 RepliesI have an Access database ubicated in the path: C:Documents and Settings obertoMy DocumentsVisual Studio 2008ProjectsDictionaryDictionaryDictionary.mdb But when I execute the instrucction: stringConnection=System.IO.Path.Combine Application.StartupPath, "Dictionary.mdb") the path where catches the database is : C:Documents and Settings obertoMy DocumentsVisual Studio 2008ProjectsDictionaryDictionaryinDebugDictionary.mdb
That`s is the reason why I am astonished because the insertions and updates in the database are made in this last path. Why having the database path in other path which isn´t inDebug works with this last?
I have an access database (made by other application) that I need to read it. The problem I have is that the tables I need to read do not have the read permission; the access permission is set to "Share Deny Write"; though I can open the database in MS Access and export the table to another mdb where I can read it. Is there any way to automate this, or to set read permission on the database using VB.net? Is there any other way to get the info from table not having the read permission?
View 3 RepliesI need to export data to a .txt file but don't know how to do that.
I have a query like this SELECT * FROM TABLE1, from that query it should be directly saved to .txt file without any datagridview.
This code below creates a .txt file bit does't have any data when I opened it.
Dim command As New SqlCommand
Dim reader As SqlDataReader
Dim st As String
[Code].....
I made a program for my friend, a patient database program using VS 2010. I'm worried if my program messes up she loses all the records. Here's what I remembered doing. Maybe you guys can identify how I can fix this or you can give ideas on how to avoid the same mistake.
1. I used Visual Studio
2. I made a VB Windows Forms Application
3. I made a Service-Based Database called Database1.mdf which is a Dataset Model
4. I chose save connection string to Database1ConnectionString
[code]....
She was glad with how simple it was cause I made it with Visual Studio. Now I dunno how to export the database file from her computer/copy of program to make a backup. I dunno what to do.I know I didn't ask for anything in return but if the program messes up I'd feel bad. 1k+ records already jesus christ and the program has like 74 columns/textboxes.
I have done a small app using vs 2010 with an access database. Initially what my friend asked for, was an app, running on one computer. So local access database was a good choice, i thought.
The app is used for collecting data from different enterprises, and different workers in this enterprises. My friend asks me now: �what if two people are using the app on their computers, collecting data in the same place from different workers. Can I, at the end of the day, export data from one computer to another, so that i have the full information in one computer, in one database?
My answer is that this was not the purpose of the app. Probably we should have looked, instead of a local database, for a web app using a centralized mysql database.
But since that is not the case, and the app is almost finished, my question is: can you do it? Can you partially export some records from different tables, and import them later, so you have the complete actualized database in one app?
I am trying to export an excel file directory into an Oracle table as opposed to looping through the range and executing a lot of insert statements. I would think that there are better ways to accomplish this in .NET but I can't seem to find any other answer besides convert excel to csv & load it using Sql Loader or External Table. Does anyone know a cleaner & more efficient way that looping through the ranges creating & executing insert statements?
View 3 RepliesI have to export the data from the database to .txt file, I have the code below that does export it to .txt file but I'm having problems with this code because the data that I'm exporting is about 5 000000 records, it is quite slow and sometimes the pc can't handle it and stops the exporting.
Dim saveFile As New SaveFileDialog
If saveFile.ShowDialog = Windows.Forms.DialogResult.OK Then
command = New SqlCommand
[Code]....
There is a field in the database whose value is the StoredProc name with full path.for example test01.test.dbo.spGetData
test01 is the server name
test is the database
spgetdata is the SP
I am storing this in a variable
Session("GetSP") = objReader(1).ToString() (test01.test.dbo.spGetData)
Dim Command As New Data.SqlClient.SqlCommand(Session("GetSP"), conn)
Command.CommandType = CommandType.StoredProcedure
I always get an error cannot find the SP and it shows like this test.dbo.spGetData It is cutting of the servername test01 always.how can i get the full path.
Im looking for a way that if the program detect that for exemple the path "C:" is "true" then it will add , for exemple , "Hard Drive" in the checkedlistbox.
View 3 RepliesI want to find the path where is installed an exe file. How can i do this if that app is running/not running. I know the name of application. (Visual Basic.NET 2010)
View 1 RepliesI'm need of some way of finding the UNC Path of a share via a script or command line or even a custom created program. I'm trying to automate deletion of users and the setup is a bit complicated.
Home folders are set up like this:
We create a folder on a Disk on a fileserver.When this folder is created, a share is automatically created on a lower levelThen the DFS Links are set up towards the newly created share.
Now, when deleting a user, I could just delete the DFS Folder, meaning that the target folder is the one being deleted. But since it's a share, that cannot happen.
I started making a game in VB.NET, but I am stuck on the pathfinder. There are round objects. I want to know how to find a path get one object from one point to another (or at least as close as possible) without any collisions.
View 2 RepliesI like to search trough some folders to find files. My code to search trough folders and sub folders are:
Code:
For Each Dir As String In FileIO.FileSystem.GetDirectories(My.Application.Info.DirectoryPath, FileIO.SearchOption.SearchAllSubDirectories)
Next
How can I get the path of each folder and subfolder with this code??
How can i loop trough treeview and get path of directory of each folder in the treeview?I have this code for adding a color to a treeview item, but it seems like its not possible to retrive the folder path...
HTML Code:
'add color to folder in treeview
Private Sub RecurseNodes(ByVal
[code].....
I want to create a button that opens a supplied word document in their standard word handler like office or openoffice. But how do you find the Location of the exe (Or its folder) and using it to open the Word Document.[code]...
View 3 RepliesI'm in Visual Basic to create an update center for the software I make.I must find out what the installation path of a program. Eg notepad (which I know), or another program.I can easily find the file of the updater (Application.ExecutablePath).
But how do I install so the path of a program
How I can find path for installed application from VB.net if i know the name of application exe file?
View 6 Repliesi want to get path of current directory .
View 2 RepliesGiven that I have a file in path: C:ApplicationsGeneral UtilsAssembly1Assembly1BinDebugAssembly1.dll
and I am working in the following path:C:ApplicationsUnder DevelopmentApp1App1
is there some easy way to find the dotted path route from the application to the assembly:
General UtilsAssembly1Assembly1BinDebugAssembly1.dll
I'm programatically looking ito a .aspx file and getting the file class name declared in its CodeBehind. For example, when analyzing myFile.aspx I read in its Page Directive and found its CodeBehind equals "myApplicationmyPage.aspx.vb". Then I use the code below:
[Code]....
I'm trying to read a file on a SharePoint 2010.I am using Visual Studio Express 2010.I have looked at a number of different solutions but just can't seem to find the correct path to go down to ascertain the best solution.I only need to know how to download one file from a SharePoint directory.
View 3 RepliesI want to make a program which first of all check whether a serie of programs is installed, if a program is installed I would like to find the installation path, so I will be able to work with it further..My first though was to check in the registry, there is theinstallation path also mentioned right?Another possible way was to search all the harddrives for a specific .exe fil. If then the file is found, the program is installed, and you should be able to find the path to the found .exe file. This is more "secure", right? - Because not all program is registred in the registry right? (E.g. if you move it from another location, and doesn't install it).
View 7 RepliesHow can I get the application's path in .NET in a console app?
I would like to find the absolute path from where my exe file is running.
i.e if i run my application/exe from c:my-appmyapp.exe then it should return c:my-app.
My target is to find my database location inside the db folder.
can anyone has idea how to get Microsoft.net framework installation path using window application in c#/vb.net.
View 2 Repliesi made a program that is associated with the .map file type. What I need to do is find out the path of the .map file that opened the application(including the file name for the .map file).
View 13 RepliesFile create error, not sure why?
Private Sub createStream()
Dim i As Integer
Dim j As Integer
Dim s As String
[code]....
i was trying IndexOf before this and it could get it to work, now im trying to use the Contains()
path.Contails(word(1))
pathis the file path eg B:\Movies
word(1) is a split string eg Transformers 2
i want to find the string transformers 2 in the path and enter my if statement .heres my code[code]......
I am having trouble uploading any file to the path in the error message below. Does anyone have any idea what the problem is. I did some research on this and most sites say that the permissions need Read/Write access for the asp.net user. I tried this and I still receiver the error. Here is the error:
For example Error saving file education_calendar.pdf System.IO.DirectoryNotFoundException: Could not find a part of the path "d:inetpubaophaUploads". at System.IO.__Error.Here is my code for the click event. I am not sure what is happening here:
Private Sub cmdUpload_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdUpload.Click
If IsPostBack Then
Dim MyFileColl As HttpFileCollection = Request.Files
Dim MyPostedMember As HttpPostedFile = MyFileColl.Get("File1")
[Code]...
I am having trouble uploading any file to the path in the error message below. Does anyone have any idea what the problem is. I did some research on this and most sites say that the permissions need Read/Write access for the asp.net user. I tried this and I still receiver the error.
Here is the error:
For example Error saving file education_calendar.pdf System.IO.DirectoryNotFoundException: Could not find a part of the path "d:\inetpub\aopha\Uploads\". at System.IO.__Error.
Here is my code for the click event. I am not sure what is happening here:
Private Sub cmdUpload_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdUpload.Click
If IsPostBack Then
Dim MyFileColl As HttpFileCollection = Request.Files
Dim MyPostedMember As HttpPostedFile = MyFileColl.Get("File1")
[Code] ......