Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 216
  • Last Modified:

Help with displaying data from data table to multiple controls

Hi,

How do I modify the code below to display data from dtFTL.Rows(0) to two Textbox controls.

For example, If I have the following text in dtFTL.Rows(0).

+589  This temperatue

I would like to display the first 4 charcaters (+589) to C1FTLA and the remaining text to C1FTLB.


For Each xnFTL As Xml.XmlNode In xdFTL.SelectNodes("/Root/FTLTable[FTL_ID='" & FTLID & "']")
                    FTLID2 = xnFTL.SelectSingleNode("FTL_ID").InnerText
                    Name = xnFTL.SelectSingleNode("FTL").InnerText
                    dtFTL.Rows.Add({FTLID2, Name})
                Next

C1FTL.Text = dtFTL.Rows(0).Item("FTL")



Thanks.
Victor
0
vcharles
Asked:
vcharles
  • 2
  • 2
1 Solution
 
Fernando SotoRetiredCommented:
If it will always be the first 4 characters of that string then this should do what you need.

C1FTLA.Text = dtFTL.Rows(0).Item("FTL").SubString(0, 4)
C1FTLB.Text = dtFTL.Rows(0).Item("FTL").SubString(5)

Open in new window

0
 
vcharlesAuthor Commented:
Thank You, will try it and get back to you,
0
 
vcharlesAuthor Commented:
Thank You!
0
 
Fernando SotoRetiredCommented:
Not a problem, glad to help.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now