c# - How to Refresh dropdown on button click on another form -

i have winform winform1 has combobox. binding combobox on form_load event this

sqlcommand cmd = new sqlcommand("select distinct(txt_target_number) tbl_cdr_analyzer", sqlcon); cbotargetno.properties.items.clear(); cbotargetno.properties.items.add("choose target number"); sqlcon.open(); sqldatareader dr = cmd.executereader(); while (dr.read()) {     cbotargetno.properties.items.add(dr["txt_target_number"]); } sqlcon.close(); cbotargetno.selectedindex = 0; 

now form contains button btn1. on click event of button opening new winform winform2 using showdialog() function.

on winform2 have button btn2 insert values in sql. want after values insert in sql, combobox on winform1 should refresh. how can this. clueless start this.

simplist way to extract code combobox update method, call form_load event, later since using form.showdialog, can call method again latest record database , bind combobbox again. like:

winform2 frm2 = new winform2(); frm2.showdialog(); refreshcombo(); 

where refreshcombo method :

private void refreshcombo() {  sqlcommand cmd = new sqlcommand("select distinct(txt_target_number) tbl_cdr_analyzer", sqlcon); cbotargetno.properties.items.clear(); cbotargetno.properties.items.add("choose target number"); sqlcon.open(); sqldatareader dr = cmd.executereader(); while (dr.read()) {     cbotargetno.properties.items.add(dr["txt_target_number"]); } sqlcon.close(); cbotargetno.selectedindex = 0; }