Validating Data using Typed Dataset

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,
BarenEhm, 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/
"Baren" <Baren@.discussions.microsoft.com> wrote in message
news:B6AA8F52-4042-4030-995D-FD726B07CBD4@.microsoft.com...
> 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
Well Flat file means a text file or a CSV file
"Miha Markic [MVP C#]" wrote:
> 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/
> "Baren" <Baren@.discussions.microsoft.com> wrote in message
> news:B6AA8F52-4042-4030-995D-FD726B07CBD4@.microsoft.com...
> > 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
>
>
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/
"Baren" <Baren@.discussions.microsoft.com> wrote in message
news:1EDF5F0E-3B3E-41C2-9360-034F89324DFA@.microsoft.com...
> Well Flat file means a text file or a CSV file
> "Miha Markic [MVP C#]" wrote:
>> 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/
>> "Baren" <Baren@.discussions.microsoft.com> wrote in message
>> news:B6AA8F52-4042-4030-995D-FD726B07CBD4@.microsoft.com...
>> > 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
>>