vbnetcoder
asked on
datasets connect to text boxes
How would i connect i dataset to a text box
The dataset is like this
Blue1 hexvalue
Blue2 hexvalue
etc.
I want to select which color for the specific text box
The dataset is like this
Blue1 hexvalue
Blue2 hexvalue
etc.
I want to select which color for the specific text box
ASKER
In this case my color dataset is my complete dataset.
It is my aim to color the textbox using a color from my textbox. So, in the data example i gave i might select Blue1 for one textbox and Blue2 for another ...and so on. I want to be able to select the colors.
It is my aim to color the textbox using a color from my textbox. So, in the data example i gave i might select Blue1 for one textbox and Blue2 for another ...and so on. I want to be able to select the colors.
ASKER
So, imagine a 2 textboxes on a report. I want to attach to select blue1 for the first one and blue 2 for the second. How?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
TY
I'll try to clarify using an example. Let's say your report is displaying a product list and each product category has its own color. In that case I would combine the "color dataset" query with the regular dataset's query. This will make the field containing the color available for use within the tablix and you could use a simple expression to set the textbox color. This expression would go into the BackgroundColor property of the textbox:
=Fields!TheHexValue.Value
This assumes that TheHexValue contains "hexvalue" which you mentioned in your question.