using Textbox to update DataGrid, while working with Databases

TAN WhoAMI

how can the textbox contents to be transferred identically to the DataGrid in the column?
My WPF textbox is Multiline, and users type its contents in the textbox continuously, and its contents would go to the next line after reaching end of the line in the textbox.

However, when it is saved to the Database, those contents from the textbox would just appear as a SINGLE LONG line in the DataGrid.

Any constructive comments are highly appreciated.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes14y ago
Accepted answer
I think that your problem here is that the text in the TextBox is simply being wrapped - there are no actual carriage return/line feed characters in there. Consequently, when the contents are saved to the database, they're saved as one long line.

What I'd therefore suggest you do is to insert some carriage return/line feeds at the end of each physical line in the textbox before saving the contents to the database.

The code to do that will be something like this:

string[] lines = new string[textBox1.LineCount];

for (int i = 0; i < lines.Length; i++)
{
lines[i] = textBox1.GetLineText(i);
}

string result = String.Join("\r\n", lines);
// code to save result to database
TAN WhoAMI14y ago
Bravo. thanks Vulpes again. It saves me weeks of trying. thanks.