Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 433
  • Last Modified:

XSD + ADO.NET + XML -> Binding to Grid

Hi,

I want to bind an XML file to a grid and be able to Add/Update/Delete.

All is working fine with the following code

--------------------------------------------------------------------------

Private dsLicence As New DataSet()

Private Sub frmMain_Load(..........)
dsLicence.ReadXmlSchema(My.Settings.XSD_PATH & "\LicencesShema.xsd")
dsLicence.ReadXml(My.Settings.XML_PATH & "\Licences.xml")

gridLicences.SetDataBinding(dsLicence, Nothing)
End Sub


Private Sub gridLicences_AfterCellUpdate(.....)
dsLicence.WriteXml(My.Settings.XML_PATH & "\Licences.xml")
End Sub

--------------------------------------------------------------------------

My problem is if the XML file is empty or does not exist i got an error. I was thinking that the use of the XSD file, even if the xml file was not existing, that i've got the base for the binding.

Is there any solution, cause for now i need to create the XML file and put some garbage data in it (Sample Data) and to block the user if he try to delete the last line of to grid.

Thanks for your help.

Here is my XML & XSD File
<?xml version="1.0"?>
<xs:schema xmlnss="http://www.w3.org/2001/XMLSchema"
xmlns:msdata="urn:schemas-microsoft-comml-msdata">
 
<xs:element name="Client">
<xs:complexType>
<xs:sequence>
<xs:element name="ID" type="xs:int" msdata:AutoIncrement="true" msdata:ReadOnly="true"/>
<xs:element name="COMPANYNAME" type="xs:string"/>
<xs:element name="NBUSER" type="xs:int" nillable="true"/> 
<xs:element name="NBUSERNOMME" type="xs:int" nillable="true"/>
<xs:element name="DATABASE" type="xs:string"/>
<xs:element name="EXPDATE" type="xs:dateTime" nillable="true"/>
</xs:sequence>
</xs:complexType>
</xs:element>
 
</xs:schema>
 
 
 
<?xml version="1.0" standalone="yes"?>
<NewDataSet>
<Client>
<ID>1</ID>
<COMPANYNAME>Sample Company</COMPANYNAME>
<NBUSER>1</NBUSER>
<NBUSERNOMME>1</NBUSERNOMME>
<DATABASE>Sample Database</DATABASE>
<EXPDATE>2009-04-27T00:00:00-04:00</EXPDATE>
</Client>
</NewDataSet>

Open in new window

0
d1rtyw0rm
Asked:
d1rtyw0rm
  • 4
  • 4
1 Solution
 
DabasCommented:
What about simply checking the contents of dsLicenses before you call setDataBinding?

If dsLicence.Tables.Count <> 0 Then
   gridLicences.SetDataBinding(dsLicence, Nothing)
End If
0
 
d1rtyw0rmAuthor Commented:
Because it crash before ... on this line

dsLicence.ReadXml(My.Settings.XML_PATH & "\Licences.xml")
0
 
DabasCommented:
What if you wrap that line inside a try catch?


Private dsLicence As New DataSet()
 
Private Sub frmMain_Load(..........)
Try
    dsLicence.ReadXmlSchema(My.Settings.XSD_PATH & "\LicencesShema.xsd")
    dsLicence.ReadXml(My.Settings.XML_PATH & "\Licences.xml")
    gridLicences.SetDataBinding(dsLicence, Nothing)
Catch (ex as Exception)
    MessageBox.Show("Something seems to be wrong with the xml file")
End Try
 
End Sub

Open in new window

0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
d1rtyw0rmAuthor Commented:
First of all thanks a lot for your help but ...

That's exactly what i do for now, but what i want is to be able to RUN IT without an XML file, and the grid column to be based on my xsd file.

The problem that i have is that i'm in the obligation to create an XML file with at least one record, and i can't delete the last item of a grid because the XML will be empty and unavailible for the next use.

Hope that you understand what is my problem.
0
 
DabasCommented:
Sorry I do not.
0
 
d1rtyw0rmAuthor Commented:
All i want, is to be able to bind a grid to an empty XML file.

Based on an XSD file to setup the column title.
0
 
DabasCommented:
What about this idea:

You create a non-empty xml, that confroms to your xsd file, just that it has empty nodes.

Something like in the snippet

You use the code I posted before, only that if the catch statement is reached you bind to this file?

Dabas
<?xml version="1.0" standalone="yes"?>
<NewDataSet>
<Client>
<COMPANYNAME>COMPANYNAME>
<DATABASE></DATABASE>
</Client>
</NewDataSet>

Open in new window

0
 
d1rtyw0rmAuthor Commented:
Thanks a lot for your patience, it's really appreciated !
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now