asked on

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

Dabas

What about simply checking the contents of dsLicenses before you call setDataBinding?

If dsLicence.Tables.Count <> 0 Then
gridLicences.SetDataBinding(dsLicence, Nothing)
End If

d1rtyw0rm

ASKER

Because it crash before ... on this line

dsLicence.ReadXml(My.Settings.XML_PATH & "\Licences.xml")

Dabas

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

d1rtyw0rm

ASKER

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.

Dabas

Sorry I do not.

d1rtyw0rm

ASKER

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.

ASKER CERTIFIED SOLUTION

Dabas

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

d1rtyw0rm

ASKER

Thanks a lot for your patience, it's really appreciated !

XSD + ADO.NET + XML -&gt; Binding to Grid

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