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

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. =?Utf-8?B?Z2F1cmF2?=

    Uploading Data From MS Acess 2000 ti SQL server 2000

    =?Utf-8?B?Z2F1cmF2?=, Jan 9, 2006, in forum: ASP .Net
    Replies:
    2
    Views:
    1,109
    Mary Chipman [MSFT]
    Jan 9, 2006
  2. ml
    Replies:
    0
    Views:
    512
  3. Arlyn
    Replies:
    1
    Views:
    2,459
    Steve C. Orr [MVP, MCSD]
    May 13, 2005
  4. =?Utf-8?B?TWFyayBNaWxsZXI=?=

    Can I execute a javascript action before uploading a file?

    =?Utf-8?B?TWFyayBNaWxsZXI=?=, Aug 20, 2005, in forum: ASP .Net
    Replies:
    4
    Views:
    1,670
    =?Utf-8?B?TWFyayBNaWxsZXI=?=
    Aug 23, 2005
  5. Dung Ping
    Replies:
    10
    Views:
    1,537
    Chaddy2222
    Jan 16, 2006
  6. Harry Zoroc
    Replies:
    1
    Views:
    1,232
    Gregory Vaughan
    Jul 12, 2004
  7. =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=

    Problem with Excel reports ::::Excel 2003 Migration To Excel 2007

    =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=, Oct 5, 2007, in forum: ASP .Net
    Replies:
    15
    Views:
    2,065
    =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=
    Oct 24, 2007
  8. Sam Dela Cruz
    Replies:
    0
    Views:
    156
    Sam Dela Cruz
    Jan 5, 2006
Loading...