Hello,
I have two tables, one empty and one is an existed table. I use Varchar for all columns in the temporary table, and the existed table has all types of datatype including text and image.
I tried to insert the data from the existed table to the temporary table, and
I manage to convert the datatype from varchar to System.String and System.Byte[].
But I need the temporary table to be in its original state on form_load. But the reverse process doesn't work. ("cannot alter column because it is a text")
When I tried to drop the table, in VB.net, this error comes out."ExecuteNonQuery:connection property has not been initialized"
when i remove the drop command, and insert another statement, it works just fine..
help... thanx