473,583 Members | 4,428 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

UpdateRule disappears when using WriteXmlSchema

Hi,

I am writing an app which reads a SQL Server schema,
configures a dataset with that information and finally
writes the xsd schema to a file.

The problem is that the resulting xsd file does not have
the "UpdateRule " value, so when I build a new Dataset from
that file this value is lost.

I use the DataSet.WriteXm lSchema(filenam e) method to write
the file, and the constraints of the relations of the
dataSet have appropiate values in the UpdateRule property.

Has anyone experienced the same behaviour in this method?

Now I am introducing the attributes in the xsd file using
the XmlDocument class, which in my opinion is not very
elegant.

Does someone resolve this issue in other way?
Thanks in advandce.

Jose Antonio.
Nov 12 '05 #1
0 1332

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

Similar topics

0
323
by: Jose Antonio | last post by:
Hi, I am writing an app which reads a SQL Server schema, configures a dataset with that information and finally writes the xsd schema to a file. The problem is that the resulting xsd file does not have the "UpdateRule" value, so when I build a new Dataset from that file this value is lost.
4
350
by: Robert Scarborough | last post by:
I have a Table in a Typed Dataset which contains a Date field called EventDate. I've ensured that the field is defined as Date as opposed to DateTime in the Typed Dataset. When I generate an xml file from an instance of this typed dataset using the ds.WriteXml method, all the dates come out formatted as follows: ...
4
1778
by: Dave bailey | last post by:
When I execute the following code when using a dynamicall created LinkButton in a dynamically created dataGrid, the DataGrid disappears and the page I am trying to get to does not load. Can anyone see what is wrong here? protected void Grid_ItemCommand (Object sender, DataGridCommandEventArgs e) { if ( e.CommandName == "Details" ) {
0
1298
by: mortb | last post by:
My problem is with a XML file that resides on my windows 2003 web server. I have this user control which I include on every page in my applicaiton. The control makes it possible for the users to leave feedback when using the page. The feedback is written to a XML file which I have put in a folder "C:/Save/". I've set the access rights on this...
0
276
by: WStoreyII | last post by:
i have used the following code(which is straight from the msdn) to try this : how ever this and anyother method that i have tried only give me a An unhandled exception of type 'System.InvalidCastException' occurred in system.data.dll Additional information: Specified cast is not valid. does anyone have any ideas on what is going wrong?
4
1480
by: 101 | last post by:
I get a security error when trying to write out to an XMLSchema file "myDs.WriteXmlSchema(strXMLSchemaFile)". I am running XP SP2, No Domain, MS file and print sharing uninstalled. I was able to get past this by making ASPNET part of the Administrators group. I tried the Power User group (as well as others) to no avail. I also had to install ...
2
1951
by: 2D Rick | last post by:
Using Access2003 and XP: In a continuous form using only a Form Header and Detail section, the following occurs: Three of the many textboxes in the Form Header lose visibility of their data when the cursor moves to the Detail section. The data still exists but it disappears. This does not occur on the first record of this continuous form's...
10
1806
by: pcnerd | last post by:
I've created a demo program that draws random lines on the form. At the end, a messagebox pops up with the words"I'm done!". When I click on "OK", the messagebox disappears, but a white square is left in its place. I can still see the randomly drawn lines on the form, but some are covered up by the white square. How do I prevent the white...
3
1799
by: John | last post by:
In my app I've created a label report (Avery 7162, 2 colums, 8 rows) with the wizzard. The report is based on a temp table that is created when the user pushes a button. After creation of the table the pushbutton opens the report. Now something weird happens. When I open the report manually a few or more times it remains intact. However,...
12
4129
by: Simon | last post by:
Hi all, I'm having a baffling problem with a windows service that I'm working on. Basically, I am using a typed dataset to insert a large number of rows into an SQL Server 2005 database. But there's a memory leak that seems to be to do with calling the data adapters update method. It's making the memory usage go through the roof and...
0
7894
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7825
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8179
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
1
7933
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
8191
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
1
5700
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5372
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3816
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
1155
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

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.