c# - How can I insert a row from datagridview to Database -
is there way insert row datagridview database in winforms ?
this how create gridview:
this.datagridview1.allowusertoaddrows = true; this.datagridview1.allowusertodeleterows = true; var query = fe in tm.rdp0 select fe; testlist = query.tolist(); datagridview1.datasource = testlist.tolist();
this how add new row datagridview
rdp0 newrow = new rdp0(); newrow.no = 1 + datagridview1.rows.count; newrow.custid = 1000 + datagridview1.rows.count; testlist.add(newrow); datagridview1.datasource = null; datagridview1.datasource = testlist;
after filled newly created empty row on datagridview want insert database.
tm.savechanges();
because savechanges() -above- doesnt work.
any appreciated.
no more need help. found solution.
int index = datagridview1.rows.count; rdp0 newefes = new efesrdp0(); newefes.no = convert.toint32(datagridview1.currentrow.cells[0].value); newefes.custid = convert.toint32(datagridview1.currentrow.cells[1].value); newefes.ipaddress = convert.tostring(datagridview1.currentrow.cells[3].value); newefes.user = convert.tostring(datagridview1.currentrow.cells[4].value); db.rdp0s.insertonsubmit(newefes); db.submitchanges();
via linq sql method
Comments
Post a Comment