Data from textbox into database and newlines

[Genbox]

Hi. I have a very simple news system, that takes some text from a multiline textbox and insert it into a access database. But when i save the data to the database, the newlines dont get saved with the data. How do i save the newlines with the data to the database, and then display it on my site. here is the code i use to insert into the database, it's just a sqldatasource. news.InsertCommand = "INSERT INTO [news] ([headline], [content], [date], [user]) VALUES ('"+ txtHeadline.Text +"','"+txtContent.Text+ "','"+DateTime.Now.ToString()+"','"+User.Identity.Name.ToString()+"')"; news.Insert();

[Genbox]

Hi. To get newlines in the displayet data on the site, I just replaced "newline" with
like this: txtContent.Text.Replace(Environment.NewLine, "
") -- modified at 6:35 Wednesday 29th March, 2006

[albCode]

In which column you have to save data with new lines? _____________________ Proud to be Albanian _____________________