Dataset to database problem

[kerek2]

Hi buddy's,

I need your guide regarding to pull data form other database to other database....I'm already pull the data into Dataset using this command :-

oracmd = New odbccommand ("Select id,name,dept from staff order by id",oracn)

da = ds.fill

then i need to insert to other database but it have different name of column that is : Staff_Id,Staff_name,Department....

How to map and pull the data?....thank a lot for u all.....

[vsa000]

create anther data set w/c will hold the updating stuff...

[kerek2]

Can u plz show me the example plz...i'm really2 stuck in here....