Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Web Development
  3. ASP.NET
  4. mass upload of data from excel to database

mass upload of data from excel to database

Scheduled Pinned Locked Moved ASP.NET
csharpdatabase
5 Posts 2 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • N Offline
    N Offline
    NRHSR
    wrote on last edited by
    #1

    i am working on mass upload of things from excel sheet to database.and i don't want to use file upload method and i have done mass upload of data from excel to gridview and i want to export this gridview data to database .... can any body post code for this ... i am using c#

    N N 2 Replies Last reply
    0
    • N NRHSR

      i am working on mass upload of things from excel sheet to database.and i don't want to use file upload method and i have done mass upload of data from excel to gridview and i want to export this gridview data to database .... can any body post code for this ... i am using c#

      N Offline
      N Offline
      N a v a n e e t h
      wrote on last edited by
      #2

      NRHSR wrote:

      i want to export this gridview data to database

      Loop through the records and insert each row to database. If there is going to be bulk records, you should send chunks of data to the procedure and avoid hitting DB each time in the loop. :)

      Navaneeth How to use google | Ask smart questions

      N 2 Replies Last reply
      0
      • N N a v a n e e t h

        NRHSR wrote:

        i want to export this gridview data to database

        Loop through the records and insert each row to database. If there is going to be bulk records, you should send chunks of data to the procedure and avoid hitting DB each time in the loop. :)

        Navaneeth How to use google | Ask smart questions

        N Offline
        N Offline
        NRHSR
        wrote on last edited by
        #3

        how to send chunks of data can you give the code please .... i am new to asp.net

        1 Reply Last reply
        0
        • N N a v a n e e t h

          NRHSR wrote:

          i want to export this gridview data to database

          Loop through the records and insert each row to database. If there is going to be bulk records, you should send chunks of data to the procedure and avoid hitting DB each time in the loop. :)

          Navaneeth How to use google | Ask smart questions

          N Offline
          N Offline
          NRHSR
          wrote on last edited by
          #4

          how to send bulk records plz..... help ...

          1 Reply Last reply
          0
          • N NRHSR

            i am working on mass upload of things from excel sheet to database.and i don't want to use file upload method and i have done mass upload of data from excel to gridview and i want to export this gridview data to database .... can any body post code for this ... i am using c#

            N Offline
            N Offline
            NRHSR
            wrote on last edited by
            #5

            can any one help ....

            1 Reply Last reply
            0
            Reply
            • Reply as topic
            Log in to reply
            • Oldest to Newest
            • Newest to Oldest
            • Most Votes


            • Login

            • Don't have an account? Register

            • Login or register to search.
            • First post
              Last post
            0
            • Categories
            • Recent
            • Tags
            • Popular
            • World
            • Users
            • Groups