repeater asp.net issue vb -
i tried implement asp.net repeater show table attribut in database
protected function setable(byval name string) datatable conn.open() dim dt new datatable() dt.columns.addrange(new datacolumn(1) {new datacolumn("id", gettype(string)), new datacolumn("attribut", gettype(string))}) dim integer = 0 try mycommand = new sqlcommand("select column_name,* information_schema.columns table_name = '" & name & "' order ordinal_position", conn) rdrvsd = mycommand.executereader() while rdrvsd.read() dt.rows.add(i, rdrvsd.item("column_name")) += 1 loop rdrvsd.close() conn.close() return dt catch ex exception rdrvsd.close() conn.close() return dt end try end function
with datable returned tried databinding
repeater1.visible = true repeater1.datasource = setable(list.item(i)) repeater1.databind()
which list.item(i) name of table didn't find solution show table first table
<asp:repeater id="repeater1" runat="server"> <headertemplate> <table id="tblcontacts" border="0" cellpadding="0" cellspacing="0"> <tr> <th> </th> <th> table </th> </tr> </headertemplate> <itemtemplate> <tr> <td> <asp:checkbox id="checkbox1" text="" runat="server" /> </td> <td> <%#eval("attribut") %> </td> </tr> </itemtemplate> <footertemplate> </table> </footertemplate> </asp:repeater>
any idea please
i believe you're looking display entire list of attributes through repeater
. if so, want set datasource entire collection instead of single item in collection.
repeater1.datasource = dt
or
repeater1.datasource = list
are solutions think you're looking for. repeater
take entire collection , generate new row of markup each item in list
or datatable
Comments
Post a Comment