Hey,

is it possible to add multiple entries from a table into one text box, like joining them.

so i can have something like

txtAddress.DataBindings.Add("text", ds, "Customers.CustomerAddress")
txtAddress.DataBindings.Add("text", ds, "Customers.CustomerPostcode")

in the same text box, with a space in between?

Not that I am aware of.

If you are using a SQL statement or stored procedure, you could do the appending there and use an alias to return it as a single field.

Hope this helps.

---

www.insteptech.com ; msmvps.com/blogs/deborahk
We are volunteers and ask only that if we are able to help you, that you mark our reply as your answer. THANKS!

Not that I am aware of.

If you are using a SQL statement or stored procedure, you could do the appending there and use an alias to return it as a single field.

Hope this helps.

---

www.insteptech.com ; msmvps.com/blogs/deborahk
We are volunteers and ask only that if we are able to help you, that you mark our reply as your answer. THANKS!

You can bind it to one of the columns and setup a format event where you get the other columns and add their values and if necessary also a parse event where you split the text and put it back into the correct columns.

--
Wolfgang

Hi kidwizz,

Simple binding doesn't support to bind the same property twice. You will meet error like that, "This causes two bindings in the collection to bind to the same property."

I think DeborahK's suggestion is correct, you can do the combination in the stored procedure. Then bind it with TextBox control's Text property.

If you have anything unclear, please feel free to tell me.

Sincerely,
Kira Qian

---

Please mark the replies as answers if they help and unmark if they don't.