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
Post a Comment