Hi

I have two questions.

First:

How can I compare the datatypes and column names from two datatables? One is filed from excel and the other one is from a database.

 Second:

How can I make a method that insert all the records from a datatable that cancel the inserted records as soon a value from a record is wrong for examle characters in an integer field. Or skip the record.

Thanks

Davidnyh

Hi Davidnyh,

How can I compare the datatypes and column names from two datatables? One is filed from excel and the other one is from a database.

You can get the name and type by the index of a certain column in this way - since you've got the two stings, you can compare them easily:

string name = ds.Tables[0].Columns[0].ColumnName;  // e.g. "col1"
string ty = ds.Tables[0].Columns[0].DataType.ToString(); // e.g. "System.Int32"

How can I make a method that insert all the records from a datatable that cancel the inserted records as soon a value from a record is wrong for examle characters in an integer field. Or skip the record.

Could you clarify it? I can't understand your meaning.

Thanks. 

Thanks for your answer.

 When I have an excel file with a column that needs to holds only integers but one row has a character the method need to have an option to skip this row and log the skipped row in a textbox after adding all to other corrected rows.

 Thanks.