.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Schema :relatioship expected & constant/fixed element cannot have attributes

Posted By:      Posted Date: August 28, 2010    Points: 0   Category :Sql Server
I try to bullkload data from xml file to SQL database ,but I cannot figure out the problem.Please anyone help me .I'd really appreciate. the XML file :  <?xml version="1.0" encoding="UTF-8"?> <root>        <!-- ????? -->        <common>               <!-- UploadDataCenterID???????????????? -->               <UploadDataCenterID>XXXXXX</UploadDataCenterID>               <CreateTime>YYYY-MM-DD HH:MM:SS</CreateTime>        </common>        <data>                 <BuildGroup id="XXXXXXXXXX">                        <BuildGroupBaseInfo operation="N|U">                             <F_BuildGroupName>?????</F_BuildGroupName>                             <F_GroupAliasName>???????</F_GroupAliasName>                             <F_GroupDesc><![CDATA[?????]]></F_GroupDesc>                      </BuildGroupBaseInfo>                      <BuildGroupRelaInfo operation="N|U">                             <F_BuildID>XXXXXXXXXX</F_BuildID>                      </BuildGroupRelaInfo>               </BuildGroup>        </data> </root> then the XSD :<?xml version="1.0" encoding="UTF-8"?><xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xs

View Complete Post

More Related Resource Links

the constant/fixed element cannot have attributes sqlxml bulkload error


My xml schema fails in getting attributes from 'empty' element... using sql:is-constant="1" disables reading attributes and by not using constant for element, error comes back with define relation... element is only a header for the attributes...

part of the xml:

<orderitem id="124810">


<name><![CDATA[Jac Digilabel folie tra glos]]></name>


<attribute name="ALGEMEEN_KLEUR"><![CDATA[Transparant]]></attribute>

<attribute name="ALGEMEEN_FORMAAT"><![CDATA[320x460]]></attribute>

<attribute name="ALGEMEEN_GEWICHT"><![CDATA[110]]></attribute>

XmlSerializer - how to define class to not generate attributes in root element?

