Efficient way to validate data of DataTable

Question

I have following DataTable (dataTable)

**ColumnName** : **Data**

IDS : System.String

QTY : System.Int32

DOS System.DateTime

and following dictionary

Dictionary<string,Type> dict=new Dictionary<string, Type>();

dict["ID"]=typeof(string);

dict["QTY"]=typeof(Int32);

dict["DOS"]=typeof(DateTime);

Using following method for validating data of dataTable

public void ValidateData(Dictionary<string, Type> dict, DataTable dataTable)

{

foreach (DataRow row in dataTable.Rows)

{

// validate data here

}

What is best/efficient way to validate data here.

Thanks.

Vulpes · Answer

What do you mean by validating the data? If you mean that the 3 columns in each row of the datatable should have the same values as the dictionary then try this: public bool ValidateData(Dictionary dict DataTable dataTable) { foreach (DataRow row in dataTable.Rows) { if (row[IDS].ToString() != dict[IDS].ToString()) return false; if (row[QTY].ToString() != dict[QTY].ToString()) return false; if (row[DOS].ToString() != dict[DOS].ToString()) return false; } return true; }