c# - How to save the dynmaically created checkboxes selected values in DB -

c# - How to save the dynmaically created checkboxes selected values in DB -

i have matrix of checkboxes created dynamically 2 database tables(tblprivileges,tblviews) shown in image:

vertical records tblprivileges , horizontal 3 records tblviews. here code above matrix:

protected override void oninit(eventargs e) { int rowcnt; int rowctr; rowcnt = 1; con.connectionstring = configurationmanager.connectionstrings["con"].connectionstring; sqldataadapter adp1 = new sqldataadapter("select * tblviews", con); dataset ds1 = new dataset(); adp1.fill(ds1); datatable g = new datatable(); adp1.fill(g); (rowctr = 1; rowctr <= rowcnt; rowctr++) { tablerow trow = new tablerow(); privilegetable.rows.add(trow); foreach (datarow checkboxtitle in g.rows) { tablecell tc = new tablecell(); //system.web.ui.webcontrols.checkbox cb = new system.web.ui.webcontrols.checkbox(); tc.text = checkboxtitle.itemarray[1].tostring(); tablecell tcell = new tablecell(); trow.cells.add(tcell); tcell.controls.add(new literalcontrol(checkboxtitle.itemarray[1].tostring())); } } checkboxlist chklist = new checkboxlist(); //sqldataadapter adp = new sqldataadapter("select v.view_id,v.view_name,p.privilege_id,p.privilege_name tblviews v right outer bring together tblprivileges p on v.view_id = p.privilege_id", con); sqldataadapter adp = new sqldataadapter("select * tblprivileges", con); dataset ds = new dataset(); adp.fill(ds); datatable dt = new datatable(); adp.fill(dt); foreach (datarow name in dt.rows) { tablerow tr = new tablerow(); tablecell tctitle = new tablecell(); tctitle.text = name.itemarray[1].tostring(); tr.cells.add(tctitle); foreach (datarow checkboxtitle in g.rows) { tablecell tc = new tablecell(); system.web.ui.webcontrols.checkbox cb = new system.web.ui.webcontrols.checkbox(); tc.text = checkboxtitle.itemarray[1].tostring(); tc.controls.add(cb); tr.cells.add(tc); } privilegetable.rows.add(tr); base.oninit(e); } }

i need select checkbox values , after click of button, selected checkbox values should go mutual table. not able set attribute "id" of checkboxes. how save selected checkbox values on button click in db table?

kindly help!!!

you need understand asp.net page lifecycle in order dynamically add together server controls pages. adding controls page late.

c# asp.net sql sql-server