Hello. I'm doing project using richtextbox and want to save the contents in Access. But my contents is a list and when I saved it, the list become one line, with a square to space it. Can it actually be done? I set the column with memo type. Here's my code for save it.
sql = "SELECT * FROM RichText" da = New OleDb.OleDbDataAdapter(sql, con) da.Fill(ds, "RichText") Dim cb As New OleDb.OleDbCommandBuilder(da) Dim dsnewrow As DataRow dsnewrow = ds.Tables("RichText").NewRow() dsnewrow.Item("MyOrder") = RichTextBox1.Text ds.Tables("RichText").Rows.Add(dsnewrow) da.Update(ds, "RichText")
If it can't be done, is there another way? Thank you.