473,287 Members | 2,263 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,287 software developers and data experts.

xsd versus dataset/datagrid problem?

Hi

I am using the VS xsd designer to create a strongly typed dataset. The dataset is apparently successfully created, with no warnings or errors given. Is it not then to be expected that this dataset then should reflect all the details put into the xsd? Somewhere down the line there is not a 1:1 relationship. Be it that .NET is so tightly coupled to xsd, xml and dataset I would have expected any discrepancies to have been well documented and warnings errors / grayed out option boxes to be implemented. I have seen bug reports related to this, but these should not be bugs. Responsible developer or tester should have discovered these well ahead of time of release. However hard to program, still so elementary faults

I just don't know when to trust these most central building blocks any more!

I am developing an involved application regarding tables and relations, expressions and limiting the user to enter values in correct formats. It is not involved in that I only need a single xsd defined dataset, a single datagrid at first, and a load/save of dataset to an xml file. Had the dataset enforced the facet restrictions in xsd, allowed expressions to refer to parent row and not failed upon parent row(id) changing. Had the datagrid always updated upon changes to a row of the dataset. And had the datagrid supported comboboxes (based on relations) in addition to todays text and check boxes. And had the datagrid had some minor standard autoformatting options. Yes then a working structure could be implemented without any programming worth mentioning. A single datagrid could be used to edit the whole of the dataset structure which could be saved and loaded to file as needed, bad gui but a fully working application. Energy could then be used to implement alternative and better looking gui

As is I have no idea as to when to trust the datagrid to update epressions based on dataset changes made through some other datagrid or other gui. It seems a bit random. Documentation is of little use, and having 60 odd tables I cant assume things to work.

As is the promised facet restrictions does not work. Have even found (a good quality!) text book with ready example showing how to use facets to restrict number entering. Sample code fails, as does VS's own xml data editor (editing an xml file based on an xsd file created using VS own xsd editor). How can sw developers and testers not see this before release? Documentation of course just short of implementing these faults in their sample code

The parent expression works in todays newest release of VS. Changing the parent row id does not create errors; at least it seems to work ok. But how could this fault not be seen earlier before release? This is the most elementary thing during testing of relational structures. However having the usual complex relational structure it may be hard to see this elementary error to be the cause of problems. It may also be seldom triggered and difficult to discover during app testing, simply because your app may seldom allow for changing of the parent row (id)

There is a lot of documentation covering a lot of code in VS. Following the reality of object oriented programming. There is always a snippet of code object that can do the job for you. Its just that one often ends up spending more time looking for that snippet of code than one would need to program it. There are waste snippets of documentation, but they always refer to some other snippets of documentation. Less is better if you ask me. Give me a solid overview, and tell me there what does and does not work. Dont tell half the story of what does work through zillions of small doc snippets

Frustrated, huh..

How to know what actually does work with xsd/dataset/ (datagrid)? What part of xsd is 1:1 with dataset

Rgds
Nov 12 '05 #1
0 1951

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Steve Donnor | last post by:
Here's my question.. I have a Dataset which has populated a datagrid with information from an AS400 That SQL looks like this "Select MASYS, MAFLD, MADATA, MAEQV from QS36F.MAPDATA WHERE MASYS =...
3
by: Diego TERCERO | last post by:
Hi... I'm working on a tool for editing text resources for a family of software product my company produces. These text resources are found in a SQL Server database, in a table called...
0
by: TK | last post by:
Hi, I need help on datagrid. I have a dataset exposed as a webservice. I do have a web application that is supposed to consume the service on a datagrid.
1
by: Krzysztof Karnicki | last post by:
I have such a problem… I have create my custom DataGridColumn inheriting from System.Windows.Forms.DataGridColumnStyle on using it on DataGrid, to show rows painted by me self. Because dates ...
1
by: Sky | last post by:
Although I've been using C# for the last month or so, and accepting out of blind faith the ViewState, I do have some nagging questions about it... can you help verify the following statements? ...
7
by: BobAchgill | last post by:
I am trying to decide which of these controls to use to implement letting my user select a full row from MyList. The MyList has several columns which would be nice to sort by at run time. The...
0
by: Bob Davies | last post by:
Hi I have a webservice that retrieves data from a database, this is then returned to the calling client application built in windows forms within a dataset, however upon attempting to create...
17
by: A_PK | last post by:
I have problem databinding the DataGrid with DataView/DataSet after the filter... I create the following proceudre in order for user to filter as many as they want, but the following code is only...
2
by: Carl Heller | last post by:
Working in VS2003, .Net 1.1 I'm working on a project where I compare data between two databases. This is a lengthy process, and very data intensive, so I decided to create a class, and thread...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.