Issue with UPDATE function in DataAdapter

[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

[Lord2702]

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 !!!

"Lubo¹ ©lapák" <lu**********@centrum.cz> wrote in message
news:eV**************@TK2MSFTNGP10.phx.gbl...

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

[Lubo¹ ©lapák]

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

"Lord2702" <Lo******@MSN.com> pí¹e v diskusním pøíspìvku
news:%2****************@TK2MSFTNGP15.phx.gbl...

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 !!!

"Lubo¹ ©lapák" <lu**********@centrum.cz> wrote in message
news:eV**************@TK2MSFTNGP10.phx.gbl...

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

[Lubo¹ ©lapák]

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

"Lord2702" <Lo******@MSN.com> pí¹e v diskusním pøíspìvku
news:%2****************@TK2MSFTNGP15.phx.gbl...

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 !!!

"Lubo¹ ©lapák" <lu**********@centrum.cz> wrote in message
news:eV**************@TK2MSFTNGP10.phx.gbl...

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