How to convert data table row to string

Question

0.00/5 (No votes)

See more:

<pre> Dim a As New ClsKoneksi
        Dim query As String
        query = "SELECT KodeBarang FROM Barang"
        dt = a.executequerydata(query)
        Dim names As New List(Of String)
            For i = 0 To dt.Rows.Count() - 1
                Dim brngname As String = Convert.ToString(dt.Rows(i))
                names.Add(brngname)
            Next
            For i = 0 To names.Count() - 1
                BARANGLIST.Items.Add(names(i).ToString)
            Next

try to insert value from data table row to wpf combobox and

What I have tried:

i try to convert row in datatable to string but it produced "System.data.datarow" in brngname variable. how can i convert row in data table to string?

Posted 5-Oct-18 2:25am

Member 13671577

Updated 5-Oct-18 2:44am

Add a Solution

Comments

MadMyche 5-Oct-18 10:13am

Your SQL query is only returning the KodeBarang column from the database table. Did you want other columns returned; such as HargaBarang?

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard MacCutchan · Answer 1 · 2018-10-05T02:40:00

Solution 1

You cannot convert a row into a string like that, a Row is a collection of cells not a single entity. You must take the values of all the cells you want in the string, and concatenate them (use a StringBuilder).

Posted 5-Oct-18 2:40am

Richard MacCutchan

Comments

MadMyche 5-Oct-18 10:07am

I'm not a VB person, but the SQL query looks like he is only returning one column from the table; there wouldn't be anything to concatenate at the row level.

Richard MacCutchan 5-Oct-18 12:36pm

It doesn't matter, a row is still a list, albeit with only one item. So he still needs to collect the cell entries one at a time. Saying row(i).ToString() will only ever give you the class of a Datatable row.

OriginalGriff · Answer 2 · 2018-10-05T02:44:00

The string version of a DataRow is "System.Data.DataRow", because the system has no idea what the DataRow may contain, what part(s) of it you might want to display, or how you want them formatted.

If all you want is the row content as a concatenated string, then loop through the Row.Cells collection, and convert the content to individual strings, using a StringBuilder to "join" them together.

If you want to be cleverer, then use the DataTable as a DataSource for the ComboBox, and set the DisplayMember property to show only the column you are interested in: Step by Step WPF Data Binding with Comboboxes[^]