Validating Data using Typed Dataset

[Guest]

Hi! All,

How can i validate data filling into a typed dataset?
e.g. Say I am importing data from a flat file into a typed dataset. I want
to validate that each data entering into the dataset are in match with the
dataset Schema and if any error i want to log the same row and move to
execute the next row.

How do I do this??

Regards,
Baren

 

[Miha Markic [MVP C#]]

Ehm, what do you mean by flat file?

 

[Guest]

Well Flat file means a text file or a CSV file

Ehm, what do you mean by flat file?

--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

Hi! All,

How can i validate data filling into a typed dataset?
e.g. Say I am importing data from a flat file into a typed dataset. I want
to validate that each data entering into the dataset are in match with the
dataset Schema and if any error i want to log the same row and move to
execute the next row.

How do I do this??

Regards,
Baren

 

[Miha Markic [MVP C#]]

Hi,

Then you are on your own. You'll have to do all the job by yourself.
Or you could use Excel OleDb thing to import flat files into a DataTable and
later do the merge.

--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

Well Flat file means a text file or a CSV file

Ehm, what do you mean by flat file?

--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

Hi! All,

How can i validate data filling into a typed dataset?
e.g. Say I am importing data from a flat file into a typed dataset. I
want
to validate that each data entering into the dataset are in match with
the
dataset Schema and if any error i want to log the same row and move to
execute the next row.

How do I do this??

Regards,
Baren