Thursday 7 February 2013

Step by Step Repeater Control example in asp.net or Display data in tabular format asp net c#

Step by Step Repeater Control example in asp.net or Display data in tabular format asp net c#


Database



 Default.aspx


<body>
    <form id="form1" runat="server">
    <div>
   
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false">
        <Columns>
        <asp:TemplateField>
        <HeaderTemplate>Id</HeaderTemplate>
        <ItemTemplate>
        <asp:LinkButton runat="server" PostBackUrl='<%#"Default2.aspx?id="+Eval("id") %>'>Id</asp:LinkButton>
        </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField>
        <HeaderTemplate>Product</HeaderTemplate>
        <ItemTemplate>
        <asp:Label runat=server Text='<%#Eval("pname") %>'></asp:Label>
        </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField>
        <HeaderTemplate>Image</HeaderTemplate>
        <ItemTemplate>
        <asp:Image runat="server" ImageUrl='<%#"img/"+Eval("pimg") %>' Height="100px" Width="100px" />
        </ItemTemplate>
        </asp:TemplateField>
       
        </Columns>
        </asp:GridView>
   
    </div>
    </form>
</body>


 Default.aspx.cs

public partial class _Default : System.Web.UI.Page
{
    SqlConnection con;
    SqlDataAdapter da;

    protected void Page_Load(object sender, EventArgs e)
    {
        con = new SqlConnection(@"Data Source=A8-2\ATMIYA;Initial Catalog=test;Integrated Security=True");
        con.Open();
        da = new SqlDataAdapter("select * from prd_mst",con);
        DataSet ds = new DataSet();
        da.Fill(ds);
        GridView1.DataSource = ds;
        GridView1.DataBind();


    }
}




Default2.aspx

<body>
    <form id="form1" runat="server">
    <div>
   
        <asp:Repeater ID="Repeater1" runat="server">
        <HeaderTemplate>
       
        <table border="1">
              
        </HeaderTemplate>
        <ItemTemplate>
       
        <tr>
            <td><%#Eval("id") %></td>
            <td rowspan="2"><asp:Image runat="server" ImageUrl='<%#"img/"+Eval("pimg") %>' Height="75px" Width="75px" /></td>
     </tr>
     <tr>
            <td><%#Eval("pname") %></td>
    </tr>
    <tr>
         <td colspan="2"><%#Eval("pdesc") %></td>
    </tr>
       
       
        </ItemTemplate>
        <FooterTemplate>
        </table>
        </FooterTemplate>
       
        </asp:Repeater>
   
    </div>
    </form>
</body>

Default2.aspx.cs

public partial class Default2 : System.Web.UI.Page
{
    SqlConnection con;
    SqlDataAdapter da;
    protected void Page_Load(object sender, EventArgs e)
    {
        con = new SqlConnection(@"Data Source=A8-2\ATMIYA;Initial Catalog=test;Integrated Security=True");
        con.Open();
        da = new SqlDataAdapter("select * from prd_mst where id="+Request.QueryString["id"],con);
        DataSet ds = new DataSet();
        da.Fill(ds);
        Repeater1.DataSource = ds;
        Repeater1.DataBind();

    }
}



Share This
Previous Post
Next Post

2 comments: