Solved

Help with displaying partial column name from xml file in combobox using vb.net

Posted on 2016-09-24

1 solution

54 Views

Last Modified: 2016-10-02

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(Application.StartupPath + "\MainTest.xml") 'grid1
dtsetcol1.Clear()
dtsetcol1.ReadXml(xmlPath1)
Me.ComboBox3.DataSource = dtsetcol1.Tables(0).Columns(0).ColumnName
End Sub

Thanks,

Victor

Comment

Question by:vcharles

[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

Join The Community

13 Comments

LVL 63

Expert Comment

by:Fernando Soto

ID: 418166012016-09-26

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?

Author Comment

by:vcharles

ID: 418168202016-09-26

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

LVL 63

Expert Comment

by:Fernando Soto

ID: 418168312016-09-26

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.

Author Comment

by:vcharles

ID: 418169942016-09-26

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

LVL 63

Expert Comment

by:Fernando Soto

ID: 418170242016-09-26

How will you want the list to be filtered / delete items so that they don't show up in the ComboBox?

Author Comment

by:vcharles

ID: 418249162016-10-01

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

LVL 63

Expert Comment

by:Fernando Soto

ID: 418253772016-10-02

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.

Author Comment

by:vcharles

ID: 418253902016-10-02

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

LVL 63

Accepted Solution

by:Fernando Soto

Fernando Soto earned 500 total points

ID: 418254492016-10-02

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.

 Me.ComboBox3.DataSource = dtsetcol1.Tables(0).Columns(0).ColumnName

Open in new window

You should have gotten an runtime exception something like "Complex DataBinding accepts as a data source either an IList or an IListSource.", the line of code is returning a data type of string which is the name of the column and not a IList. I changed the last line to what is shown in the code snippet below.

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

Open in new window

Is this what you are looking for?

Author Comment

by:vcharles

ID: 418254722016-10-02

Yes. Thank you.

LVL 63

Expert Comment

by:Fernando Soto

ID: 418257252016-10-02

Hi Victor; if that answered your question please close the question. Thank you.

Author Closing Comment

by:vcharles

ID: 418257382016-10-02

Thank Yoi.

LVL 63

Expert Comment

by:Fernando Soto

ID: 418257932016-10-02

Not a problem Victor.

Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Key concepts of Delegate using C#

Article by: ROMA

It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…

How to apply a dynamic background via Active Directory GPP

Article by: Shaun

This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display

[Webinar] Learn How to Simplify Your Server Management

Video by: Experts Exchange

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…

How to access multiple mailboxes from one account in MS Exchange Server 2010 - video tutorial

Video by: Adam

There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…