Change DataType

Question

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