473,320 Members | 1,930 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Dataset, XML and datagrids

I would not have thought that getting a DataGrid connected to a DataSet
(read in from an XML file) would be this complicated. I cannot get this to
work. I have read everything I could find and modeled all the examples
given but this grid just refuses to behave nicely.

The code is listed below as well as the XML schema and XML data.

The connection between the data set and grid seems to work just fine. What
won't work is the display of the data. No matter what I do, the grid is
always displayed collapsed. I also do not want to display the "Mappings:"
caption that appears above the column headers. The column headers do not
seem to respond to the .width command.

I also read something about a SetDataBindings command that I do not know if
I need or not. Some code has it, some doesn't.

Any help would be, well, helpful.

Thanks.

Steve

***********************

Code

Imports System
Imports System.Data
Imports System.Xml
Imports System.Drawing
Imports System.Windows.Forms

Public Class TestDataGrid

Inherits System.Windows.Forms.Form

#Region " Windows Form Designer generated code "

Public Sub New()
MyBase.New()

'This call is required by the Windows Form Designer.

InitializeComponent()

'Add any initialization after the InitializeComponent() call

End Sub

'Form overrides dispose to clean up the component list.

Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean)

If disposing Then
If Not (components Is Nothing) Then
components.Dispose()
End If
End If

MyBase.Dispose(disposing)

End Sub

'Required by the Windows Form Designer

Private components As System.ComponentModel.IContainer

'NOTE: The following procedure is required by the Windows Form Designer

'It can be modified using the Windows Form Designer.

'Do not modify it using the code editor.

Friend WithEvents dgTest As System.Windows.Forms.DataGrid

<System.Diagnostics.DebuggerStepThrough()> Private Sub
InitializeComponent()

Me.dgTest = New System.Windows.Forms.DataGrid()
CType(Me.dgTest,System.ComponentModel.ISupportInit ialize).BeginInit()

Me.SuspendLayout()

'
'dgTest
'
Me.dgTest.CaptionVisible = False
Me.dgTest.DataMember = ""
Me.dgTest.HeaderForeColor = System.Drawing.SystemColors.ControlText
Me.dgTest.Location = New System.Drawing.Point(32, 32)
Me.dgTest.Name = "dgTest"
Me.dgTest.Size = New System.Drawing.Size(416, 216)
Me.dgTest.TabIndex = 0
'
'TestDataGrid
'
Me.AutoScaleBaseSize = New System.Drawing.Size(5, 13)
Me.ClientSize = New System.Drawing.Size(496, 317)
Me.Controls.AddRange(New System.Windows.Forms.Control() {Me.dgTest})
Me.Name = "TestDataGrid"
Me.Text = "Test Data Grid"
CType(Me.dgTest, System.ComponentModel.ISupportInitialize).EndInit( )
Me.ResumeLayout(False)

End Sub

#End Region

Dim dsTM As DataSet
Dim mstrAppDataPath As String

Private Sub TestDataGrid_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load

Dim strStartupPath As String
Dim iLen As Integer

' get the application data path

