Issue with UPDATE function in DataAdapter

  • Thread starter Thread starter Lubo¹ ©lapák
  • Start date Start date
L

Lubo¹ ©lapák

Hi,
I save multiline value in Column "Address" in Table in DataSet , but after
UPDATE (save new row on SQL Server) is saved only first line from all lines
in "Address" column. I have also second Column "Notes" where are saving also
multiline values, but there is no problem with saving. All is same like
Column "Address".

Do you have any ideas?

Thanks Lubos
 
Check the datatypes of your Address column on Sql Server Table, make sure it
is the same as you have for Notes Column. Also, do not add/ insert/ update
records in your underlying database by just Insert or Update command,
instead use Parameters to insert or Update.

Good Luck !!!
 
I use Parameters in Insert command and also Address column is datatype TEXT.
I don't know where is mistake.
 
I use Parameters in Insert command and also Address column is datatype TEXT.
I don't know where is mistake.
 
Back
Top