Display Multiple Rows in TextBox

[obrienkev]

Hi all,

How do I display multiple database rows in the one textBox?

The textBox is bound to the Database table and should display 3 database values.

However it displays only one.

How do I join table rows??

e.g. My table has 3 rows with same ID and want them all displayed in textBox...

myField ID
----------------- ---------------
itemA 2
itemB 2
itemC 2

thanks.

[blackjack2150]

Hi all,

How do I display multiple database rows in the one textBox?

The textBox is bound to the Database table and should display 3 database values.

However it displays only one.

How do I join table rows??

e.g. My table has 3 rows with same ID and want them all displayed in textBox...

myField ID
----------------- ---------------
itemA 2
itemB 2
itemC 2

thanks.

Set the "Multiline" property of the TextBox to true. Then you can display whatever you want.
Or you could use a RichTextBox instead.

[obrienkev]

Tried "Multiline" but no difference.

The textBox is bound to a dataset but only one row is displayed in it.

[blackjack2150]

Tried "Multiline" but no difference.

The textBox is bound to a dataset but only one row is displayed in it.

Hmmm, never used a TextBox in that way. Have you tried to see how the RichTextBox behaves?

[iteamweb]

Hmmm, never used a TextBox in that way. Have you tried to see how the RichTextBox behaves?

hi ,
please try to set the textmode is "multiline" for corresponding textbox its working.

Thanks,
http://www.tryangled.com
http://www.tryangled.net
http://iteamweb.com

[Plater]

I am not sure you can use a texbox in that mannor, it's possible, but seems counter-intuitive. You have uniquely seperated lines that you just want to jumble into a big textbox
If you just wish to display the data, a ListBox might be a better fit.
Or you could make a middleman function in between what your database returns and what your textbox gets bound to. That function would read in all the data from the database and mush it into the textbox.

[Frinavale]

Tried "Multiline" but no difference.

The textBox is bound to a dataset but only one row is displayed in it.

Is the problem that the data from the database is being displayed:
"itemA 2 itemB 2 itemC 2"

Or is it that you're only displaying:
"itemA 2"

You may have to put "new lines" in after each row retrieved from the database?
How are you filling the textbox?

[obrienkev]

Is the problem that the data from the database is being displayed:
"itemA 2 itemB 2 itemC 2"

Or is it that you're only displaying:
"itemA 2"

You may have to put "new lines" in after each row retrieved from the database?
How are you filling the textbox?

it's only displaying "itemA"

I want it to display itemA,itemB,itemC
Do I have to use a loop for this??

TextBox is bound to a dataset.
Using Visual Studio 2005. DataBindings Text Property set as... fundsAffectedEditBindingSource - myFunds

[Vidhura]

Suggestion:
Instead you could do the concatenation in db itself as follows



declare @abbr varchar(1000)

select @abbr=COALESCE(@abbr+ ',', '')+Col1 from Table where ID=@ID
select @abbr

it's only displaying "itemA"

I want it to display itemA,itemB,itemC
Do I have to use a loop for this??

TextBox is bound to a dataset.
Using Visual Studio 2005. DataBindings Text Property set as... fundsAffectedEditBindingSource - myFunds

[Frinavale]

it's only displaying "itemA"

I want it to display itemA,itemB,itemC
Do I have to use a loop for this??

TextBox is bound to a dataset.
Using Visual Studio 2005. DataBindings Text Property set as... fundsAffectedEditBindingSource - myFunds

Check out this .NET article on how to use a database in your program. Try using the examples in your program...especially look at the section on "Executing Your SQL Commands". The only change you'll have to make is to add a loop that looks like:

While myDataReader.Read
          TextBox1.Text = TextBox1.Text + " " + CType( dr.Item("FieldName"), String)
End While
 

Hope this helps you!

-Frinny

[Adanik]

Select list box instead of text box and choose property called row sources and choose what ever table field you like it will allow you to display multiple values from same field