By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,479 Members | 988 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,479 IT Pros & Developers. It's quick & easy.


P: n/a

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

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

Nov 20 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.