Addding Multiple Databases (datasets) Into One VB Project
Jun 28, 2011
I have a dilemma. The program I"m trying to complete is one VB project with three (3) forms. The first form will act as a menu dialog box. The other two forms will have a dataset (database) on each form. The first form will have a button when clicked it will pull up form 2 and the second button when clicked will bring up form 3. What I add the dataset to form 2 everything is fine. I can see my tableadapter, dataset and so on. Now, when I add the second dataset (database) to form 3, I loose my, dataset and so on. It doesn't appear on any of the two forms (in designer)tableadapter.
View 1 Replies
ADVERTISEMENT
Dec 3, 2011
I have declared a dataset (let's call it 'Fred') as public in a VARs module. In the main form in a sub routine called at the start of the project I connect to an Excel spreadsheet and read it into the 'Fred' dataset into one table (called 'Table') I then bind the dataset table to a datagridview and I can see the spreadsheet. Which is very nice :-)
Having loaded the dataset I want to be able to get some values so I created a button and used the following
msg = Fred.Tables("Table").Rows(0).Item("Name")
I think this should get the value in the first row and in the column called 'Name' in the table called 'Table'
But I get an error when I click the button 'Object reference not set to an instance of an object' which I think means I need to use the 'New' keyword...
So I added to the button
Dim Fred = New DataSet
But I get the same error.
Now I have to admit that I've never really got my head around how to use the 'New' keyword and would have hoped to be able to get data from a dataset through my entire project - especially as I've declared it as 'Public'. Surely if I use 'New' all over the place then I create new datasets
View 3 Replies
Sep 3, 2010
I'm working on my first real vb.net project, after years of using VB6. I'm using Visual Studio 2008. While I've been learning, I've added lots of DataSets to my project and then realised I'd got something wrong, so I've added, and begun to use, a new one. Trouble is, I'm not sure now which ones are used and which aren't.
How can I identify which DataSets aren't being used, and then what is the best way to remove them cleanly? Or should I stop worrying about tidying up and get on with the development work? ;)
View 2 Replies
Apr 5, 2009
Whilst playing around with DataGridViews in VS I've accumalated quite a few TestDataSets within my project.
Can someone please tell me the correct way of removing these cleanly? At the moment I've been Right Clicking a DataSet (from within Solution Explorer) and either clicking 'Delete' or 'Exclude From Project'
Doing this throws up Errors in the Error list such as;
TestDataSet is not defined
TestDataSetTableAdapters is not defined
TestDataSet is not defined
TestDatasetTableAdapters is not defined
I then double click each error in turn which takes me to the actual code with the error and delete this.
I have quite a lot of TestDataSets and I'm hoping there is another way to do this much cleaner.
View 4 Replies
Oct 16, 2009
I have a report where I need the same data, but for four separate date ranges. Currently this data is based on one month, so it's just one dataset. But now I am trying to do this with four separate datasets, where each one is filtered on each of the four date ranges. I setup my WHILE loop to loop thru all four dates. But I'm having trouble now with distinct naming these datasets. Is this the best way to do this? It looks like if I used multiple datatables for one dataset, I'd have to define each datatable column. Here is my current dataset commandstring
View 8 Replies
Feb 8, 2011
How can I change my connection configuration of my datasets and project. I mean, my datasets are not hard coded, I am using dataset wizard. Now, I have to change the computer name to IP.
I am worried that it could give a destruction to my project. How could I change it easily and safe?
View 2 Replies
Jan 19, 2010
I have an encrypted SQL Server stored proc that I run with (or the vb .net equivalent code of):[code]this returns 2 datasets and the output parameters for the results, the datasets are made up of various table joins etc, one holds the header record and one the detail records.I need to get the 2 datasets into a structure in VB .net (e.g. linq, sqldatareader, typed datasets) so that I can code with them, I don't know what tables any of this comes from and there are alot of them Whooopeee...I came close using Linq to SQL and IMultipleResults but got frustrated when I had to recode it every time I made a change to the designer file.
View 2 Replies
Nov 24, 2010
Im currently making a program. It loads data from database fields into an combo box. Everything works so far, It just seems to be a mess. Do i need to have all the datasets and data adapters? or can i get away with just using 1 of each. It seems like im doing it wrong, and although it works it seems like a difficult and messy way of doing it.
Also i would like to assign the firshermenID to a variable depending on the fisherman name that is selected in the combo box. When button is pressed: id = fishermanID of the current fisherman (cmbFisherman.text)
[Code]...
View 2 Replies
May 12, 2010
Not sure if I'm posting this in the right area, but here goes anyway. I've been working with sql databases for practice, but can't seem to get around one thing; after I add it as a data source, I can't go back and add tables.
I start off by going through the project, then add item, choose the service-based database, and go from there. I add the tables, then go in and add it as a data source.
After I've added it as a data source, I can go back into the .mdf form and add lines and edit properties, but it wont update in the data sources. So, I can't add it to the form.
View 2 Replies
Sep 26, 2010
We've got the following scenario:
Central Database (replicated across multiple servers)
Client Database 1
Client Database 2
The Central db has Users and Roles amongst other things The Client dbs have similar tables to each other but with some fields tweaked - contact, address, At present, each client db has its own user/role information which is copied from the central db by a scheduled process. I want to retrieve the user/role information directly from the central db instead (bearing in mind tables in the client db make reference to the user entity)
View 1 Replies
Jul 12, 2010
I have a form with multiple DataSets (filled by multiple Stored Procedures) and corresponding DataAdapters. Associated with the DataApters are commands for UPDATE, INSERT......... Before using the DA Update I am using 'If DSxyz.HasChanges(). It seems that when I make a change anywhere on the form affecting 1 dataset, all of the datasets show this to be true. Why should changing one dataset on a form cause all of the datasets to show changes?
View 1 Replies
Oct 16, 2010
I'm using this function to return a value from multiple databases across three SQL instances (On the same server). I'm looping though a DataGridView that lists all the databases on one of the three SQL instances.Is there a faster way of doing this? It's quite slow using this method.
Function DatabaseStatus(ByVal SQLServer As String, ByVal Database As String)
Dim myConn As New SqlConnection("Server=" & SQLServer & ";User Id=USER;Password=PASSWORD;Database=" & Database & ";")
Dim Status As String = ""
[code]....
View 2 Replies
Apr 5, 2010
connect my vb.net application to a remote sql server database, so every one who installs the application would be able to connect to the same remote database. the application would obviously require the internet to run.i also want the option to add more databases in the future, preferably one for each business who would use my software.i am wondering the best way to set up this server that could hold multiple databases. i would think i have two options:
1) set up the server myself on a dedicated computer
2) pay for some type of service that host sql server dataases
so how would i go about executing these options? i dont know the first thing. which option is better?i do however know how to connect to a remote database so thats not what i am asking.
View 5 Replies
Jul 7, 2011
I currently have an old database that has tables for requests and customers. This information is currently displayed in ASP.NET
What I was required to do, was to connect a new database for users into this system, while keeping the tables for the requests in the old database. Thus it is using 2 databases. I have set it up so, when a user creates a new request, in the request tables it saves it with his userID from the new database, but when the table is being displayed, it uses this new userID to find the user information from the old customers table. Thus I ended up with this:
Sub BindDataGrid()
cmdoledb = New SqlCommand("SELECT r.customerid, r.RequestID, R.RequestDate, R.RequestDescription, a.AssignedTo, r.Urgency, r.ExCompletionDate from tbl_requests r, tbl_assignedto a where r.statusid = 1 and r.assignedtoid=
[Code]....
Currently it displays nothing, and gives out an error for myItem.Value = rdr.GetInt32(0) being a Null. I went through it step by step and it loads customerids normaly into the myItem.Value, but when they run out, it is supposed to exit, but keeps going, thus giving an error.
View 1 Replies
Jul 21, 2011
In .NET, Is it possible to run a nested query from two separate Oracle databases?
[Code]...
Ultimately, this is an effort to overcome an "ORA-01795" error from using an "in" statement with over 1000 items in the conditional list, without having to break the query out into multiple "OR value IN" lists.
View 3 Replies
May 3, 2010
At my company, product is boxed and then placed on a scale/label printer set up in order to be weighed and labeled. The application running on the PC also records a record of each box in an MS Access Database which is then transferred to the main server. There is a separate access database for each scale PC and currently the only way our shipping department can print out a manifest for each pallet (which contains a list of all the boxes and their weights) is to open the correct access database and print out the report by entering the pallet number. Since there are six printer scales and the shipping person has no idea which scale it will be on just by looking at the number, she has to find the correct database through trial-and-error.
What I've been asked to do is create an application where she can simply type in the pallet number, and it will search each individual database for the number, then open the correct one where she can then print out the report without having to guess where it is. I've already figured out how to make the application open the database and report, but I don't know how to make it find which database the pallet record is contained in.Basically I want it to search a number of databases for a particular number in a field, and the return a value when it finds it of which database it is so that I can plug that in later. I have no idea how to do this and my searches online have proven fruitless.
View 3 Replies
Apr 26, 2010
I am trying to add a dll that contains some custom 3rd party conrtols and some in house user controls and am getting the following error -
"The Assembly "MyASsembly.dll" could not be loaded. Check that any dependencies the file requires are installed"
I am using Visual Studio 2003 and the 3rd part controls are C1.
View 1 Replies
May 31, 2011
I have two unrelated databases and I need to pass data back and forth between them. Right now I have created two separate entity models - one for each database - but this is causing issues in my code b/c I have to do a Using nameofcontext / End Using and when I try to then use some of the results from the first section of the code in a second Using nameofcontext / End Using it doesn't like it - b/c I've closed the connection to the first database!
View 1 Replies
Jun 1, 2009
ive been asked to write a program to deal with supply chains (tracking commodities, personnel, etc). I want to create a program that will allow multiple office to run the same software and update their local databases as well as a central database.how to best send the data/ recieve it, and store it so that all offices can see, edit, and store the data both locally, and over the internet.
View 13 Replies
Nov 28, 2011
How do i get multiple icons in a project for use with shortcuts OUTSIDE the project..
View 7 Replies
Sep 30, 2011
A colleague has written a useful tool. He wrote it as a standalone tool, but it works even better as an includable dll, though it needs a bit of other functionality for it to be a really good drop-in component. What I am wondering is whether a project can be compiled as both an exe and as a dll?
There are alternatives, such as having a dll version and an exe version, since the dll version needs to include a few different methods that the exe version doesn't need, but this alternative sucks, since it would mean changing two sets of code.
Another alternative is to build the dll, then change the exe to be a project that references the dll....and does nothing other than calling one method in the dll. That kind of sucks, too, but not as bad.
I want to be able to use his module in some of my programs, and it really should be built as a component rather than a standalone app, but I want to know whether there are other options that I haven't considered.
View 2 Replies
Dec 13, 2010
I have a windows forms application developed in vb.net 2008 (WBLoad) that opens and loads an Excel 2010 workbook (xlAnalysis.xlsm). The xlAnalysis.xlsm is included in the project WBLoad and is loaded from the application folder which is on the user's C: drive.
The wbLoad.Application and associated files are deployed to several network servers across the company.I just created a custom action pane using vb.net 2010 and added it to xlAnalysis.xlsm. The question is how to I include the workbook with the action pane in the WBLoad project?
View 3 Replies
Apr 27, 2009
I have a project which is using VB Language, is it possible I combine some classes with C# language into it? "Project" not a solution.
View 8 Replies
Jan 17, 2010
My project will be a collection of 3 projects that have similar GUI's and call on common assemblies. I want my project to contain 3 executable files when published that will load one of the designated smaller projects. Each of the smaller projects is designed to perform a different task, yet they are all similar in terms of looks and how the user interacts with the program. The best way to picture it would be MS Office. All the office programs (excel, word etc..) are part of the same package, and look similar but they perform different tasks. You can load any of these programs by opening the relevant .exe file, which is exactly what i want to do with my application.
View 4 Replies
Jun 28, 2011
There are 3 project in vb.net MAIN PROJECT, BLL(Business Logic Layer), DAL(Data Access Layer) now we are trying to maintain one single instance of some values through out the assembly or what we can called single instance should get used in all projects...for example there is a class called clsParameter we need only one instance of this class should get used through out all projects so if i made any change in MAIN PROJECT same values also get updated in BLL or BLL should receive same values....
View 3 Replies
Jun 16, 2010
I am trying to create a deployment project for a solution of many projects and two start-up projects. I understand that there are 2 primary outputs in this case. The solution will not work/make sense if either of the two outputs is not running.
At the moment, I have created a set-up project with the multiple outputs, but then I will have to open the outputs individually for them to work. I am wondering if there is a way to create a desktop icon that targets both outputs simultaenoulsy.
View 2 Replies
Dec 6, 2006
i have a multiple form project in vb.net 2003.from my main form i activate the 2nd and from 2nd 3rd and so on.but the problem is when im going back from higher 3rd to 2nd and from 2nd to first, the closing event of my mainform doesnt seem to be working. well i have it me.close but it is still in debugging mode. i could only make it stop thru the stop button.
View 7 Replies
May 2, 2012
i have a solution that has two projects in it. one is a start up project. can i run the second project runtime by let's say pressing a button when the first one is running??? if so how can i do that?
View 1 Replies
Apr 15, 2010
I declare an array on one form that i'd like to use on another form. I declare it public in the declarations area and edit it later within a Private sub. However, when i reference it from another form it's as if i haven't editted it at all and it is only grabbing the initial declaration.
Public Class form1
Public Array() As Integer
Private Sub button_Click(ByVal sender As System.Object, ByVal e As
[Code]....
View 13 Replies
Jun 23, 2011
I want to update the project with some new functionality but I want to keep the original intact.What's the best way to go about creating a new project with copies of all the files and resources from the original, but with paths that all point to the new copy?
View 5 Replies
