c# - Delete selected row in datagridview and also delete row in database -

i want delete selected row in datagridview , delete row in mysql.

private void deleteorderbutton_click(object sender, eventargs e) {     int selectedindex = orderdatagridview.currentcell.rowindex;      if (selectedindex > -1)     {         orderdatagridview.rows.removeat(selectedindex);         orderdatagridview.refresh();     }      string constring = "datasource=localhost;port=3306;username=admin;password=acw123";     string query = "delete database.tem_order temp_orderid = ????     mysqlconnection condatabase = new mysqlconnection(constring);     mysqlcommand cmddatabase = new mysqlcommand(query, condatabase);     mysqldatareader myreader;      condatabase.open();     myreader = cmddatabase.executereader();     messagebox.show("updated"); 

i stuck in mysql command there; help?

when using datasource on datagridview can retreive object of selected row.

datarow row = (datagridview.selectedrows[0].databounditem datarowview).row; 

the datarow 'row' should contain id allows delete record in mysql. replace "id-column-name" real column name

using(mysqlconnection sqlconn = new mysqlconnection("datasource=localhost;port=3306;username=admin;password=acw123")) {     sqlconn.open();      using(mysqlcommand sqlcommand = new mysqlcommand("delete tem_order temp_orderid = " + row["id-column-name"],sqlconn))     {          sqlcommand.executenonquery();     } }