Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: Oracle VB.NET
I have 2 tables color_picker & rcsa_scale. I want to set the color textbox to color_rgb.
how can i use span tag in select query?
 oDS = oDM.getDataset("SELECT  " _
                                               & "    MRE.SCALE_ANSWER,   " _
                                               & "    MRE.MIN,  " _
                                               & "    MRE.MAX,  " _
                                               & "    Mcp.color_rgb , " _
                                               & "    MRE.Color_rgb , " _
                                               & "    Mre.Weightage , " _
                                               & "    MRE.DESCRIPTION1 ,  " _
                                               & "    MRE.DESCRIPTION2   " _
                                               & "    from trn_rcsa_scale MRE , mst_Color_picker mcp" _
                                               & "    where mre.Color_rgb = mcp.id and MRE.MST_SCALE_CONFIG_ID = " & intEditID & "  order by MRE.id ")
 
            '<span style="background-color:mcp.color_rgb">
'</span>'
            dt.Columns.Add("Weight")
            dt.Columns.Add("Answer")
            dt.Columns.Add("MIN")
            dt.Columns.Add("MAX")
            dt.Columns.Add("COL")
            dt.Columns.Add("DES1")
            dt.Columns.Add("DES2")
Posted 29-Apr-13 1:33am
Edited 29-Apr-13 3:29am
v2

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

You cannot. It looks like you don't understand separation of concerns and isolation between different layers. With query, you obtain some data and nothing else. Then you use this data to populate UI.
 
Please see: http://en.wikipedia.org/wiki/Separation_of_concerns[^].
 
I suggest you study the following architectural patterns (http://en.wikipedia.org/wiki/Architectural_pattern_(computer_science)[^]), to get some ideas:
 

MVVM — Model View View Model,
http://en.wikipedia.org/wiki/Model_View_ViewModel[^],
 
MVC — Model-View-Controller,
http://en.wikipedia.org/wiki/Model-view-controller[^]),
 
MVA — Model-View-Adapter,
http://en.wikipedia.org/wiki/Model–view–adapter[^],
 
MVP — Model-View-Presenter,
http://en.wikipedia.org/wiki/Model-view-presenter[^].

 
—SA
  Permalink  

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

  Print Answers RSS
0 OriginalGriff 277
1 Maciej Los 210
2 BillWoodruff 205
3 Jochen Arndt 180
4 DamithSL 165
0 OriginalGriff 5,130
1 DamithSL 4,157
2 Maciej Los 3,670
3 Kornfeld Eliyahu Peter 3,470
4 Sergey Alexandrovich Kryukov 2,821


Advertise | Privacy | Mobile
Web01 | 2.8.141216.1 | Last Updated 29 Apr 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100