datasets connect to text boxes

How would i connect i dataset to a text box

The dataset is like this

Blue1  hexvalue
Blue2  hexvalue


I want to select which color for the specific text box
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ValentinoVBI ConsultantCommented:
I'm not sure if I fully understand what you're asking.  I understand that you have a dataset which contains colors and you somehow want to use those colors in combination with a textbox.  Is it your aim to color the textbox using a color from the dataset?  How is the "color dataset" linked to your regular dataset?

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:


This assumes that TheHexValue contains "hexvalue" which you mentioned in your question.
vbnetcoderAuthor Commented:
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.
vbnetcoderAuthor Commented:
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?
ValentinoVBI ConsultantCommented:
In that case you can just use the expression which I mentioned at the end of my previous comment.  Put it in either the Color or BackgroundColor property of the textbox, depending on your preferences.  There's just one condition: the textbox needs to be linked to a dataset.  Easiest way is to put it in a Table.  Another option is the List.  Just put a List on your report and put a textbox in it with the expression set up as mentioned before.

You don't need two textboxes btw, just one is sufficient because the List will repeat it for each record in your dataset.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
vbnetcoderAuthor Commented:
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.