Hi! I have simple class that I serialize to xml file: <?xml version="1.0" encoding="utf-8"?> <MyRootElement xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Area="East">   <Products>     <SalesProduct Taxable="true">       <Name>Sofa</Name>     </SalesProduct>     <Product>       <Name>Television</Name>     </Product>   </Products> </MyRootElement> I don`t want have in xml file attributes xmlns:xsi and xmlns:xsd. How can I define class to not have these two attributes in xml file? I tried use XmlRoot attribute but there is no control for these two attributes. They are always generated. Regards

Is it ok to make my own element attributes?

I want to make up some new attributes for elements like <div> and <a>. Those new attributes will be used to store data to be used by click handler jquery code.  Is that ok to do?  Is it supported by older browsers?   Testing on IE8 and Chrome, I am able to use jquery to store and recall in these made up attributes of a <DIV>element. ( I tried to use expression web super preview to test the code.  But apparantly, super preview does not run javascript. )thanks, <div id="div1" MadeUpAttr="abc"></div>     <script type="text/javascript">      $(document).ready(function ()      {        var s1 = $('#div1').attr('MadeUpAttr');        alert('MadeUpAttr: ' + s1);         $('#div1').attr('MadeUpAttr', 'efg');        var s2 = $('#div1').attr('MadeUpAttr');        alert('MadeUpAttr: ' + s2);      });    </script>  

The 'http://www.w3.org/2001/XMLSchema:schema' element is not declared.

Hi all,i have created  a .net webservice which returns DataSet in a webmethod but the problem is that when i validate service.wsdl file it gives me following error:Warning 35 The 'http://www.w3.org/2001/XMLSchema:schema' element is not declared. E:\Santosh\projects\asp.net\MFONLINE\MFONLINE NEW\App_WebReferences\HDFCMF\Service.wsdl 771 20 E:\...\MFONLINE NEW\ The 'http://www.w3.org/2001/XMLSchema:schema' element is not declared.Do any one have any idea ?-Thanks

Help: Could not find schema information for the element 'microsoft.web.services2'

(Sorry I may have posted this in a wrong forum earlier) Hi, I've got this problem, trying to add a simple user authentication feature to my web service. I added the code directly copy-paste from MSDN as well as trying load of other ideas why this might happen... I've been getting these "information messages" that practically disables my client application from connecting to the web service. (I'm developing this on my PC, visual web developer 2005) Adding the microsoft.web.services2 section results in: Could not find schema information for the element 'microsoft.web.services2' Could not find schema information for the element 'security' Could not find schema information for the element 'securityTokenManager' Could not find schema information for the element 'type' Could not find schema information for the element 'qname' HELP PLEASE!!! web.config (relevant parts only, I cut out system.web and other sections): <?xml version="1.0"?> <configuration> <configSections> <section name = "microsoft.web.services2" type="Microsoft.Web.Services2.Configuration.WebServicesConfiguration, Microsoft.Web.Services2, Version=, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/> </configSections> <microsoft.web.services2> <security> <securityTokenManager type="ServiceNameSpace.User,ServiceNameSpace" xmlns:wsse="ServiceNameSpace"

Encountered "Could not find schema information for the element 'microsoft.web.services3'"

Hi  , I have tried to close my web.config and reopen in VS2005 to re-compile but I still encountered this error :Could not find schema information for the element 'microsoft.web.services3' . I have added in the configSection and any reference for the web.service3. Appreciate anyone who can assist me.  Below are my parts of my web.config : <configSections> <section name="microsoft.web.services3" type="Microsoft.Web.Services3.Configuration.WebServicesConfiguration, Microsoft.Web.Services3, Version=, Culture=neutral, PublicKeyToken=31bf3856ad364e35" /> </configSections> <webServices> <soapExtensionImporterTypes> <add type="Microsoft.Web.Services3.Description.WseExtensionImporter, Microsoft.Web.Services3, Version=, Culture=neutral, PublicKeyToken=31bf3856ad364e35" /> </soapExtensionImporterTypes> <soapServerProtocolFactory type="Microsoft.Web.Services3.WseProtocolFactory, Microsoft.Web.Services3, Version=, Culture=neutral, PublicKeyToken=31bf3856ad364e35" /> </webServices> </system.web> <microsoft.web.services3> <security> <securityTokenManager> <add type="Microsoft.Web.Services3.Security.Tokens.UsernameTokenManager, Microsoft.Web.Services3, Version=, Culture=neutral, PublicKeyToken=31bf3856ad364e35&qu

Can XmlSerializer add attributes to an element?

I'm using XmlSerializer to serialise a c# object into XML.public class Letter{        [XmlElement]        public String AccountNumber { get; set; }}which gives:<Letter><AccountNumber>12345678</AccountNumber></Letter>What I'd like to be able to do is to add a flag as an attribute to say if the particular data element is encrypted, so the XML comes out as:<Letter> <AccountNumber encrypted="true">=S2Hgd3$eDF</AccountNumber> </Letter>Is it possible to add this encrypted flag easily using the XmlSerializer? Thanks for any advice!

Capture attributes from schema into collection


Is there any way to capture all attributes/values (from the SOAP message) into a colleciton of my type? I tried to look at the DataContractSerializer to understand how I could initiate a new instance of my DataContract and then populate all attributes into a collection, but I can seem to find there to look.

I have a DataContract Account with properties Name (string) and Number (string), which I would like to capture into a non-datamember (collection) upon receipt from the client side. Should I look to the IXMLSerializer and move to XmlSerializerFormat - or is it possible anyhow ? I tried implement the




'Friend Sub OnDeseriali

Avoiding XML Schema attributes when serializing with [XmlInclude]


I have a class I want to serialize/deserialize from xml, for example:

public class A
	public object Content

The property named Content can be represented by various types that I specifiy using XmlIncludeAttribute:

public class A
	public object Content


I would like the xml serialization to look like:

 <B />

XML file - write attributes in root element


i have to write the following XML file using .net 2005.

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>

- <IMPORTFILE xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="ARC_Carrier_Import.xsd">

Soap proxy always initializes element with minOccurs=0 and fixed="Text"


We are consuming a webservice with the following xml fragment
< xs:element minOccurs="0" fixed="Text..." name="QBelVersicherung" type="xs:string" >
It is my understanding, that one can leave out the element "QBelVersicherung" because its minOccurs is set to "0".

After generating the webproxy thru VS 2005 we end up with a constructor that always initializes this field.
public ATBListeEntsorger()

   this.qBelVersicherungField = "Text....";

Since the element is sometimes left out in the xml message received from the server it is not possible to tell when it was send and when not, because the constructor always fills it. One way could be to edit the generated proxy class each time we update the web reference, but this does not seem like a good solution. Is there a way to alter the behavior of the proxy generator tool?

Regards Karl

Karl Haak www.karlhaak.de

How to Fixed GridViews Header and Footer when scrolling in asp.net?

This article is to show you how to Fix GridView''s Header and Footer in a simple code with CSS and JavaScript

Scrollable GridView with fixed headers in asp.net C# vb.net

In this example i am going to show how to create scrollable GridView with fixed headers which don''t get scrolled with records and stay on the top in asp.net using css, I''ve tested this code on IE7 and Firefox 2.0 , 3.5.

For this we need to add css to headers of gridview to keep them on the top.

First of all place a Panel on the aspx page from thetoolbox. Set height to 200px and width to 200px
and scrollbars to Vertical.
Now add a gridview inside this Panel and set the datasource to populate gridview.

UpdatePanel is not a known element - message when upgrading to 1.0 ajax


It worked on one of my old pages.  I change the web.config, renamed all the <asp.

On some aspx page it doesn't recognize the updatepanel.  It only does on one page.  If I create a new aspx page with a different name - then it works.

Should I just create a new web project ajax - then copy all my code into there?  Or is there a way to get those old pages to recognize the new ajax controls?

How to extract a schema from a sql server database



  I need to extract or get the schema from tables in my databse and what is the best way to do it. Is there any third party tool to do it??


Any idea will be appreciated..



get value from xml element



i have this xml

<Field Name="Users_wff_AU" Type="FIELD_TYPE_STRING" MultiValue="True">
<Value No="1">xyz</Value>
<Value No="2">abcl</Value>
<Value No="3">xcc</Value>

i want to get the  xcc in string variable

Dim strwfUser As String = xNode.Item("Value").InnerText

Could not find default endpoint element that references contract 'CurrencyProxy.CurrencyServiceSoap



I created 2 projects in my solution:

  1. Classic asp.net web service (asmx)
  2. Class library project which references service
  3. web site project which references class library project
  4. Windows app project which references service.

Both projects were created in 3.5 framework and in Visual Studio 2008 Beta 2.

I added web service reference to Class library project. When it asked for namespace I typed "CurrencyProxy". Projects build ok, but when I run web app, Class library throws an error: Could not find default endpoint element that references contract 'CurrencyProxy.CurrencyServiceSoap' in the ServiceModel client configuration section. This might be because no configuration file was found for your application, or because no endpoint element matching this contract could be found in the client element.

I believe it has something to do with app.config in Class library project. Here is part from app.config:

<binding name="CurrencyServiceSoap" closeTimeout=
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend