In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!
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
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.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
Q&A with Course Creator, Mark Lassoff, on the importance of HTML5 in the career of a modern-day developer.
Tech spooks aren't just for those who are tech savvy, it also happens to those of us running a business. Check out the top tech spooks for business owners.
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.
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
Suggested Courses
Course of the Month5 days, 19 hours left to enroll
569 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.