I've got several pretty massive dataset's with a lot of tables/relations in each.I've came in this morning and one of the datasets has sorted itself into a very readable Vertical form with all relations and tables displaying perfectly readable.Is there a command to "Arrange" the layout of the tables?
View 4 Replies
I have created a table in a dataset and inserted data through for...loot statement. but i want to sorting or ordering data on a particular field. How it to be possibel please give some tips.
In addition to that when I add column in a table I mention only column name, but I can't maintion field type or data type. when I mentioing it gives a error. so only I have had to work on only filed name.
I am attempting to update an existing winforms application, that was created with a dataset control on all the winforms pages. I have ported it from VS 2008 to VS 2010 and I need to update the database section and connect it to the SQL backend using traditional code method.In the Solution explorer, when I click on the Dataset files, and click "Exclude From project" I am unable to build the project.Is it advisable to comment out the code lines that refer to the dataset in the .designer.vb files?
View 1 RepliesI moved a project so I could work on it in two places. When I opened the project, I have only worked on it from one computer, my form did not show in the solution explorer so I moved it back. I opened the project and everything was there but I was not able to see my form layout in designer view. The code is there and it builds and looks right but I can't see any of my form components and I need to edit some properties.
View 2 RepliesWhen using the Dataset Designer in VS 2010 I add a new query.It adds with no issue.Add another,starts to hang. Add another and now it can hang for hours.I use task manager to kill VS 2010 after 30 minutes.Go back into the same table adapter query, modify it, save it.Works in seconds.Add another query, hangs, hangs, hangs.I have seen posts about this going back to VS 2008.I have No Add-Ons loaded, what is causing this issue??
View 2 RepliesIt seems that there is no way to preserve changes to a DataSet made with the Designer when there is a change to the database. The only way to get the Designer to rescan the database to incorporate a change is to delete the DataSet and then recreate it. This of course blows away all the mods you've made in the designer. There should be a way to have the Designer rescan the database while preserve all the mods that have been made in the Designer. Otherwise the Designer is essentially useless after the initial generation of code. What am I missing?
As a workaround, I tried incorporating the changes to the database by making the same change in the Designer rather than recreating. However, clearly no one tested this is it only partially regenerates the code based on the change. Try changing a field from nulls not allowed to allowed. This works when you add data to the DataTable, but bombs as soon as you update the database, because the DataSet code does and the database code doesn't get regenerated.
I have a windows form application made in Visual Studio 2010 SP1 Rel. I'm using SQL Server 2008 R2 for my database. I've been working on this project for a while now and I am almost completed with it. I recently had to add a field to one of my tables in my database, which hasn't given me much troubles in the past as I've had to do this before. To make sure I did it properly, I'll tell you how I added the field. I went to my database on my server and went to my table, tblOrderParts. I right clicked, and went to design. I added a field, Order_Delete, which I made a bit field so I could use a checkbox. When I went to my dataset designer, I used the wizard to add the field to the table in my program.
After I added it, I remembered that one of my forms was using a view I had created with that table that would need the checkbox as well, so I went back into SQL Sever to add that. Added in SQL with no problem, but when I went back to Visual Studio's dataset designer to add the field to my view, it won't allow me. I open the wizard, go to my view i created, vwAllOrders, and checked the box next to it. When I press Finish, though, I get, "An exception has occurred while attempting to set the data source generator property." I had to cancel out of the dataset wizard cause it wouldn't let me continue... even if nothing was changed.
Now it is also showing me an error in the Error section saying,
"Custom tool error: Failed to generate code. Exception of type 'System.OutOfMemory' was thrown."
Now that I've said the error, here's what I'm thinking is going on... Something must be wrong with the custom tool on my dataset. The tool name is MSDataSetGenerator. I went on more forums, and a couple mentioned trying to restart the custom tool by right clicking the dataset and going to "Run custom tool.' When I run it, it gives me another error. Not much different, but still different in wording.
The error it pops up say
"The custom tool 'MSDataGenerator' failed. Exception of type 'System.OutOfMemory' was thrown."
However, now when I open it in design view and add a new tableadapter I now cannot reference the new objects from the code. Likewise if I delete one of the existing tables in the dataset, it still appears to be there from the code (ie in intellisense)Similarly, when I examine the .xsd file, the changes I've made i the designer appear, but the changes are NOT happening in the dataset.designer.vb file. It's as if the two files are somehow out of sync
View 3 RepliesVB.Net 2010 Express - AMD Phenom II X4 - 8g ram There are times when I debug the app that I get the 'End Sub' must preceded by a matching 'Sub' error. This usually happens after I make a change to the table adapter query in the dataset using the designer.
If I dblclick on the error it opens the dataset.Designer.vb and shows the error in question.
First, I have made NO changes to this file manually Second, when looking at the code in question, it actually appears there is nothing wrong with it - yet the compiler thinks there is.
This appears to be a VB.Net 2010 IDE/compiler bug Now, I can resolve this error by re-opening the dataset, configure the Fill query, click Finish (not making any changes - just clicking Finish), and then save and close the dataset.The error goes away then, but I shouldent have to go through all that; especially since my query was fine to begin with.
in my VB.Net application I've created a Dataset that call an existing MS SQL Server stored procedure but after the wizard close no columns where added... how can I add all the columns returned by the stored procedure without adding them manually (off course the stored procedure might change in the future) in which case manually will not work.
View 1 RepliesI have a dataset with around 15 table adapters. Everytime I make a change, such as add a column, change a type, or just anything, it takes around 3-4 minutes before studio responds again. The processor and ram are in good shape, but there is a spike in network usage by devenv during this time. In fact, devenv has the higheset network usage all together, even with with IE open and browsing. Why would this be and is there any remedy?[code]...
View 3 RepliesThe DataSet designer will stop refreshing itself every now and then in VS2008. This means I cannot work with my DataSets until I restart VS. There is a more detailed explanations in
this thread, but it was incorrectly marked as answered. This issue is taking more and more of my time though, so I'd like to get another answer now.
I would like to know where the dataset designer is obtained for a vb.net 2008 appliocation I need to work on. Is this part of the initial install for visual studio.net 2008. If so, what part of the initial install will I find the dataset designer? Is this a plugin that needs to be downloaded? if so, what URL do I need to use to obtain the plugin?
[Code]...
Ok i have an issue that i have reported before but never had a satisfactory result to so time to try again. and im just about ready to throw this whole visual studio nonsense in the trash, ive wasted god knows how many hours on this now. I have a medium sized VB.net (2008) project, which has around 50 Datatable adapters that i have setup in the dataset designer, and are all workign perfectly well.
[Code]...
I'm using VS2008 and SQL CE 3.5, building a smart client app. When I add a table adapter with this code:
UPDATE feeders
ET planningAreaID = @areaID
WHERE feeders.transformerID IN
[code].....
I have a typed dataset with table adapters. I use this method because it makes it easier to design the layout of my DataGridView.The problem is I have added a new table to my dataset. When I go to the "Data Sources" list view, I can see the new table.However, if I add a new DataGridView to my form then attempt to bind it to my new data table, the table will not show up in the list of tables for that dataset.
View 1 RepliesI have written this code implemeting MVC design pattern.... for simplcity... i have create Model with BLL having a two classes Employee and Designation and i have created the DAL using the Dataset designer tool....thus i've implemted all relationship bewteen the two tables Empoyee and Designation connected to each toher using field EmpIndex.
In MVC design pattern i should return objects to the controller (in this case i used only the view- win form) becuase of my Designer created DAL i cannot return objects of Employee and Designation to the View... this is becuase in BLL: the following method
Code: public TestMVCWithDataset.TestDataSet.tblEmployeesDataTable SearchByIndex(int iEmpIndex) { try { empAdapter.Fill(dtEmployees, iEmpIndex); return dtEmployees; } catch { throw new Exception("Employee not found!"); } }
[code]....
I've included an MS Access database in my WPF VB app, and I'm trying to link the data to an XCEED Datagrid. I have the following code in my testerDataSet.Designer.vb file which I assume is the funcion I should be referencing
Public ReadOnly Property Contact() As ContactDataTable
Get
Return Me.tableContact
End Get
End Property
I'm trying to get it to fill my datagirid using this
<Grid.Resources>
<xcdg:DataGridCollectionViewSource x:Key="cvs_contacts" Source="{Binding Path=Contact, *Source={x:Static testerDataSet}*}"/>
</Grid.Resources>
[Code] .....
What I'm trying to achieve is for the datagrid to display the data in the Contact datatable.
I used the query designer to create a qry from a datagrid view in vb2010 express, the idea was to work out which diver logged the most minutes in the water. here is a copy of the sql syntax:
SELECT MemberID, Name, SUM(DiveTime1) AS D1, SUM(DiveTime2) AS D2, SUM(DiveTime1 + DiveTime2) AS s1
FROM Triplog
GROUP BY MemberID, Name
ORDER BY s1 DESC
I'm using a DataSet to interact with an accdb file in an application. While debugging, the app occasionally closes, without warning and returns the stack below. The code causing the exception is in the DataSet.Designer.vb file (automatically generated). What's curious is the line that reads:
If (previousConnectionState = Global.System.Data.ConnectionState.Closed) Thencommand.Connection.Close()End If Why would the code try to close an already closed connection?I just change the "=" to "<>"? Will it stick? (since it's auto-generated, I'm sure it will revert if I modify the dataset, right?)
[Code]...
I created a new query in the dataset designer. There are now 2 queries there. The original one and the new one.I also added named parameters in the Where clause of the 2nd query.This is the query in the new one:
SELECT ID, FatherName, MotherName, EmergencyContactName,
EmergencyContactRelationship, Address1, Address2, City, State, Zip,
PrimaryPhone, SecondaryPhone, Emaile.
[code].....
how do i change the layout of the web form to Grid Layout so that i can place my control anywhere and not follwing lines or cursor
View 1 RepliesEditing a Visual Studio 2008 solution (1 Windows project and 1 installer project) that has been working flawlessly.Recently, attempts to edit the Dataset (add/modify queries) by right-clicking the dataset and selecting "Edit Dataset With Designer" brings up the MyProject_Dataset.xsd window TAB, and initially displays "Please wait while loading..." in the middle of the window -- and then does nothing else.Alt-Tabbing to other apps then leaves "ghost window" stuff displayed where "Please wait while loading" once was... and editing queries, etc., is impossible.Shutting down Visual Studio will enable me to successfully get into the editor once ot twice, but then it locks up again.
View 6 RepliesI have an auto generated class file whit many partial classes (auto generated from an xsd schema). I use VS2010 and VB.NET.[code]I'm developing a part of and business application. The application is used for registration of persons data, invoicing, accounting, and so on. The part I'm developing is a reporting system to the authority via wcf services. In my part I will use VB.NET but the other parts of the system are developed in VB6. We use an SQL server and nearly all the business logic is located at the server side. Because I'm used to use VB6 its difficult to grasp all the OOP things I need to remember to write the code as it should be. In my part of the application I get an xsd schema from the authority and auto generate my schema class file from the xsd file with xsd.exe. I see that it's a much better solution that you suggest, but when I looked at my auto generated class file after reading your answer I see that every partial class has a MyBase = New line in the constructor.I can use this in a way, like you suggest? Sorry for not understanding this earlier! If I understand the behavior of MyBase correct, I can write [code]how should I generate the xml based on the xsd? I want to do this for multiple xsd schemas. Isn't it the a good solution to deserialize the xsd (with xsd.exe) to a class, create object of that class and populate it with data, and then serialize the object back to xml?
View 2 RepliesA form has 10 textboxes,The form receives data,based on the data received some texboxes are visible or not with the .Visible Property. lets say for example, 5 textboxes are invisible, the other 5 textboxes will be visible and there will be some space between textboxes and it will look weird.for example in this image:I want to organize the remaining textboxes, so it would look like this:
which textboxes are visible or not can vary, it could be the first, second or fifth, or the last four, etc. So, how can i organize the remaining visible textboxes?
In a VB.NET Windows form, I have a form named "form" I got this error in the form.Designer.vb whenever I assignt a data bound to a control. It complains in the "Designer" that "Type 'namespace.dataset' is not defined". The dataset is attached to the form in the design mode when I assign a data bound to a control to the Windows form and it generated the code to the "Designer" page. I can go to the "Designer" page to remove the "namespace" of the dataset and the error disappear. However the namespave re-appear to the dataset in the "Designer" page once I open the Windows form in the design mode.
View 4 RepliesI'm working on a program, just to learn a bit more about programming. The program's function (if I manage to do it) will be to accept drag/drop files and create a link to them within the program itself. For example: I drag and drop the .exe to a game I have installed; the program then creates a shortcut within itself; the shortcut is displayed in the program with the name/icon; if I click the icon within the program, game launches.I've already manually coded something to this same effect, but it doesn't automatically add new shortcuts/buttons so I have to keep going back in and reprogramming another button every time I install a new game/program. I'd like to be able to just drag/drop and be ready to go. Any ideas on how I can get this function? I'm using Microsoft Visual Studio 2010.
View 9 RepliesI have been brought onto a project where a large amount of code has been written. Most of the code is appearing in the MainWindow.xaml.vb file (yes, this is a wpf project but I think the question is appropriate for this forum). The folks who developed the previous versions in Visual Basic 6 told me that they organized their code by using Modules. I was not aware of this practice and I have actually never even used modules. Can I use modules in this way so that I can logically group different areas of functionality within the application? Or is there a more preferred method?
View 2 RepliesI need some help with how to organize classes in VB.NET. I have a class called parent with methods for adding, deleting etc. But I also need a method that returns a list of all the parents, a list with parent objects. Where do I put this method? Do I put it in the parent class or do I need to make another class called parents?
View 1 RepliesI am reading in part information from a CSV File. When I read the data in, I have a display form/window that displays the data as:
"D159483,172 Cylinder,9/12/2011,2:38:53 PM,,Brian,30,6"
I would rather have the data look like[code]...
