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!
Solved
XML INTO DATAGRIDVIEW IN VB.NET
Posted on 2013-01-05
I have a Datagridview which I would like to load from XML into the DATAGRIDVIEW AND I want to freeze the name Column. I can load a xml file no problem using basic datagrid. But I donot think Datagid can freeze a column if it can please show me
here is datagrid
Public Sub xmldatagrid()
Try
Dim ds As New DataSet
ds.ReadXml("http://199.233.14.22/NBA/2013/stats/ACX-FOULS-LEADERS.xml", XmlReadMode.InferSchema)
DataGrid1.SetDataBinding(d
Catch ex As SqlException
MessageBox.Show(ex.Message
End Try
End Sub
I can not use this with Datagridview. I need xml file to be read Starting at Listing Tag.
Here is the file
http://199.233.14.22/NBA/2013/stats/ACX-FOULS-LEADERS.xml
When I create the DataSet I get one column of tags leading up to Listing Tag. Please Help
here is datagrid
Public Sub xmldatagrid()
Try
Dim ds As New DataSet
ds.ReadXml("http://199.233.14.22/NBA/2013/stats/ACX-FOULS-LEADERS.xml", XmlReadMode.InferSchema)
DataGrid1.SetDataBinding(d
Catch ex As SqlException
MessageBox.Show(ex.Message
End Try
End Sub
I can not use this with Datagridview. I need xml file to be read Starting at Listing Tag.
Here is the file
http://199.233.14.22/NBA/2013/stats/ACX-FOULS-LEADERS.xml
When I create the DataSet I get one column of tags leading up to Listing Tag. Please Help
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2 Comments
You can't freeze column in basic datagrid
Why can't you use datagridview ? Here is code for binding data to Listing tag
Dim ds As New DataSet
ds.ReadXml("http://199.233.14.22/NBA/2013/stats/ACX-FOULS-LEADERS.xml", XmlReadMode.InferSchema)
With DataGridView1 ' the datagridview
.DataSource = ds
.DataMember = "Listing"
.AutoSizeColumnsMode = DataGridViewAutoSizeColumn
End With
Then you can freeze the column that you want with no problem
Why can't you use datagridview ? Here is code for binding data to Listing tag
Dim ds As New DataSet
ds.ReadXml("http://199.233.14.22/NBA/2013/stats/ACX-FOULS-LEADERS.xml", XmlReadMode.InferSchema)
With DataGridView1 ' the datagridview
.DataSource = ds
.DataMember = "Listing"
.AutoSizeColumnsMode = DataGridViewAutoSizeColumn
End With
Then you can freeze the column that you want with no problem
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Q&A with Course Creator, Mark Lassoff, on the importance of HTML5 in the career of a modern-day developer.
This article will show how Aten was able to supply easy management and control for Artear's video walls and wide range display configurations of their newsroom.
- Networking Hardware-Other
- MultiMedia Applications
- Switches / Hubs
- Displays / Monitors
- ATEN Technology
- Hardware, Network Architecture, *Kernel-based Virtual Machine (KVM)
This video will show you how to get GIT to work in Eclipse.
It will walk you through how to install the EGit plugin in eclipse and how to checkout an existing repository.
If you're a developer or IT admin, you’re probably tasked with managing multiple websites, servers, applications, and levels of security on a daily basis. While this can be extremely time consuming, it can also be frustrating when systems aren't wor…
Suggested Courses
Course of the Month8 days, 2 hours left to enroll
610 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.