Is it possible to change data type of column

Question

Is it possible to change data type of column  retrieved from one table which is in varchar to an integer while inserting to another table.

 

My situation is I retrieved records from a database table and store in a dataset.

 

From this dataset i need to insert this records to another database.

 

So while i do insert operation, can i cange the datatype so that it could match the data type define in my second table?