hi troll I have another question, however it is not related to this. Hope you can give me your professional advice. I have a C# dll, I want to call it from a C++ program. How do I import this dll into the C++. thank you :)

ok! thank you :)

yup. thank you very much! however just want to check with you the "adapter.update()" how does it work? does it require any commands? or it is smart enough to act accordingly? thank you!:)

hi thank you for reply! below is my code: string SelectSchema = "SELECT * FROM [Package Data Range]"; DataSet ds = new DataSet(); OleDbDataAdapter adapterPkInfo = new OleDbDataAdapter(SelectSchema, ImportCon); OleDbCommandBuilder cmdBldr = new OleDbCommandBuilder(adapterPkInfo); adapterPkInfo.FillSchema(ds, SchemaType.Source, "PackageDataRangeSchema"); DataSet ds2 = new DataSet(); string selectPkInfo = "SELECT * FROM [Package Data Range]"; OleDbDataAdapter adapter = new OleDbDataAdapter(selectPkInfo, connection); adapter.Fill(ds2, "Package Data Range"); ds.Tables[0].Merge(ds2.Tables[0],true,MissingSchemaAction.Ignore); my dataet has around 200 columns. it is not efficient to repeat that.... thank you :) zheng

hi troll i need your help again. how do i insert the dataset into the database. here is my code: string SelectSchema = "SELECT * FROM [Package Data Range]"; DataSet ds = new DataSet(); OleDbDataAdapter adapterPkInfo = new OleDbDataAdapter(SelectSchema, ImportCon); adapterPkInfo.FillSchema(ds, SchemaType.Source, "PackageDataRangeSchema"); DataSet ds2 = new DataSet(); string selectPkInfo = "SELECT * FROM [Package Data Range]"; OleDbDataAdapter adapter = new OleDbDataAdapter(selectPkInfo, connection); adapter.Fill(ds2, "Package Data Range"); ds.Tables[0].Merge(ds2.Tables[0],true,MissingSchemaAction.Ignore); i would like to insert the dataset ds into the database. thank you zheng

Hi everyone How to insert the records in the dataset into the database. i tried the adapter.update(ds). but it does not work... thank you for reading zheng

hi troll thank you for your help... i managed to do it! thank you! zheng

hi troll thank you for replying:) i would like to copy values of a column in the dataset to another column in another dataset. the condition is: if the both column name is the same. thank you!

Hi all how to transfer values from one datatable to another datatable. For example there are 2 datatables Table A and Table B. If then column name in Table A is the same as Table B then all the values of that column will go into Table B of the same column name. Hope you understand me. Thank you zheng

hi troll how to transfer values from one datatable to another datatable. For example there are 2 datatables Table A and Table B. If then column name in Table A is the same as Table B then all the values of that column will go into Table B of the same column name. Hope you understand me. Thank you zheng

Hi everyone How i get datatype and dataset and convert it into oledbdatatype. Thanks for reading :)

Hi Troll Thank you! i manage to do it! however i need to check for duplication of records. I have a dataset to insert into the database. How do i check for duplicate records. let say if the record has existed in the database then it will not be inserted. Thanks for reading! zheng

Hi Troll Thank you for replying. I have a datset filled with a table, and i need to export this table as a new access database.

Hi everyone! How to save a dataset as a new .mdb file. Thank you!