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();
}
}
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();
}
}
yes i agree programmer will get lots of knowledge about coding thanks for info.
ReplyDeleteBest engineering college in bangalore
Your Blog is Very Nice...!!!!
ReplyDeleteDynamic Website Design