如何通过选择查询设置文本框的背景颜色 [英] How to set Background color for textbox by select query

问题描述

我有2张表color_picker& rcsa_scale。我想将颜色文本框设置为color_rgb。

我如何在select查询中使用span标签？

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")

推荐答案

你不能。看起来你不了解不同层之间的关注点和隔离点。使用查询，您可以获得一些数据，而不是其他任然后使用此数据填充UI。



请参阅： http： //en.wikipedia.org/wiki/Separation_of_concerns [ ^ ]。



我建议您学习以下架构模式（ http://en.wikipedia.org/wiki/Architectural_pattern_(computer_science） [ ^ ]），以获得一些想法：

MVVM - 模型视图查看模型，

http://en.wikipedia.org/wiki/Model_View_ViewModel [< a href =http://en.wikipedia.org/wiki/Model_View_ViewModeltarget =_ blanktitle =New Window> ^ ]，



MVC - 模型 - 视图 - 控制器，

http://en.wikipedia.org/wiki/模型 - 视图 - 控制器 [ ^ ]），



MVA - 模型 - 视图 - 适配器，

http://en.wikipedia.org/wiki/Model-view-adapter [ ^ ]，



MVP - Model-View-Presenter，
http://en.wikipedia.org/wiki/Model-view-presenter [ ^ ]。

-SA

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

这篇关于如何通过选择查询设置文本框的背景颜色的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！