471,594 Members | 2,068 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,594 software developers and data experts.

CSV validation by loading into a typed-dataset

I have a CSV file which contains comma seperated data that I need to
validate against our database.I was thinking about loading that CSV file
into a Typed-Dataset which has our database schema in it and then try to
load the CSV file into that Typed-Dataset and automatically get all the
errors and constarint violations.

1) Is it doable?

2) Because I need to check the foriegn keys as well,Can I loaded the data of
those refferecing tables into my dataset as well?

3)If number 2 is doable ,how should I update my dataset if a key has been
added to the existing refferncing tables?
Thanks a lot for taking your time answering this post in advance.


Nov 12 '05 #1
0 1158

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Yama | last post: by
4 posts views Thread by AIM48 | last post: by
12 posts views Thread by Dabbler | last post: by
27 posts views Thread by Chris | last post: by
11 posts views Thread by Rik | last post: by
1 post views Thread by Sergei Riaguzov | last post: by
reply views Thread by XIAOLAOHU | last post: by
reply views Thread by Anwar ali | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.