Database - How Data Sources Are Linked In Compiled .NET Applications
Jun 18, 2009
When I try adding a new data source to my project I get a prompt saying "The connection you selected uses a local data file that is not part of the current project. Would you like to copy the file to your project and modify the connection?"This sounds rather obscure to me, as I'm new to VB.NET and programming non-script apps in general. The data source in this case is a .sdf SQL CE file.
Question 1: If I say that I want to copy the database to the project, what will happen after I compile the app, where the database will be? (how will I edit it from another app?)
Question 2: If I do not include it, how the data source will still keep linked? Can I link using filesystem enviroiment variables like %ProgramFiles%MyAppDir?
Question 3: Can I just tell it to use a read-only (Just needs to read it) data source on the web, like on an FTP?
I read many questions on running .net code with mono but i always end up with the same question. I'm building a new app right now, so i better start straight and take the good direction: Can i develop an app within Visual C# Express or Visual Basic Express, compile it from the Microsoft environment using the compilers they have and run that application using MONO on linux.Or do i have to work with the mono compiler from scratch (or convert my MS project afterwards to mono) to be able to use my .net apps using the Mono framework on linux.Linux/Mac support is not really a must for my app development, but i'd like to get it straight off the start.i'm using WinForms, Encryption, Globalization, SQLClient but thats probably all, is there anything you Mono experts out can tell me NOT to use off the start.Oh and i use the My namespace for all sorts of things such as getting the computer name, logged on user name, resources, settings, etc...
I am very familiar with VBA and have been using access and excel to create applications that connect using ADO and/or linked tables.I'm looking to start developing simple Windows applications for my company using Visual Basic, that will connect to Oracle and SQL Server Databases using ADO. What do I need to accomplish this? If I purchase Visual Studio 2008 Pro, will it come with VB? And do I need anything in addition to this in order to connect to SQL or Oracle databases using ADO method?
The company I work for has gone to great expence in getting me Express to code in.Tring to use the datagridview and attaching it to a source has me stumped.I can start the wizard, but it only shows Access and SQL express file locations.I need the connection to get to the actual SQL 2008 database.
I am a novice to programming and am working my way through one of the more popular books on VB in VS 2008 Pro. I am havng a probelm setting up to add dataset controls to a form. I can establish a connection to the data base (a dataset is created and I can preview the data), but the table adapters and binding sources are not being automatically added to the form by the IDE. This seems to be verified by the fact that I cannot drag and drop controls from the data source window to the form.
for some reason my "data sources" window is empty when I open my project.Worked last night ,but this morning it's blank.Reads:Your project currently has no data sources associated with it.Add a new data source ,then add a new data source by dragging from this window onto forms or exsisting controls. What happened and how do I get this back to how it was.I can no longer open any project forms.
I have a bit of code that reaches out and grabs a series of rows from SQL Server DB. I perform an inner join to get some related table data. In the process I get returned the user id of the creator of the data. I then want to pass this into a query to get back a full name. I am having no luck figuring out how to do just that. If I use the data visualizer I can see the name I am after, I cannot figure out the call to extract it
Bindingsource1.DataSource = GetData("Select * From PURCHASE_ORDERS WHERE PURCHASE_ORDER_NUMBER =" & REQ_NUM.Text) .DataSource = Bindingsource1
Currently, I am trying to make a table, which retrieves failed products and passed products from an Entity with LINQ.
Lets assume I've done that, but have 2 lists, A regular List(Of String), and a SortedDictionary(Of String, int32) (To hold the product, and the number of times the testpoint has failed).
Now, when I want to output them to ListView, in a Webform, how can I make it, so that List(Of String), will be output on the listview, and the SortedDictionary, be output after the List(Of String)?
EDIT: Although I could just add the SortedDictionary values to the end of the List aswell, but how would I go around doing so? Because I will create a listview with 2 columns, one which holds the descriptive text, and then a List(Of String) value. And the SortedDictionary would follow, requiring two columns.
It's been a long while since I've done any VB.Net coding and need to bind some data to a form. I have multiple tables that share some common primary/foreign keys and need to easily be able to update them.
For example, I have a table with an ObjectID, TypeID, AreaID, and several other fields. When doing my layout, I need the TypeID (found only in the main table) to be a distinct value in a comboBox, and in the ComboBox which contains the Area to be the Area Description (from the main table tied to the Area table via the Area ID).
I designed a form from dragging across tables from data sources. All in all, bindingsources, tableadapters, dataset & tableadaptermanager, I have about 40 objects in the component designer tray.I found out that on a few occasions, Im not able to view the form design because of corruption or something. Sometimes, I even lost a bindingsource object or even a dataset object which caused errors. Has anyone come across such incidents? Is it advisable to have too many objects in the component designer tray?
I'm developing a windows forms app, just upgraded it to use .NET 4.I'm VS 2010 ultimate RC.I'm running it in a virtual PC with 2GB of memory allocated to the virtual PC. I have windows 7 32 bit inside the VPC.I'm running win 7 64 bit with 4 GB at the host OS.Have a business DLL with about 300 of typed data tables.NOTE: The data tables are not in DataSets, we have generated the code for the DataTables using our own code generation mechanism.The data tables have been added as an data source (Of type Object)I'm running VS 2008 in my main OS. (Not a VPC)When running VS 2008 it takes 30 seconds to open the Data Sources window, the first time I open it.About 15 seconds subsequent times.Also when on a form and setting a binding expression it takes 10 seconds before the drop down list of available object to bind to comes up.
I have quite a powerful PC (5 experience score) relative to other developers at my company.This performance is a very serious productivity issue and makes developing windows forms apps very tedious.As a result of this VS 2008 is not very popular.The exact same slow performance seems to still exist with VS 2010. (Similar times)It could be the VPC but I don't have a machine to test this on and I don't want to put the RC on main main development machine.Did you expect a lot less than 300 data sources? 300 seems quite low to me for any real workd business application.
im using VS2008.I need to see both the Server Explorer window and the Data Sources Window.However I can see the Data Sources Window and dont know how to get it back.
Im currently making a program for a WM6 phone.. however this question applies VB.net programming in general.How do I use the datasources i have in my project... I currently have a datasource and a database file in my project.how do I connect to the datasource do i need to connect? when I deploy my application will my database file be carried over?
I need to do in other platforms but seem to be having some issues with VB .net 2008.I have a datagridview bound to an SQL table that has several comboboxes.the rowSource (is it called that still?) for each of the comboBoxes are SQL lookup tables that I've created and based on the the users selection in ComboBox1, comboBox2's datasource may change.What I want is, if the user picks "Dental" from ComboBox1, I want comboBox2 to load Dental plans (Which I have working, no problem here I think).And if they pick "medical" in ComboBox1, comboBox2 loads medical plans in comboBox2 dropDown list, which, again that part seems to be working.If in the first row in the DGV,the user selects "Dental" for comboBox1 and then a Dental plan in ComboBox2,on the next row, if the user inputs "Medical" in ComboBox1, the first rows ComboBox2's "Dental plan" info disappears.
The medical plan can still be selected and displayed in row 2's comboBox2 (so the changing of the datasource is working)If you then click anywhere in the first row, ComboBox2's dental plan appears again but Row2's combobox2 now no longer displays the medical plan.Becuase whatever value you choose, no matter if it's a medical or dental plan, the info gets saved in the DGV bound table, shouldn't it display the saved information from the DGV's source and not the shifting comboBoxes datasources?
I have a VB project with a large number of data sources in the data sources window. While the datasets behave well, the objects constantly expanded themselves to show all the properties. This means a lot of scrolling to find one.
I've downloaded the ODBC driver and the MySQL driver and installed them on my system (Win XP SP3). However, the only data sources that are showing up when I try to add a data connection are Access & 2 SQL Server objects. Is there something else that needs to be setup in order for Visual Studio to allow additional data sources? I'm currently running VS 2010 Express.
In Microsoft Visual Basic 2005 Express Edition Version 8.0.50727.42 (RTM.050727-4200) and Microsoft .NET Framework Version 2.0.50727.
Right Click Toolbox--Choose Item--.NET Framework Components--Check on OracleConnection and OracleDataAdapter--Ok
Now double click OracleDataAdapter1 in the toolbox.Data Adapter Configure Wizard appears. Click on New connection.Add Connection dialoge box appears.Click on change.Change Data Source dialogue box appears.Here i am getting only 2 items:
1.Microsoft Access Database File 2.Microsoft SQL Server Database File
And in Data Provider combo box; only ".Net Framework Data Provider for SQL Server".I am not able to configure my OracleDataAdapter1 control by choosing above method.Machine have Oracle 10G Client and Server well installed. I am able to use Dim oda As New System.Data.OracleClient.OracleDataAdapter() and it is working fine; but i wish to configure oracledataadapter by using above method. Moreover, it is possible for me to configure oracledataadapter in Web Developer 2005 by above metohd, but not in VB.NET.
I prefer having total control for data access, populating recordsets (now datasets) precisely via a connection string and SQL select (or stored procedure call), etc.Now I wonder whether I really should be using the Data Sources option which just popped up on my radar? From the little I've seen so far, it seems to bind an entire table to a control, whereas most of the time I only need a small number of records from large tables.Before I spend a lot of time investigating, I hope a quick word from you might help me feel happier continuing as I am, or whether I need a kick up the backside towards a Better Way.
I would like these to have their separate "Bin" folders too if possible at all (I tried using "Probing" but I guess that's not allowed for web apps and defaults to "Bin" folder). If not that then definitely some ability for these to work together under one app/virtual directory because I'm not allowed to create another at any cost :(
I have a data set with a parent child relationship between a patient table and an insurance table. There can be up to 4 insurances for each patient. I want to display them in 4 separate panels of a vb.net form. So if a patient had 2 insurances, then txtName1.text on panel 1 would have the company name of the first insurance, txtName2.text on panel 2 would hold the company name of the second insurance, and so on.
How do I display only the insurances related to the current patient? I've tried moving through the rows of the related table, but that gives me all the rows, not the ones I need. Everything I see on the internet suggest using a datagrid, but that's not an option in this case.
I've recently started using visual basic express 2008 and am having problems with saving my project. Basically, the data sources keep dissapearing from the project when i have shut down my computer and come back to the project at a later time. This has happened to my project several times now and is getting quite irritating as i don't seem to beable to find a resolution to the issue.I could continue developing my application without having to re write the code constantly.
I have a winforms app access a database with 6 tables. Out of 6, I am showing 3 tables on three different tabs on my Form. However, I want to do it using a single binding navigator that will use / change the respective binding source dynamically, depending on the tab that is activated by the user. I have separate binding source for each of the three tables.
I am running VS2008 and am using VB2008. I have created a solution file with a Windows Form Project. It contains one form. I created a class project called DataAccess. I selected that project and created a data source. Now I see the XSD for that data. If display the "Data Sources" window I see the datasource. So far so good. If I select the Windows Form project, and then display the "Data Sources" window I get an empty window with a "Add New Data Source" button/link. How do I make the data sources created in the second project available to the first one?
I have been watching the videos for creating n-tier apps that suggest adding a third project to the solution called DataEntities. I did that. I then click on the XSD in my DataAccess project. Then in the properties of the XSD I change the "DataSet Project" property to point to my new DataEntities project. When I save the DataAccess project the DataEntities project gets a file added to it as expected. But then the Data Sources window is empty no matter which of the three projects I select.
Clearly I am doing something wrong. The videos all show the ability to see the data source in the "Data Sources" window after setting up this three project structure. One other thing I noted. In most of the pictures in articles showing the Data Sources window. The top most entity in the window is the project file itself. Then in a tree structure you would see the various data sources under that top most entity. When I was able to see something in the data sources window, the top most entity was a data source NOT the project file, with the data sources under it.
Any idea what I am doing wrong? It seems like I need to do SOMETHING to make the data sources in one project visible to the others. And possibly something to make a datasource visible once split apart using the "Dataset Project" property.
I have three tables: BOOKS(BookID, Title, Author) CLASSES(ClassID, Title, MajorID,BookID) and MAJORS(MajorID, Description). I added these three tables to a LINQ to SQL class (UBooks.dbml) and then connected to the data sources. Then declared DataContext.
Using LINQ, my goal is to display all books in a grid which I have done with:
Dim allBooks = From Books In db.Books _ Order By Books.BookID _ Select Books
Me.BookBindingSource.DataSource = allBooks
Next I need to display all majors in a listbox. I would like the description to be shown however I am only getting the majorID to display with the code
lstMajors.DataSource = db.Majors
I have tried db.Majors.Description, however I am told then that Description is not a member of the LINQ table. and my final goal is to display all the books for whichever Major is selected in another data grid. This is what I am primarily concerned with right now. When using the SQLClient classes, I was able to create a string joining the tables (also had the description properly showing in the listbox, but that is of little importance right now to me). In the video tutorials I was able to watch whenever the tables were dragged from the database into the OR designer of the LINQtoSQL.dbml class file all of the associations were already there and the narrator only really had to do some drag and drop. Not only is drag and drop not working without these associations, but I'd much rather learn the code behind it.
I have a project with 150 (i counted) Items in the "MainProject Components" area of the toolbox panel.These 150 classes are mostly database related objects like table adapters, and datasets that i hardly ever use. I also have about 10 custom classes that i use often.When i need to access the toolbox, I have two issues that i would like to resolve.
1.How do i organize the toolbox to separate my custom controls from the table adapters and datasets?
a.I have created a custom tab within the toolbox. b.I have dragged and dropped my controls into this new area. c.All is well until I exit my program and re-open it. Voila they're all back in the MainProject Components" tab.
2.How do I force the IDE to instantiate the toolbox panel as completely collapsed?
I'm working with Crystal Reports in VB.NET in Visual Studio 2005.I have a List(Of Stuff) that I've sorted according to one of the object's members.I've verified in the debugger that the list is sorted correctly.When I define my list as the data source, as in
and view the report, the list is reversed.So, looking for a workaround, I said, "OK, I'll sort the list backwards before binding it."The list still appeared backwards in the report.So something's happening, and I think it's within the report definition, because I don't know where else the sort order could be changed
I have started a little program which is linked to an access database, and it basically allows the user to input a name and a picture, with the file path stored in a text box and the picturebox getting the picture location from said text box. At the moment I am using the BindingNavigator to go between data. Everything works fine, however, whenever I press previous or next, the picturebox loads up the picture using the file location of the previous datas picture field. How can I tweak this so that when I press next or previous it loads the picture into the picturebox using the file location of the data I am going to, not coming from? [code]
