Tom's Guide | Tom's Hardware | Tom's Games
![]() |
![]() |
![]() |
Hi!
on my web form I'm using a multiline text box. My problem is that when i save this data in a memo field (MS-Access) it stores only first word of first line, following is the code lines:
SQL = "Insert into mProductDetails(Features)Values(?)"
iSQL = New OleDb.OleDbCommand(SQL, MyConnection)
iSQL.Parameters.Add(New OleDb.OleDbParameter("@Feat", OleDb.OleDbType.VarChar))SQL.Parameters("@Feat").Value=txtFeatures.Text
iSQL.ExecuteNonQuery()
Above code runs fine, the only problem is that it stores only first word of the first line, i want to store the entire contents of the multiline text box including Carrage Returns.
Kindly help
Regards
Rajeev

Because you mention carriage returns I am assuming that you mean a text area. There is no such thing as a multi-line text box.
I think the problem might be in the database. What type of field is the fetures colum in the database? Does it accept carriage returns?
Michael J

Hi Michael!
Itz working fine :) actually in my access database table, i did not scroll down the field, when i did so it showed me the everything.Thanx for the reply
regards
rajiv

![]() |
Printing webpage without ...
|
html help!!
|

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.
| Ads by Google |