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. General Programming
  3. Visual Basic
  4. How to insert multiple records from DataGridView into Mysql database table using VB.Net in Windows Applications

How to insert multiple records from DataGridView into Mysql database table using VB.Net in Windows Applications

Scheduled Pinned Locked Moved Visual Basic
2 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.
  • S Offline
    S Offline
    swaroop09
    wrote on last edited by
    #1

    Hi i am implementing VB.Net Windows Application. In that i have a datagridview. In that i displayed some records (let us say 10 rows with 12 columns, out of which 8 columns are datagridviewcheckbox columns.) from MySql database student table. The values in the datagrid for each row are like this: 1,joseph, 5thclass, B, true, false, true, true, etc depending on the selection. How to insert multiple records into a database table that are entered into a datagridview. With a single shot of Save all the records in the datagridview should be inserted in new table using Vb.Net . Can any one help me in this regard. Any help appreciated Thanks in advance...

    P 1 Reply Last reply
    0
    • S swaroop09

      Hi i am implementing VB.Net Windows Application. In that i have a datagridview. In that i displayed some records (let us say 10 rows with 12 columns, out of which 8 columns are datagridviewcheckbox columns.) from MySql database student table. The values in the datagrid for each row are like this: 1,joseph, 5thclass, B, true, false, true, true, etc depending on the selection. How to insert multiple records into a database table that are entered into a datagridview. With a single shot of Save all the records in the datagridview should be inserted in new table using Vb.Net . Can any one help me in this regard. Any help appreciated Thanks in advance...

      P Offline
      P Offline
      pdnet
      wrote on last edited by
      #2

      At first you declare a Datatable Then Innsert Your Data into that DataTable and at last Set DataGridView.dataSource=Datatable

      Arindam Banerjee Sr. Software Developer Rance Computer Pvt Ltd. Kolkata (India)

      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