M
Mr. x
Hello,
I am using dotnet with access.
I am using memo field.
How can I insert a memo field.
I have tried something like this :
sql = 'Insert into myTable( ... , mymemo)
values (... , ?)
....
dim cmd = new OleDBCommand(sql, conn) ' connection is previously assigned to
the access *.mdb file.
....
dim currParam = new oleDbParameter("@mymemo", OleDbType.VarChar)
currParam = i_area.value
....
cmd.ExecuteNonQuery()
...
<html>
....
<table ...>
.....
<td width = 100%><textArea rows = "10" id = "i_area" style="width:
100%"
runat="server"></textArea></td>
....
</table>
My example doesn't work, and I get the exception :
System.FormatException: Input string was not in a correct format.
How should I get things work ?
Thanks
I am using dotnet with access.
I am using memo field.
How can I insert a memo field.
I have tried something like this :
sql = 'Insert into myTable( ... , mymemo)
values (... , ?)
....
dim cmd = new OleDBCommand(sql, conn) ' connection is previously assigned to
the access *.mdb file.
....
dim currParam = new oleDbParameter("@mymemo", OleDbType.VarChar)
currParam = i_area.value
....
cmd.ExecuteNonQuery()
...
<html>
....
<table ...>
.....
<td width = 100%><textArea rows = "10" id = "i_area" style="width:
100%"
runat="server"></textArea></td>
....
</table>
My example doesn't work, and I get the exception :
System.FormatException: Input string was not in a correct format.
How should I get things work ?
Thanks