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 Sergey Alexandrovich Kryukov 434
1 OriginalGriff 385
2 CHill60 230
3 CPallini 220
4 Abhinav S 200
0 Sascha Lefévre 75
1 OriginalGriff 70
2 F-ES Sitecore 55
3 Peter Leow 50
4 Dave Kreskowiak 40


Advertise | Privacy | Mobile
Web04 | 2.8.150327.1 | Last Updated 29 Apr 2013
Copyright © CodeProject, 1999-2015
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