-
XML Binding to Datagrid
When I Bind this document to the datagrid I get an Error: 'A field or property
with the name 'Display' was not found on the selected datasource.'
Why I am getting this error it is finding the time interval column
HTML Code
<asp:datagrid id="dg" runat="server" autogeneratecolumns="False">
<columns>
<asp:boundcolumn datafield="TimeInterval" readonly="True"> </asp:boundcolumn>
<asp:boundcolumn datafield="Display"></asp:boundcolumn>
</columns>
</asp:datagrid>
My XML Document Sample
<?xml version="1.0" encoding="utf-8" ?>
<TimeSlot>
<TimeInterval>00:30</TimeInterval>
<Display>Department Meeting</Display>
</TimeSlot>
<TimeSlot>
<TimeInterval>01:00</TimeInterval>
<Display>Test Setup 1</Display>
<Display>Test Setup 2</Display>
</TimeSlot>
<TimeSlot>
<TimeInterval>01:30</TimeInterval>
</TimeSlot>
<TimeSlot>
<TimeInterval>02:00</TimeInterval>
</TimeSlot>
<TimeSlot>
<TimeInterval>02:30</TimeInterval>
</TimeSlot>
<TimeSlot>
<TimeInterval>03:00</TimeInterval>
<Display>Meeting 3:00 Jon Doe</Display>
<Display>Meeting 3:00 Jane Doe</Display>
</TimeSlot>
MY asp.NET code in VB
Dim doc As System.Xml.XmlDataDocument = New System.Xml.XmlDataDocument()
Dim nsArray() As String
doc.DataSet.InferXmlSchema(Server.MapPath("XMLFile1.xml"), nsArray)
doc.Load(Server.MapPath("XMLFile1.xml"))
dg.DataSource = doc.DataSet
dg.DataBind()
-
Re: XML Binding to Datagrid
XML File Should look Like this
<?xml version="1.0" encoding="utf-8" ?>
<TimeSlot>
TimeInterval = 03:00
Display = Meeting 3:00 Jon Doe
</TimeSlot>
<TimeSlot>
TimeInterval = 03:00
Display = Meeting 3:00 Jon Doe
</TimeSlot>
<TimeSlot>
TimeInterval = 03:00
Display = Meeting 3:00 Jon Doe
</TimeSlot>
<TimeSlot>
TimeInterval = 03:00
Display = Meeting 3:00 Jon Doe
</TimeSlot>
-
Re: XML Binding to Datagrid
"alkemy" <t_t_t@j_j_j.com> wrote:
>
>XML File Should look Like this
>
>
><?xml version="1.0" encoding="utf-8" ?>
><TimeSlot>
> TimeInterval = 03:00
> Display = Meeting 3:00 Jon Doe
></TimeSlot>
><TimeSlot>
> TimeInterval = 03:00
> Display = Meeting 3:00 Jon Doe
></TimeSlot>
><TimeSlot>
> TimeInterval = 03:00
> Display = Meeting 3:00 Jon Doe
></TimeSlot>
><TimeSlot>
> TimeInterval = 03:00
> Display = Meeting 3:00 Jon Doe
></TimeSlot>
No I want the Time intervale in the grid to be displayed once. The Display
Columns could be 0 to n depending on the number of events that start at that
interval.
Layout should look like.
Interval Display
3:00 Meeting Jon Doe
Meeting Jane Doe
3:30
4:00 Go Home
4:30 Get Haircut
Pickup Kids
Go Eat
5:00
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
Forum Rules
|
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL
|
Bookmarks