Validation of Data before uploading of excel to sql db

Discussion in 'ASP General' started by anilgiri2010a, Jan 25, 2012.

  1. anilgiri2010a

    anilgiri2010a

    Joined:
    Jan 19, 2012
    Messages:
    3
    Likes Received:
    0
    Location:
    pune
    I want to upload excel data to sql db using SQLBulkcopy?But, I want to perform some validation checks on data.How can I check datatype of a cell as integer.If not then how to show it Error Report.
     
    anilgiri2010a, Jan 25, 2012
    #1
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.