Retrieve data from database to multiple textbox

Question

When I retrieve data from my Access database to a multiline TextBox, it shows all my data in the same line. In the DataGridView everything is fine and shows line by line. How to make my textboxes to show data line by line as well?

con.Open();
OleDbCommand cmd = new OleDbCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select * from data where [ID] like(" + textBox9.Text + ")";
cmd.Connection = con;
var reader = cmd.ExecuteReader();

while (reader.Read())
{
    textBox1.Text = reader["Target Name"].ToString();
}

you can separate lines by adding "\r\n" or Environment.NewLine. On a side note, you must have a look to Parameterized Query — kashi_rock
– kashi_rock, Commented Nov 7, 2016 at 8:24

Vivek Nuna · Accepted Answer · 2023-01-13 06:10:15Z

1

textBox1.Multiline = true;

textBox1.Text += reader["Target Name"].ToString() + Environment.NewLine;

Set MultiLine property to true and a new line while setting textBox1.Text by adding Environment.NewLine at the end.

Please don't use SELECT *, you can use SELECT Col1, Col2...

Also please use parameterized queries to avoid SQL injection.

Please us using with the SQL connection

edited Jan 13, 2023 at 6:10

answered Nov 7, 2016 at 8:27

Vivek Nuna

30.6k34 gold badges162 silver badges259 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

baban jamal Over a year ago

its same bro same error show data all in one line ex 07701442233 07705552233

baban jamal Over a year ago

all my data is string

D Ie · Accepted Answer · 2016-11-08 11:58:48Z

0

This should give the TextBox a Grid/Table appearance:

while (reader.Read())
{
    textBox1.Text = reader.getString(0)+"\t"+reader.getString(1)+"\r\n"; //in the case the table 'data' has 2 columns
}

answered Nov 8, 2016 at 11:58

D Ie

8417 silver badges23 bronze badges

Collectives™ on Stack Overflow

Retrieve data from database to multiple textbox

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related