Problem with the text

hi,
saving innerhtml column long text data type in access, using these

                cmd = new oledbcommand("update dbo.ite_tab set lng_txt=@txt ite_abbr=@ite_id ", conn);                  cmd.parameters.add("@txt", oledbtype.varchar).value = ta1.innerhtml;                 cmd.parameters.add("@ite_id", oledbtype.varchar).value = lb_var1.text;                 cmd.executenonquery();                 ...

seems there problem see nothing in column of table after i've saved text without getting errors. similar codes work against sql server.

---

many & best regards, hua min

hi huamin,

if you, firstly exact sql statement debugging code, , run sql statement in access check if there're errors.

my guess 'ta1.innerhtml' contains unusual characters, or longer maximum length of column. probability table read-only.

and here's article talking when access queries won't update:

when access queries won't update

---

we trying better understand customer views on social support experience, participation in interview project appreciated if have time. helping make community forums great place.
click here participate survey.

Visual Studio Languages  ,  .NET Framework  >  Visual C#