strStartupPath = Application.StartupPath()
iLen = strStartupPath.LastIndexOf("\")
mstrAppDataPath = strStartupPath.Substring(0, iLen)

GetTC2000Mappings()

BindXMLtoGrid()

End Sub

Private Sub GetTC2000Mappings()

Dim sXMLDataFN As String

dsTM = New DataSet("SymbolMapping")

' Load the XML File

sXMLDataFN = mstrAppDataPath & "\data\SymbolMapping.xsd"
dsTM.ReadXmlSchema(sXMLDataFN)

sXMLDataFN = mstrAppDataPath & "\data\SymbolMapping.xml"
dsTM.ReadXml(sXMLDataFN)

End Sub

Private Sub BindXMLtoGrid()

Dim ts As DataGridTableStyle
Dim cs As DataGridTextBoxColumn

dgTest.DataSource = dsTM

'create a custom tablestyle and add three columnstyles
ts = New DataGridTableStyle()
ts.MappingName = "tsSymbolMapping"

' create a column for TC2000

cs = New DataGridTextBoxColumn()
cs.MappingName = "TC2000"
cs.HeaderText = "TC2000 Symbol"
cs.Width = 40
cs.NullText = ""
ts.GridColumnStyles.Add(cs)

' create a column for HQuote

cs = Nothing
cs = New DataGridTextBoxColumn()
cs.MappingName = "HQuote"
cs.HeaderText = "HQuote Symbol"
cs.Width = 40
cs.NullText = ""
ts.GridColumnStyles.Add(cs)

' create a column for Comment
cs = Nothing
cs = New DataGridTextBoxColumn()
cs.MappingName = "Comment"
cs.HeaderText = "Comment"
cs.Width = 160
cs.NullText = ""
ts.GridColumnStyles.Add(cs)
dgTest.TableStyles.Clear()
dgTest.TableStyles.Add(ts)
dgTest.CaptionVisible = False

ts = Nothing
cs = Nothing
End Sub

End Class
***********************

XML Schema in file AppDataPath & "\data\SymbolMapping.xsd"
<?xml version="1.0" encoding="UTF-8"?>
<xs:schema targetNamespace="http://exactlymypoint.com/namespace"
xmlns="http://exactlymypoint.com/namespace"
xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified"
attributeFormDefault="unqualified">

<xs:element name="Mappings">
<xs:annotation>
<xs:documentation>Maps HQuote symbols to TC2000
symbols</xs:documentation>
</xs:annotation>
<xs:complexType>
<xs:sequence maxOccurs="unbounded">
<xs:element name="Map">
<xs:complexType>
<xs:sequence>
<xs:element name="HQuote"
type="xs:string"/>
<xs:element name="TC2000"
type="xs:string"/>
<xs:element name="Comment"
type="xs:string"/>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>
***********************

XML Data in file AppDataPath & "\data\SymbolMapping.xsd"

<?xml version="1.0" encoding="UTF-8"?>
<Mappings xmlns="http://exactlymypoint.com/namespace"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://exactlymypoint.com/namespace
C:\DOCUME~1\sgould\MYDOCU~1\VISUAL~1\HourlyConvert er\HourlyConverter\data\Sy
mbolMapping.xsd">
<Map>
<HQuote>$INDU</HQuote>
<TC2000>dj-30</TC2000>
<Comment>Dow Jones Industrial Average (sm)</Comment>
</Map>
<Map>
<HQuote>DJI</HQuote>
<TC2000>dj-30</TC2000>
<Comment>Dow Jones Industrial Average (sm)</Comment>
</Map>
<Map>
<HQuote>TRAN</HQuote>
<TC2000>dj-20</TC2000>
<Comment>Dow Jones Transportation Average</Comment>
</Map>
<Map>
<HQuote>DJT</HQuote>
<TC2000>dj-20</TC2000>
<Comment>Dow Jones Transportation Average</Comment>
</Map>
<Map>
<HQuote>UTIL</HQuote>
<TC2000>dj-15</TC2000>
<Comment>Dow Jones Utilities Average</Comment>
</Map>
<Map>
<HQuote>DJU</HQuote>
<TC2000>dj-15</TC2000>
<Comment>Dow Jones Utilities Average</Comment>
</Map>
<Map>
<HQuote> DJX.X</HQuote>
<TC2000>dj-30</TC2000>
<Comment>Dow Jones Industrial Average (CBOE) </Comment>
</Map>
<Map>
<HQuote>DTX.X</HQuote>
<TC2000>dj-20</TC2000>
<Comment>Dow Jones Transportation Average (CBOE)</Comment>
</Map>
</Mappings>


Nov 20 '05 #1
2 1404
Hi Steve,

Some observations and suggestions:

1. All the table style / column style setup stuff should go BEFORE the data
binding occurs. This seems to be not the case in your code and this is the
most likely reason of the problem.

2. It is strongly recommended to use SetDataBinding method instead of
setting the DataSource and DataMember properties directly. The reason seems
to be that this method does some additional but necessary work behind the
scenes which is not done when raw properties are being set.

Hope this helps.

--
Dmitriy Lapshin [C# / .NET MVP]
X-Unity Test Studio
http://x-unity.miik.com.ua/teststudio.aspx
Bring the power of unit testing to VS .NET IDE

"Steve" <sg****@convansys.com> wrote in message
news:OM**************@TK2MSFTNGP09.phx.gbl...
I would not have thought that getting a DataGrid connected to a DataSet
(read in from an XML file) would be this complicated. I cannot get this to work. I have read everything I could find and modeled all the examples
given but this grid just refuses to behave nicely.

The code is listed below as well as the XML schema and XML data.

The connection between the data set and grid seems to work just fine. What won't work is the display of the data. No matter what I do, the grid is
always displayed collapsed. I also do not want to display the "Mappings:"
caption that appears above the column headers. The column headers do not
seem to respond to the .width command.

I also read something about a SetDataBindings command that I do not know if I need or not. Some code has it, some doesn't.

Any help would be, well, helpful.

Thanks.

Steve

***********************

Code

Imports System
Imports System.Data
Imports System.Xml
Imports System.Drawing
Imports System.Windows.Forms

Public Class TestDataGrid

Inherits System.Windows.Forms.Form

#Region " Windows Form Designer generated code "

Public Sub New()
MyBase.New()

'This call is required by the Windows Form Designer.

InitializeComponent()

'Add any initialization after the InitializeComponent() call

End Sub

'Form overrides dispose to clean up the component list.

Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean)

If disposing Then
If Not (components Is Nothing) Then
components.Dispose()
End If
End If

MyBase.Dispose(disposing)

End Sub

'Required by the Windows Form Designer

Private components As System.ComponentModel.IContainer

'NOTE: The following procedure is required by the Windows Form Designer
'It can be modified using the Windows Form Designer.

'Do not modify it using the code editor.

Friend WithEvents dgTest As System.Windows.Forms.DataGrid

<System.Diagnostics.DebuggerStepThrough()> Private Sub
InitializeComponent()

Me.dgTest = New System.Windows.Forms.DataGrid()
CType(Me.dgTest,System.ComponentModel.ISupportInit ialize).BeginInit()

Me.SuspendLayout()

'
'dgTest
'
Me.dgTest.CaptionVisible = False
Me.dgTest.DataMember = ""
Me.dgTest.HeaderForeColor = System.Drawing.SystemColors.ControlText Me.dgTest.Location = New System.Drawing.Point(32, 32)
Me.dgTest.Name = "dgTest"
Me.dgTest.Size = New System.Drawing.Size(416, 216)
Me.dgTest.TabIndex = 0
'
'TestDataGrid
'
Me.AutoScaleBaseSize = New System.Drawing.Size(5, 13)
Me.ClientSize = New System.Drawing.Size(496, 317)
Me.Controls.AddRange(New System.Windows.Forms.Control() {Me.dgTest}) Me.Name = "TestDataGrid"
Me.Text = "Test Data Grid"
CType(Me.dgTest, System.ComponentModel.ISupportInitialize).EndInit( ) Me.ResumeLayout(False)

End Sub

#End Region

Dim dsTM As DataSet
Dim mstrAppDataPath As String

Private Sub TestDataGrid_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

Dim strStartupPath As String
Dim iLen As Integer

' get the application data path

strStartupPath = Application.StartupPath()
iLen = strStartupPath.LastIndexOf("\")
mstrAppDataPath = strStartupPath.Substring(0, iLen)

GetTC2000Mappings()

BindXMLtoGrid()

End Sub

Private Sub GetTC2000Mappings()

Dim sXMLDataFN As String

dsTM = New DataSet("SymbolMapping")

' Load the XML File

sXMLDataFN = mstrAppDataPath & "\data\SymbolMapping.xsd"
dsTM.ReadXmlSchema(sXMLDataFN)

sXMLDataFN = mstrAppDataPath & "\data\SymbolMapping.xml"
dsTM.ReadXml(sXMLDataFN)

End Sub

Private Sub BindXMLtoGrid()

Dim ts As DataGridTableStyle
Dim cs As DataGridTextBoxColumn

dgTest.DataSource = dsTM

'create a custom tablestyle and add three columnstyles
ts = New DataGridTableStyle()
ts.MappingName = "tsSymbolMapping"

' create a column for TC2000

cs = New DataGridTextBoxColumn()
cs.MappingName = "TC2000"
cs.HeaderText = "TC2000 Symbol"
cs.Width = 40
cs.NullText = ""
ts.GridColumnStyles.Add(cs)

' create a column for HQuote

cs = Nothing
cs = New DataGridTextBoxColumn()
cs.MappingName = "HQuote"
cs.HeaderText = "HQuote Symbol"
cs.Width = 40
cs.NullText = ""
ts.GridColumnStyles.Add(cs)

' create a column for Comment
cs = Nothing
cs = New DataGridTextBoxColumn()
cs.MappingName = "Comment"
cs.HeaderText = "Comment"
cs.Width = 160
cs.NullText = ""
ts.GridColumnStyles.Add(cs)
dgTest.TableStyles.Clear()
dgTest.TableStyles.Add(ts)
dgTest.CaptionVisible = False

ts = Nothing
cs = Nothing
End Sub

End Class
***********************

XML Schema in file AppDataPath & "\data\SymbolMapping.xsd"
<?xml version="1.0" encoding="UTF-8"?>
<xs:schema targetNamespace="http://exactlymypoint.com/namespace"
xmlns="http://exactlymypoint.com/namespace"
xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified"
attributeFormDefault="unqualified">

<xs:element name="Mappings">
<xs:annotation>
<xs:documentation>Maps HQuote symbols to TC2000
symbols</xs:documentation>
</xs:annotation>
<xs:complexType>
<xs:sequence maxOccurs="unbounded">
<xs:element name="Map">
<xs:complexType>
<xs:sequence>
<xs:element name="HQuote"
type="xs:string"/>
<xs:element name="TC2000"
type="xs:string"/>
<xs:element name="Comment"
type="xs:string"/>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>
***********************

XML Data in file AppDataPath & "\data\SymbolMapping.xsd"

<?xml version="1.0" encoding="UTF-8"?>
<Mappings xmlns="http://exactlymypoint.com/namespace"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://exactlymypoint.com/namespace
C:\DOCUME~1\sgould\MYDOCU~1\VISUAL~1\HourlyConvert er\HourlyConverter\data\Sy mbolMapping.xsd">
<Map>
<HQuote>$INDU</HQuote>
<TC2000>dj-30</TC2000>
<Comment>Dow Jones Industrial Average (sm)</Comment>
</Map>
<Map>
<HQuote>DJI</HQuote>
<TC2000>dj-30</TC2000>
<Comment>Dow Jones Industrial Average (sm)</Comment>
</Map>
<Map>
<HQuote>TRAN</HQuote>
<TC2000>dj-20</TC2000>
<Comment>Dow Jones Transportation Average</Comment>
</Map>
<Map>
<HQuote>DJT</HQuote>
<TC2000>dj-20</TC2000>
<Comment>Dow Jones Transportation Average</Comment>
</Map>
<Map>
<HQuote>UTIL</HQuote>
<TC2000>dj-15</TC2000>
<Comment>Dow Jones Utilities Average</Comment>
</Map>
<Map>
<HQuote>DJU</HQuote>
<TC2000>dj-15</TC2000>
<Comment>Dow Jones Utilities Average</Comment>
</Map>
<Map>
<HQuote> DJX.X</HQuote>
<TC2000>dj-30</TC2000>
<Comment>Dow Jones Industrial Average (CBOE) </Comment>
</Map>
<Map>
<HQuote>DTX.X</HQuote>
<TC2000>dj-20</TC2000>
<Comment>Dow Jones Transportation Average (CBOE)</Comment>
</Map>
</Mappings>




Nov 20 '05 #2
Thanks for the help.

I moved the binding statement as such.

Private Sub BindXMLtoGrid()

Dim ts As DataGridTableStyle

Dim cs As DataGridTextBoxColumn

'create a custom tablestyle and add three columnstyles

ts = New DataGridTableStyle()

ts.MappingName = "tsSymbolMapping"

' create a column for TC2000

cs = New DataGridTextBoxColumn()

cs.MappingName = "TC2000"

cs.HeaderText = "TC2000 Symbol"

cs.Width = 40

cs.NullText = ""

ts.GridColumnStyles.Add(cs)

:

:

dgTest.TableStyles.Clear()

dgTest.TableStyles.Add(ts)

dgTest.CaptionVisible = False

dgTest.SetDataBinding(dsTM, "tsSymbolMapping")

ts = Nothing

cs = Nothing

End Sub

The statement

dgTest.SetDataBinding(dsTM, "tsSymbolMapping")

is giving me errors now. It says "Can't create a child list for field
tsSymbolMapping. This was giving me fits earlier. What is the datamember
that is supposed to go here?

Thanks again.

Steve



"Dmitriy Lapshin [C# / .NET MVP]" <x-****@no-spam-please.hotpop.com> wrote
in message news:Of*************@TK2MSFTNGP11.phx.gbl...
Hi Steve,

Some observations and suggestions:

1. All the table style / column style setup stuff should go BEFORE the data binding occurs. This seems to be not the case in your code and this is the
most likely reason of the problem.

2. It is strongly recommended to use SetDataBinding method instead of
setting the DataSource and DataMember properties directly. The reason seems to be that this method does some additional but necessary work behind the
scenes which is not done when raw properties are being set.

Hope this helps.

--
Dmitriy Lapshin [C# / .NET MVP]
X-Unity Test Studio
http://x-unity.miik.com.ua/teststudio.aspx
Bring the power of unit testing to VS .NET IDE

"Steve" <sg****@convansys.com> wrote in message
news:OM**************@TK2MSFTNGP09.phx.gbl...
I would not have thought that getting a DataGrid connected to a DataSet
(read in from an XML file) would be this complicated. I cannot get this

to
work. I have read everything I could find and modeled all the examples
given but this grid just refuses to behave nicely.

The code is listed below as well as the XML schema and XML data.

The connection between the data set and grid seems to work just fine.

What
won't work is the display of the data. No matter what I do, the grid is
always displayed collapsed. I also do not want to display the "Mappings:" caption that appears above the column headers. The column headers do not seem to respond to the .width command.

I also read something about a SetDataBindings command that I do not know

if
I need or not. Some code has it, some doesn't.

Any help would be, well, helpful.

Thanks.

Steve

***********************

Code

Imports System
Imports System.Data
Imports System.Xml
Imports System.Drawing
Imports System.Windows.Forms

Public Class TestDataGrid

Inherits System.Windows.Forms.Form

#Region " Windows Form Designer generated code "

Public Sub New()
MyBase.New()

'This call is required by the Windows Form Designer.

InitializeComponent()

'Add any initialization after the InitializeComponent() call

End Sub

'Form overrides dispose to clean up the component list.

Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean)
If disposing Then
If Not (components Is Nothing) Then
components.Dispose()
End If
End If

MyBase.Dispose(disposing)

End Sub

'Required by the Windows Form Designer

Private components As System.ComponentModel.IContainer

'NOTE: The following procedure is required by the Windows Form

Designer

'It can be modified using the Windows Form Designer.

'Do not modify it using the code editor.

Friend WithEvents dgTest As System.Windows.Forms.DataGrid

<System.Diagnostics.DebuggerStepThrough()> Private Sub
InitializeComponent()

Me.dgTest = New System.Windows.Forms.DataGrid()
CType(Me.dgTest,System.ComponentModel.ISupportInit ialize).BeginInit()

Me.SuspendLayout()

'
'dgTest
'
Me.dgTest.CaptionVisible = False
Me.dgTest.DataMember = ""
Me.dgTest.HeaderForeColor =

System.Drawing.SystemColors.ControlText
Me.dgTest.Location = New System.Drawing.Point(32, 32)
Me.dgTest.Name = "dgTest"
Me.dgTest.Size = New System.Drawing.Size(416, 216)
Me.dgTest.TabIndex = 0
'
'TestDataGrid
'
Me.AutoScaleBaseSize = New System.Drawing.Size(5, 13)
Me.ClientSize = New System.Drawing.Size(496, 317)
Me.Controls.AddRange(New System.Windows.Forms.Control()

{Me.dgTest})
Me.Name = "TestDataGrid"
Me.Text = "Test Data Grid"
CType(Me.dgTest,

System.ComponentModel.ISupportInitialize).EndInit( )
Me.ResumeLayout(False)

End Sub

#End Region

Dim dsTM As DataSet
Dim mstrAppDataPath As String

Private Sub TestDataGrid_Load(ByVal sender As System.Object, ByVal e

As
System.EventArgs) Handles MyBase.Load

Dim strStartupPath As String
Dim iLen As Integer

' get the application data path

strStartupPath = Application.StartupPath()
iLen = strStartupPath.LastIndexOf("\")
mstrAppDataPath = strStartupPath.Substring(0, iLen)

GetTC2000Mappings()

BindXMLtoGrid()

End Sub

Private Sub GetTC2000Mappings()

Dim sXMLDataFN As String

dsTM = New DataSet("SymbolMapping")

' Load the XML File

sXMLDataFN = mstrAppDataPath & "\data\SymbolMapping.xsd"
dsTM.ReadXmlSchema(sXMLDataFN)

sXMLDataFN = mstrAppDataPath & "\data\SymbolMapping.xml"
dsTM.ReadXml(sXMLDataFN)

End Sub

Private Sub BindXMLtoGrid()

Dim ts As DataGridTableStyle
Dim cs As DataGridTextBoxColumn

dgTest.DataSource = dsTM

'create a custom tablestyle and add three columnstyles
ts = New DataGridTableStyle()
ts.MappingName = "tsSymbolMapping"

' create a column for TC2000

cs = New DataGridTextBoxColumn()
cs.MappingName = "TC2000"
cs.HeaderText = "TC2000 Symbol"
cs.Width = 40
cs.NullText = ""
ts.GridColumnStyles.Add(cs)

' create a column for HQuote

cs = Nothing
cs = New DataGridTextBoxColumn()
cs.MappingName = "HQuote"
cs.HeaderText = "HQuote Symbol"
cs.Width = 40
cs.NullText = ""
ts.GridColumnStyles.Add(cs)

' create a column for Comment
cs = Nothing
cs = New DataGridTextBoxColumn()
cs.MappingName = "Comment"
cs.HeaderText = "Comment"
cs.Width = 160
cs.NullText = ""
ts.GridColumnStyles.Add(cs)
dgTest.TableStyles.Clear()
dgTest.TableStyles.Add(ts)
dgTest.CaptionVisible = False

ts = Nothing
cs = Nothing
End Sub

End Class
***********************

XML Schema in file AppDataPath & "\data\SymbolMapping.xsd"
<?xml version="1.0" encoding="UTF-8"?>
<xs:schema targetNamespace="http://exactlymypoint.com/namespace"
xmlns="http://exactlymypoint.com/namespace"
xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified" attributeFormDefault="unqualified">

<xs:element name="Mappings">
<xs:annotation>
<xs:documentation>Maps HQuote symbols to TC2000
symbols</xs:documentation>
</xs:annotation>
<xs:complexType>
<xs:sequence maxOccurs="unbounded">
<xs:element name="Map">
<xs:complexType>
<xs:sequence>
<xs:element name="HQuote"
type="xs:string"/>
<xs:element name="TC2000"
type="xs:string"/>
<xs:element name="Comment" type="xs:string"/>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>
***********************

XML Data in file AppDataPath & "\data\SymbolMapping.xsd"

<?xml version="1.0" encoding="UTF-8"?>
<Mappings xmlns="http://exactlymypoint.com/namespace"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://exactlymypoint.com/namespace

C:\DOCUME~1\sgould\MYDOCU~1\VISUAL~1\HourlyConvert er\HourlyConverter\data\Sy
mbolMapping.xsd">
<Map>
<HQuote>$INDU</HQuote>
<TC2000>dj-30</TC2000>
<Comment>Dow Jones Industrial Average (sm)</Comment>
</Map>
<Map>
<HQuote>DJI</HQuote>
<TC2000>dj-30</TC2000>
<Comment>Dow Jones Industrial Average (sm)</Comment>
</Map>
<Map>
<HQuote>TRAN</HQuote>
<TC2000>dj-20</TC2000>
<Comment>Dow Jones Transportation Average</Comment>
</Map>
<Map>
<HQuote>DJT</HQuote>
<TC2000>dj-20</TC2000>
<Comment>Dow Jones Transportation Average</Comment>
</Map>
<Map>
<HQuote>UTIL</HQuote>
<TC2000>dj-15</TC2000>
<Comment>Dow Jones Utilities Average</Comment>
</Map>
<Map>
<HQuote>DJU</HQuote>
<TC2000>dj-15</TC2000>
<Comment>Dow Jones Utilities Average</Comment>
</Map>
<Map>
<HQuote> DJX.X</HQuote>
<TC2000>dj-30</TC2000>
<Comment>Dow Jones Industrial Average (CBOE) </Comment>
</Map>
<Map>
<HQuote>DTX.X</HQuote>
<TC2000>dj-20</TC2000>
<Comment>Dow Jones Transportation Average (CBOE)</Comment>
</Map>
</Mappings>



Nov 20 '05 #3

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

Similar topics

2
by: Wayne Wengert | last post by:
I am attempting to generate an XML file based on the contents of a dataset which contains a parent-child relationship but when I create the output file all I get is the XML header as shown here: ...
2
by: DC Gringo | last post by:
This code has two SELECT statements, each returning several records. I want to fill a dataset and then two datagrids. How would I fill the SECOND datagrid from this code ----- Sub...
1
by: MicroMoth | last post by:
I know that this is probably a simple question, but I can't seem to find out how to populate the form fields I have with the results from my stored procedure, which I have stored in a datase. I...
1
by: Chris | last post by:
Hi, I have the following dataset Loc Qty Amt OH 5 2 NC 4 1 OH 2 4 I have two datagrids on the same page one for OH and the other for NC. Is it possible to select only OH rows from one...
22
by: EMW | last post by:
Hi, I managed to create a SQL server database and a table in it. The table is empty and that brings me to my next chalenge: How can I get the info in the table in the dataset to go in an empty...
2
by: John Granade | last post by:
I'm looking for the best way to make a dataset available from multiple Windows forms. The dataset is created from an XML file. I have a main form (frmMain) that loads the dataset and reads the...
14
by: Lars Netzel | last post by:
A little background: I use three Datagrids that are in a child parent relation. I Use Negative Autoincrement on the the DataTables and that's workning nice. My problem is when I Update these...
2
by: Lenster | last post by:
I'm having problems using the errorprovider in VB.NET to automatically display an error icon next to textboxes bound to the same dataset as the errorprovider. The sequence of events is : ...
8
by: Agnes | last post by:
I got one dataset, one datatable, but two datagrids. I use dataview.rowfilter = 'sex ="F" and dataview.rowfilter = 'sex ="M" to filter the information and set to two datagrids's datasource =...
7
by: David P. Donahue | last post by:
My experience with databases using C# has been pretty limited thus far. Mostly I just use a SELECT statement to populate a DataSet, which is just read-only (mostly for display on a web page), or...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.