| 发表于:2007-06-04 20:51:022楼 得分:0 |
以下代码供参考 protected void repeater1_itemdatabound(object sender, repeateritemeventargs e) { if (e.item.itemtype == listitemtype.item ¦ ¦ e.item.itemtype == listitemtype.alternatingitem) { string au_id = ((datarowview)e.item.dataitem).row[ "au_id "].tostring(); radiobuttonlist radiobuttonlist1 = (repeater)e.item.findcontrol( "radiobuttonlist1 "); if (radiobuttonlist1 != null) { sqlconnection cn = new sqlconnection( "server=.;uid=sa;pwd=;database=pubs "); sqlcommand cmd = new sqlcommand( "select au_id, au_lname from authors where au_id = @au_id ", cn); cmd.parameters.add( "@au_id ", sqldbtype.varchar, 11).value = au_id; cn.open(); radiobuttonlist1.datasource = cmd.EXECutereader(); radiobuttonlist1.datavaluefield = "au_id "; radiobuttonlist1.datatextfield = "au_lname "; radiobuttonlist1.databind(); cn.close(); } } } | | |
|