Mark This Response as Answer -- Chandu http://www.dotnetfunda.com/images/dnfmvp.gif
<html xmlns="http://www.w3.org/1999/xhtml"><head runat="server"> <title></title></head><body> <form id="form1" runat="server"> <div> <asp:Repeater runat="server" ID="rowRepeater" OnItemDataBound="rowRepeater_ItemBound"> <HeaderTemplate> <table border="1px SOLID #666"> <tr> <asp:Repeater runat="server" ID="headerRepeater"> <ItemTemplate> <th> <%# Eval("LocationNm")%> </th> </ItemTemplate> </asp:Repeater> </tr> </HeaderTemplate> <ItemTemplate> <tr> <asp:Repeater runat="server" ID="columnRepeater"> <ItemTemplate> <td> <asp:TextBox ID="txtLocation" runat="server" Text=''></asp:TextBox> </td> </ItemTemplate> </asp:Repeater> </tr> </ItemTemplate> <FooterTemplate> </table> </FooterTemplate> </asp:Repeater> </div> </form></body></html>
public partial class repeatertest : System.Web.UI.Page { SqlConnection conn = new SqlConnection("Data Source=(local);Initial Catalog=EDMtest;Persist Security Info=True;User ID=sa;Password=truser"); SqlCommand cmd = new SqlCommand(); SqlDataAdapter DA; DataSet LDA; protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { LDA = new DataSet(); conn.Open(); DA = new SqlDataAdapter("SELECT * FROM Location", conn); DA.Fill(LDA); rowRepeater.DataSource = LDA; rowRepeater.DataBind(); conn.Close(); } } protected void rowRepeater_ItemBound(object sender, RepeaterItemEventArgs e) { if (e.Item.ItemType == ListItemType.Header) { Repeater headerRepeater = e.Item.FindControl("headerRepeater") as Repeater; headerRepeater.DataSource = LDA; headerRepeater.DataBind(); } else if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { Repeater columnRepeater = e.Item.FindControl("columnRepeater") as Repeater; columnRepeater.DataSource = LDA; columnRepeater.DataBind(); } } }
Login to post response