not able to display SQL data in newline into multiline textbox using C#

Question

I have following code in c# for retrieving data and displaying the content into multiline textbox. The content is getting displayed but iam unable to show it in new line on different timestamps. I want 1:10 on first line, followed by 1:11 on next line and so on.

LOG_DETAILS column has value like:
'1:10 Database connection to log db was successfully made by user1. 1:11 address error - the address column contains invalid special character therefore webservice call wont be made. 1:12 user1 attempted to change the address and did not save changes'

Iam using .Net 1.1 Framework

SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
//Assign to your textbox here
TextBoxLogInfo.Text = sdr["LOG_DETAILS"].ToString();
}

Please help to display such content in new lines in multiline text box.

Your help appreciated

Harish

Vulpes · Answer

You could use a regular expression for this: using System.Text.RegularExpressions; //.... SqlDataReader sdr = cmd.ExecuteReader(); while (sdr.Read()) { string regExp = @(?=\d+:\d+); string[] split = Regex.Split(sdr[LOG_DETAILS].ToString() regExp); TextBoxLogInfo.Lines = split; } If you don't want the first line to be blank then you can trim it off by adding this line: TextBoxLogInfo.Text = TextBoxLogInfo.Text.TrimStart('' '
');

Sam Hobbs · Answer

Thank you for reporting back. What do you mean by newline? If you mean 
 then I said that. If you mean something else then newline is ambiguous.

harish main · Answer

newline works fine in textarea. Thanks for everyone's help.

Suthish Nair · Answer

thread got resolved? both will work.. s = String.Format(s.Replace(.  .
)); s = String.Format(s.Replace(.  .
)); Hope you have set TextMode=MultiLine If the query got already resolved then mark the post that helped you as Answer so will be helpful for others. Otherwise if you got the solution please share with us.

Raja Krishnamurthy · Answer

@Sam - oops! You are absolutely right Sam...I have edited my response

harish main · Answer

Thanks for reply. I tried removing @ it is still same. DO i need to write a split logic that splits the timestamp with ':' delimeter to newline?

Sam Hobbs · Answer

First I suggest using 
 instread of 
. It probably does notmake a difference but 
 is what Windows uses for a newline. Just a 
 is the Unix/Linux way which is inconsistent with the original use of the control codes. The important thing is to remove the @. Raja seems to be in the habit of using @ and was in too much of a hurry and did not realize that the @ would be a problem. I am totally confident that Raja knows this; Raja just was in a hurry. I am confident that Raja's code will work. Or maybe Raja was just testing you; do you understand what the @ does?

harish main · Answer

Thanks for your response Raja. Raja my query will retrieve only single record as iam giving some Key search which will retrieve one particular log details record. I tried as per your suggestion i still get the LogDetails as continous string in TextBox which is same like i was doing with old way i had. Right now in SQL database the data is stored as varchar. Please help to get the SQL content to be displayed in Textbox as shown below in the multilineTextBox 1:10 Database connection to log db was successfully made by user1. 1:11 address error - the address column contains invalid special character therefore webservice call wont be made. 1:12 user1 attempted to change the address and did not save changes' Thanks Harish

Raja Krishnamurthy · Answer

First of all your logic would set the textbox with the last information read from the Sql Data Reader. Please try changing it like this: StringBuilder objBuilder = new StringBuilder(); //add using System.Text; while(sdr.Read()) { objBuilder.Append(sdr[LOG_DETAILS].ToString()); } //Now that you got all the string appended //Add it to the textbox TextBoxLogInfo.Text = objBuilder.ToString().Replace(..
); //replacing the period with a period and a return and newline HTH. Happy Programming!!! Regards Raja Edit: edited my code per Sam's(thanks man) comments