FREE GUIDES: In-depth and hand-crafted Linux, AWS, OpenStack, DevOps, Azure, and Cloud training guides created by Linux Academy instructors and the community.
COURSE of the MONTH
9 days, 20 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Help with displaying partial column name from xml file in combobox using vb.net
Posted on 2016-09-24
Hi,
How do I modify the code below to only display the first 5 records in a table and also from the to the 12th record. i need to display records in a combobox depending on which categories chosen.
Private Sub Button8_Click(sender As System.Object, e As System.EventArgs) Handles Button8.Click
Dim xmlPath1 As String
Dim dtsetcol1 As New DataSet
xmlPath1 = System.IO.Path.Combine(App
dtsetcol1.Clear()
dtsetcol1.ReadXml(xmlPath1
Me.ComboBox3.DataSource = dtsetcol1.Tables(0).Column
End Sub
Thanks,
Victor
How do I modify the code below to only display the first 5 records in a table and also from the to the 12th record. i need to display records in a combobox depending on which categories chosen.
Private Sub Button8_Click(sender As System.Object, e As System.EventArgs) Handles Button8.Click
Dim xmlPath1 As String
Dim dtsetcol1 As New DataSet
xmlPath1 = System.IO.Path.Combine(App
dtsetcol1.Clear()
dtsetcol1.ReadXml(xmlPath1
Me.ComboBox3.DataSource = dtsetcol1.Tables(0).Column
End Sub
Thanks,
Victor
[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
7-
6
13 Comments
Active today
Hi Victor;
To part of your question, "How do I modify the code below to only display the first 5 records ", The way you are loading the records does not allow for filtering the rows during the load. You can try removing the rows from the XML before loading or you can try removing/deleting the rows after the rows have been added.
To this part of the question, "also from the to the 12th record. i need to display records in a combobox depending on which categories chosen", do you mean "from the X to the 12th record." where X is a number from 0 to 11 and is determine at run time or something else?
To part of your question, "How do I modify the code below to only display the first 5 records ", The way you are loading the records does not allow for filtering the rows during the load. You can try removing the rows from the XML before loading or you can try removing/deleting the rows after the rows have been added.
To this part of the question, "also from the to the 12th record. i need to display records in a combobox depending on which categories chosen", do you mean "from the X to the 12th record." where X is a number from 0 to 11 and is determine at run time or something else?
Hi Fernando,
Yes, x is a number from 0 and 11 and determined at run time, how do you remove the columns from the xml file and save yhe new file to a temp table to displays the records?
Thanks,
Victor
Yes, x is a number from 0 and 11 and determined at run time, how do you remove the columns from the xml file and save yhe new file to a temp table to displays the records?
Thanks,
Victor
Active today
That would depend on the schema / structure of the XML. Please post an accurate representation of the XML file so I can show you how.
Hi Fernando,
Below is the structure of the xml file.
<Root>
<Fields>
<FieldsN>SN</FieldsN>
</Fields>
<Fields>
<FieldsN>COUNTRY</FieldsN>
</Fields>
<Fields>
<FieldsN>AGD4</FieldsN>
</Fields>
<Fields>
<FieldsN>FIF</FieldsN>
</Fields>
<Fields>
<FieldsN>NSN</FieldsN>
</Fields>
<Fields>
<FieldsN>RN</FieldsN>
</Fields>
<Fields>
<FieldsN>NAS</FieldsN>
</Fields>
</Root>
Thanks,
Victor
Below is the structure of the xml file.
<Root>
<Fields>
<FieldsN>SN</FieldsN>
</Fields>
<Fields>
<FieldsN>COUNTRY</FieldsN>
</Fields>
<Fields>
<FieldsN>AGD4</FieldsN>
</Fields>
<Fields>
<FieldsN>FIF</FieldsN>
</Fields>
<Fields>
<FieldsN>NSN</FieldsN>
</Fields>
<Fields>
<FieldsN>RN</FieldsN>
</Fields>
<Fields>
<FieldsN>NAS</FieldsN>
</Fields>
</Root>
Thanks,
Victor
Active today
How will you want the list to be filtered / delete items so that they don't show up in the ComboBox?
Hi Fernando,
Sorry for the late reply, Is it possible for the temp table to only contain the records I want to display?
Thanks,
Victor
Sorry for the late reply, Is it possible for the temp table to only contain the records I want to display?
Thanks,
Victor
Active today
To your question, "Sorry for the late reply, Is it possible for the temp table to only contain the records I want to display? ", In short the answer is Yes. But that also will depend on what Temp Table is? Is it a .Net DataTable object, or an SQL Temp Table or something else and how you will be filtering the rows for the ones you want to display.
Hi Fernando,
In previous post you suggested it may be best to delete the rows of the records I don't want to display, I would like to access to new file with deleted rows to a temp table using the .NET DataTable.
Thanks,
Victor
In previous post you suggested it may be best to delete the rows of the records I don't want to display, I would like to access to new file with deleted rows to a temp table using the .NET DataTable.
Thanks,
Victor
Active today
Hi Victor;
In order to get a solution to your question lets try it this way. The original post you posted will not work because of this line of code.
In order to get a solution to your question lets try it this way. The original post you posted will not work because of this line of code.
Me.ComboBox3.DataSource = dtsetcol1.Tables(0).Columns(0).ColumnName
Private Sub Button8_Click(sender As Object, e As EventArgs) Handles Button8.Click
Dim xmlPath1 As String
Dim dtsetcol1 As New DataSet
xmlPath1 = System.IO.Path.Combine(Application.StartupPath + "\MainTest.xml") 'grid1
dtsetcol1.Clear()
dtsetcol1.ReadXml(xmlPath1)
DataGridView1.DataSource = dtsetcol1.Tables(0)
Me.ComboBox3.DataSource = dtsetcol1.Tables(0).AsEnumerable().Select(Function(c) c.Field(Of String)("FieldsN")).ToList()
End Sub
Featured Post
New feature! Upgrade and increase expert visibility of your issues with Priority Questions.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Welcome my friends to the second instalment and follow-up to our Minify and Concatenate Your Scripts and Stylesheets (http://www.experts-exchange.com/Programming/Languages/.NET/ASP.NET/A_4334-Minify-and-Concatenate-Your-Scripts-and-Stylesheets.html)…
This article describes relatively difficult and non-obvious issues that are likely to arise when creating COM class in Visual Studio and deploying it by professional MSI-authoring tools. It is assumed that the reader is already familiar with the cla…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you!
In this Micro Tutorial, you'll learn yo…
- Microsoft Applications
- Windows 10
- Windows OS
- Fonts Typography
- Windows 7, Microsoft Word
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Suggested Courses
Course of the Month9 days, 20 hours left to enroll
762 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.