IDE :: Data Sources Window Very Slow?
Feb 10, 2010
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.
View 4 Replies
ADVERTISEMENT
Apr 21, 2010
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.
View 1 Replies
Nov 26, 2011
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.
View 10 Replies
May 16, 2009
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.
View 10 Replies
Aug 17, 2010
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.
View 8 Replies
Mar 10, 2011
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.
View 4 Replies
Sep 7, 2010
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.
View 2 Replies
Sep 16, 2009
where can i find data sources tab?
View 1 Replies
Aug 14, 2009
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
[code].....
View 4 Replies
Sep 15, 2011
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.
View 1 Replies
Jun 13, 2012
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).
View 1 Replies
Jun 25, 2010
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?
View 4 Replies
Jun 1, 2009
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?
View 2 Replies
May 25, 2010
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?
View 1 Replies
Jun 23, 2010
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.
View 1 Replies
Feb 2, 2009
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.
View 3 Replies
Apr 19, 2011
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.
View 12 Replies
Jul 14, 2009
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.
View 5 Replies
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?
View 1 Replies
Feb 10, 2010
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.
View 3 Replies
Jan 23, 2012
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.
View 4 Replies
Jan 31, 2010
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?
View 1 Replies
Dec 3, 2009
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
rptDetails.Subreports.Item("rptSubReport").SetDataSource(theListOfStuff)
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
View 1 Replies
Aug 11, 2007
Ok, most of my Visual Basic experience I admit was with VB 3 and VB 5. I'm just starting with VB 2005 Express, and get this error when trying to connect to a new database.
I'm using Windows Vista and have the latest Microsoft JET version, so I have no idea why I'm getting that error.
View 3 Replies
Jul 28, 2011
I have an issue here which I am looking for ideas on. I am creating a program that models the movement of some atoms and then animates them using the basic Paint method in visual basic. The animation is to have basic remote control functions, such as play, pause, fast forward, rewind and skip to any particular frame.The program is in two parts. The program models the movements of atoms in a background thread. This program was 90% written by other people and is very long and complicated, so in your answers please do not suggest I change the modelling aspect because it's just not possible. It is my job to do the animation.
The modelling program outputs the positions of each atom (just an x,y coordinate) at each time step. We could easily be looking at 200,000 time steps and 50/100 atoms. That means there are 200,000 * 100 * 2 = 40,000,000 numbers that need to be stored. The locations are all single precision numbers.
View 39 Replies
May 10, 2011
I am loading data from query into a dataadapter and then into a dataset.the datadridview datasource is the set to the dataset.but it takes too long to load the data into the datagridview.
View 2 Replies
May 2, 2012
I save Data in MS Access Is too slow. I click Save button [Saved Msgbox appear] then I see the table there is no changes, after 5-6 second it take effects. The code is....
[Code]...
View 7 Replies
Dec 13, 2011
I am creating a window that is a generic keypad for editing numerical values on a touchscreen. I would like to press an 'edit' button to create a copy of the keypad window/bring up a reusable version of the same window (I don't care), but pass in parameters: the old value I'm manipulating, and a title to be displayed above the number pad. I would like the user to be able to type in the new value, then press the 'done' key to submit this value and have it sent back to the main application window into my custom control that contains a text box.(I have the number pad's layout sorted out already; I'm already using a variation on it to set a global password 'access level'. It's getting the information in and out that has me scratching my head.) [code]
View 1 Replies
Jun 8, 2012
In my winform application, I have 2 datatables, both contains 37000 rows. Table 1 has 171 columns and Table 2 has 4 columns. A While loop runs to update values in Table 1 from Table 2 for 4 columns. A For loop runs inside While twice to update values. It takes more than 5 min to do so. which i think should be a task of 5 seconds.
Columns being updated are:
Int64 - 1 Columns
String - 1 Columns
[Code]....
View 2 Replies
Apr 4, 2011
Is there a way to search fast in text file? i have a 5mb text file and it is slow to search ..Im using Vs2008 (VB) and MC3100 WinCE 6 platform
Code
Private Sub DataHandler()
[code].....
View 8 Replies
