DB/Reporting :: Accessing Multiple Database Files With One GUI Program?
Jul 20, 2008
how would I go about making the user access different local SQL databases. As in they use a GUI program to access / read / write data in a database but can also use that same GUI program to do the same to multiple database files.Is that sort of setup easy to integrate into a VB program? or does a VB program by nature only try to access one database? To integrate the open and close dialogs into a VB GUI in terms of different database files, is there much involved?
View 10 Replies
ADVERTISEMENT
Sep 20, 2010
I have a program where a lot of the required information for it is stored in text files. I simply read this information into large arrays. However, I don't think it's necessary to load all the information each time. Rather, it would be more efficient if I could simply search through a list of items to find the one I need and then use the data from it, or to find a similar name and use it elsewhere.
Would I be right in using a database? And is database programming done in SQL? I have a book on it telling me to use the SQL Server (IIRC), so I shouldn't be doing it in the VB.NET Express GUI?
Here's an example of what I would do:
Hex = 03 00 => dex number 003
Search in file Pokemon Dex Numbers
003 returns Bulbasaur
Check Bulbasaur base stats in the base stats file
etc
So basically I'm reusing a lot of information. I think a database would be best and it would all be internal right? I'm getting complaints about access denied to a text file (since it's stored in the program directory in the program files).
So to cap up the few questions I have:
-Databases are done in SQL and not inside the GUI?
-Databases would load internally?
-I could search a database without having to load it into like an array or something?
View 2 Replies
Aug 29, 2009
I installed Visual Studio 2008 and Office Enterprise 2007 in my new computer.I made some codes for a data reader to get data from an Access dabase. On the step where it will open the connection an exception appeared which says "Microsoft.Jet.Oledb.4.0 provider is not registered on the local machine".
View 7 Replies
Feb 10, 2012
I am attempting to access an SQL (.mdf) file I have created with the Database Explorer utility of Visual Basic. Here is some relevant code from the program:
Imports System.Data.SqlClient
Dim Database01 As SqlConnection = New SqlConnection("Data Source=C:Test01.mdf")
SMUDatabase01.Open()
At this last line of code, I get the following error message:
"A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)".
I am using Windows Vista OS and the firewall is turned off.
I suspect the problem might be the settings (such as connection strings) within the app.config file, but if so I am unsure what the correct coding within this file should be to access the file.
View 8 Replies
Jan 5, 2009
I've used visual basic in office before, but when it comes to writing applications in Visual Studio, my knowledge is fairly limited. I'm unsure on how to set up a connection in my application to connect with a dBase IV database that uses indexes (not sure if it matters if it has indexes or not). I will need to both read and write to this database.
View 2 Replies
Sep 2, 2010
I am working on getting a multiple values from a single column displayed in a single textbox or label. I know I should be able to find the information I need online, but I am coming up empty. I am using Visual Studio 2010 with SQL Server 2005. For example, I want to pull all the email addresses, that have a value, from a table and display them together. The output I am looking for is like this:
[Code]....
View 3 Replies
Feb 17, 2009
I'm writing a program in VB.Net and loading the info into a SQL database. Debugging it works fine on my machine that I am programming it on, it connects to the database and runs through all the info perfectly. However trying to get it to run on another machine it will not connect to the database. I realize the reason for this is the connection string, it's looking specifically at the file directory for the database. How do I change this so that it will function on any machine. The program is only intended to run on one machine at a time and not over the internet.
View 2 Replies
May 4, 2010
My files are being inserted but the byte array is showing as a 0x0000... etc for every file after the first inserted file. The first inserted image is correct. The database is set up as an Image type. The problem exists in the code here\
Dim uploads As HttpFileCollection
uploads = HttpContext.Current.Request.Files
For i As Integer = 0 To (uploads.Count - 1)
[code].....
View 8 Replies
Apr 24, 2010
I have a program that works when, a file is opened with it using the right click menu in explorer. But if I select multiple files and then right click and open with my program then it opens multiple instances of my program, instead of just passing the multiple files as arguments to a single instance. The program is written in vb.net but is not a windows form, it is just a module, so I can to tick the Single instance option in the properties in Visual Studio.So how do I open multiple files from explorer context menu in a single instance.
View 2 Replies
Nov 18, 2010
I wanted to make a program in which multiple files could be saved into one and then unpacked later. I tried reading and then rewriting the exact strings but it made the files corrupt. I was able to do it with bytes but I'm not sure how I add mutiple files together.
View 3 Replies
Apr 19, 2012
I need to require the user of this program to select two text files from any directory. I then need to display them in a List View, which I have built. File 1 needs to load into the first column and File 2 needs to load into the second. They will correspond to each other.[code]...
View 1 Replies
Sep 28, 2010
I've never tried accessing a database on a remote computer, across the internet. A few questions though.
1) Do I just change the connection string address from a local path to a web address?
2) Do I still need to install the local driver? In my case I believe I'll be using Connector/Net to connect to my MySQL database url...
View 1 Replies
Mar 24, 2011
I have a CheckedListBox. In the box are files from a directory. All *.jpg files.
Now I want to open the checked files with the default program.
View 3 Replies
Mar 20, 2009
I have many text files in a folder. What I can do now is to read through one text at a time and insert it into the database. My little app reads a text file when I debug it. So, I need to run it several times to read all those text files and import them into the database.
My question is how to read multiple text files inside a folder at a time. Here's my code which works fine but it reads only one text files at a time.
Private Sub btnRead_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnRead.Click
Dim filelocation As String filelocation = "F: xtfilesch25.txt" Dim chid As Integer chid = 25 'read from file Dim MyStream As New StreamReader(Path.Combine(Application.StartupPath,
[code].....
Obviously, I need a way to loop through a folder and check if there's text file. But I cant get it right.
View 2 Replies
Oct 24, 2011
I am trying to create a program which will allow users to select multiple files from a list and then burn them all to a playable DVD. It would be wonderful if i could setup a custom menu programatically as well. I have seen some documentation on Imapi 2.0 but i have not been able to find too much suppoert for it. I have also found a few SDK's out there but most are over $1000 which just isnt in the budget.
1) Is there a library included in windows 7 that will allow me to do this.
2) Is there an inexpensive or open source sdk with good documentation out there to do this with
View 4 Replies
Oct 15, 2011
I have a question regarding the dataset usage in Reporting Services. I have a stored procedure which returns multiple select statements (result tables), and I created a Dataset in Reporting Services 2005 with this stored procedure. The problem is that I can not reference the second or third result table, and I can only use the first select statement fields. Is this the limitation on Reporting Services Dataset or is there a way to use multiple table results in one dataset?
View 1 Replies
Nov 5, 2011
I finished my application whith vb2010, this application uses a Access database. I have a problem because when I install my application he put database in de same path "program files" and this path is only read And my application crahed. I know how to installer put database in other path but I don't know how to tell my application to find this database.
View 2 Replies
Nov 5, 2011
I finished my application whith vb2010, this application uses a Access database. I have a problem because when I install my application he put database in de same path "program files" and this path is only read And my application crahed. I know how to installer put database in other path but I don't know how to tell my application to find this database,
View 4 Replies
Jan 26, 2012
The user will basically be able to select a file on their hard drive, and enter some details or info about the file and then save it
View 2 Replies
Feb 1, 2010
I need to show a grid of saved projects (compare "orders") in a datagrid, where the projects are saved in an Access 2000 database with a similar schema as follows:
ID Name Country_ID Plant_Type
1 'Test' 1 1
2 'Second' 2 2
Let's call the file "Projects.mdb". This is then showed in the datagrid as:
ID Name Country Plant Type
1 'Test' 'Germany' 'Free Range'
2 'Second' 'France' 'Inclined Roof'
where the countries and "Plant Types" are fetched from a different table in a different .mdb file (also Access 2000, call it "Language.mdb", although there is a lot of different background data in it), depending on the current user's language preference. It is unfortunately not an alternative to merge these .mdb's into one file.
To be able to show the datagrid I have so far linked the tables from "Language.mdb" into "Projects.mdb", but this screws up when the project is being installed on another computer with the .msi file i created (we'd like to have this easily packaged and installed), as the "Language.mdb" doesn't exist on the linked path on the target computer (Basically the problem here).
I can come up with the following solutions:
Force all users to install on the same path, so that the links will work (undesirable)Use connection strings in the query as shown here on MSDN (still trying this out, but I need to work on the details)make a post-install script that relinks the tables according to the correct path.
View 3 Replies
Oct 8, 2009
I want to know that is there is anyy way to access the video files in vb.net .I know the WMEencoder but tell how to get it in our program
View 4 Replies
May 23, 2012
I'm trying to iterate through a group of ComboBoxes and set a property using a concatenated string & variable to represent the name of the control. However, I can't get the instance of the form to recognize the (String & Integer_Variable) as one of its controls -- and so it doesn't recognize any of the appropriate properties or subroutines as members of the System.Windows.Forms.Control.Is there a cleaner way to do this?
For myTempCount = 1 To 6
If tempValue < Me.("ComboBox" & myTempCount).Items.Count Then
ComboBox.SelectedIndex = tempValue 'appears to work -- how?[code].....
This code was originally VBA / VB6, which I put through ArtinSoft's Visual Basic Upgrade Companion (VBUC). FWIW, I'm using Microsoft Visual Basic 2010 Express.
View 3 Replies
Jun 17, 2009
I've developed a couple of different stand-alone projects, myRibbonRTF and myRibbonCalendar and have them functioning well. I want to tie these together with other projects in a single solution called myMain. When I add these projects to the solution, their forms are not accessible in myMain (e.g. myRibbonRTF.frmMain.Show()). I've searched high and low for the last week trying to solve this and the only nearby solution is to turn the other projects into .dlls and access them in myMain that way.
View 7 Replies
Jul 29, 2009
In this program i am making, i want to get information from a text file. but i need to get it from 2 different subs. one sub loops and gets the information every loop and other gets it when a user clicks a button. when they get it at the same time, i get an error saying that it is already being used by another process.
View 7 Replies
Jun 1, 2011
My problem is that I have a program which needs to access images for multiple choice questions, hundreds of them. Now when I publish the program it is not taking the images with it. I have read some information by 'kleinma' regarding publishing and he says to right click on the Bin and click include in project, but when I do this there is no command in the menu for this.
I have included all of my image files in the Bin and have also added them using the resource editor, but to no avail As I have indicated it is the Express edition, could this make a difference
View 5 Replies
Mar 3, 2010
I'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.
View 3 Replies
Aug 28, 2008
I don't know the best way to use multiple forms in VB, but I have created a problem and I'm not sure where it came from or how to fix it.
Background: I start the program at Sub Main. This is the main function:
Code:
Module modFunctions
Dim frmD As frmDAQ
Dim frmT As frmTrendView
[Code].....
it works, but I don't want to have to change the entire project.
View 1 Replies
Jul 23, 2011
I have written a code and tried linking up groupboxes from my input form called input.vb and the output form called results.vb.
[Code]...
I have used the above codes to access groupboxes from both forms. However, at run time I get errors saying "InvalidCastException was unhandled" and below that it says "Conversion from string to DOuble is not valid". This error points to a value in a group box that is actually hidden or disabled.
View 9 Replies
May 1, 2011
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?
View 10 Replies
Oct 21, 2009
I have to make some automatization on a web server, I use Visual Studio 2005 Visual Basic Windows Console Application. I want to make a load/performance test of the web server, so I open several Internet Explorer instances, and I login the application, that is not a problem. But after that I have a mess on the page and I cannot make any more automatization...The composition of the page after the login is like this: I have the default form, another form and a multiple data window(mdw) controller, which dinamically can switches the forms on this part.
The problem is that I don't know how to access the controls of this mdw forms. I couldn't find much about this mdw controller and I am not an expert.
My code is here:
Imports System
Imports System.Diagnostics
Imports System.Web.Ui.Webcontrols
[Code].....
View 5 Replies
