mysql - Duplicating values in Datagridview -


i inserting values mysqldb via selected row. inserting mysqldb successful

problem: when load values ive inserted in mysqldb datagridview, values duplicating 9x. when check in mysql db not duplicate.

     dim mysqlconn3 new mysqlconnection     mysqlconn3.connectionstring = "server=localhost;userid=root;password=gaezlevister214;database=librarydb;"     dim command3 new mysqlcommand     dim sda3 new mysqldataadapter     dim bsource3 new bindingsource     dim dbdataset3 new datatable     try         mysqlconn3.open()         dim query3 string         query3 = "select blist.quantity 'qty', returnedlist.student_id 'student id', returnedlist.call_number 'call_number',returnedlist.date_added 'date borrowed',returnedlist.due_date 'due date' librarydb.returnedlist, librarydb.blist"         command3 = new mysqlcommand(query3, mysqlconn3)         sda3.selectcommand = command3         sda3.fill(dbdataset3)         bsource3.datasource = dbdataset3         me.datagridview1.datasource = bsource3         sda3.update(dbdataset3)      catch ex mysqlexception         messagebox.show(ex.message)              mysqlconn3.close()     end try 


Comments

Popular posts from this blog

sublimetext3 - what keyboard shortcut is to comment/uncomment for this script tag in sublime -

java - No use of nillable="0" in SOAP Webservice -

ubuntu - Laravel 5.2 quickstart guide gives Not Found Error -