Connecting link button to database to fetch data

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Configuration;
public partial class Dynamic_link : System.Web.UI.Page
{
SqlConnection cnn = new SqlConnection();
protected void Page_Load(object sender, EventArgs e)
{
cnn.ConnectionString=ConfigurationManager.ConnectionStrings["jin"].ConnectionString;
if(cnn.State==ConnectionState.Closed)
{
cnn.Open();
}
SqlCommand cm = new SqlCommand("select itemname from menu", cnn);
cm.CommandType = CommandType.Text;
SqlDataAdapter da = new SqlDataAdapter(cm);
DataSet dt = new DataSet();
da.Fill(dt);
Repeater Repeater1 = new Repeater();
Repeater1.DataSource = dt;
Repeater1.DataBind();
if (cnn.State == ConnectionState.Open)
{
cnn.Close();
}
foreach (RepeaterItem repeatItem in Repeater1.Items)
{
// if condition to add HeaderTemplate Dynamically only Once
if (repeatItem.ItemIndex == 0)
{
RepeaterItem headerItem = new RepeaterItem(repeatItem.ItemIndex, ListItemType.Header);
HtmlGenericControl hTag = new HtmlGenericControl("h4");
hTag.InnerHtml = "Menu Collection";
repeatItem.Controls.Add(hTag);
}
// Add ItemTemplate DataItems Dynamically
//SqlDataReader dr = Int32.Parse;
RepeaterItem repeaterItem = new RepeaterItem(repeatItem.ItemIndex, ListItemType.Item);
LinkButton lnk = new LinkButton();
lnk.ID = "lnk_itemname";
lnk.Text = String.Format("{0}",(dt.Tables[0].Rows[repeatItem.ItemIndex]["itemname"]));
repeatItem.Controls.Add(lnk);
// Add SeparatorTemplate Dynamically
repeaterItem = new RepeaterItem(repeatItem.ItemIndex, ListItemType.Separator);
LiteralControl ltrlHR = new LiteralControl();
ltrlHR.Text = "";
repeatItem.Controls.Add(ltrlHR);
}
// Add Repeater Control as Child Control
// of Panel Control
Panel1.Controls.Add(Repeater1);
}
}

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Rajkiran Swain9y ago
1. using System;
2. using System.Collections.Generic;
3. using System.Linq;
4. using System.Web;
5. using System.Web.UI;
6. using System.Web.UI.WebControls;
7. using System.Data;
8. using System.Web.UI.HtmlControls;
9. using System.Data.SqlClient;
10. using System.Configuration;
12. public partial class Dynamic_link : System.Web.UI.Page
13. {
14. SqlConnection cnn = new SqlConnection();
15. protected void Page_Load(object sender, EventArgs e)
16. {
17. cnn.ConnectionString=ConfigurationManager.ConnectionStrings["jin"].ConnectionString;
18. if(cnn.State==ConnectionState.Closed)
19. {
20. cnn.Open();
21. }
22. SqlCommand cm = new SqlCommand("select itemname from menu", cnn);
23. cm.CommandType = CommandType.Text;
24. SqlDataAdapter da = new SqlDataAdapter(cm);
25. DataSet dt = new DataSet();
26. da.Fill(dt);
27. Repeater Repeater1 = new Repeater();
28. Repeater1.DataSource = dt;
29. Repeater1.DataBind();
30. if (cnn.State == ConnectionState.Open)
31. {
32. cnn.Close();
33. }
34. foreach (RepeaterItem repeatItem in Repeater1.Items)
35. {
36. // if condition to add HeaderTemplate Dynamically only Once
37. if (repeatItem.ItemIndex == 0)
38. {
39. RepeaterItem headerItem = new RepeaterItem(repeatItem.ItemIndex, ListItemType.Header);
40. HtmlGenericControl hTag = new HtmlGenericControl("h4");
41. hTag.InnerHtml = "Menu Collection";
42. repeatItem.Controls.Add(hTag);
43. }
45. // Add ItemTemplate DataItems Dynamically
46. //SqlDataReader dr = Int32.Parse;
47. RepeaterItem repeaterItem = new RepeaterItem(repeatItem.ItemIndex, ListItemType.Item);
48. LinkButton lnk = new LinkButton();
49. lnk.ID = "lnk_itemname";
50. lnk.Text = String.Format("{0}",(dt.Tables[0].Rows[repeatItem.ItemIndex]["itemname"]));
51. repeatItem.Controls.Add(lnk);
52. // Add SeparatorTemplate Dynamically
53. repeaterItem = new RepeaterItem(repeatItem.ItemIndex, ListItemType.Separator);
54. LiteralControl ltrlHR = new LiteralControl();
55. ltrlHR.Text = "";
56. repeatItem.Controls.Add(ltrlHR);
57. }
59. // Add Repeater Control as Child Control
60. // of Panel Control
61. Panel1.Controls.Add(Repeater1);
62. }
64. }
And Design Source is:
<asp:Panel ID="Panel1" runat="server">
<asp:Repeater ID="Repeater1" runat="server">
    <HeaderTemplate>
        <h4>
            Menu Items h4>
    HeaderTemplate>
    <ItemTemplate>
        <%#DataBinder.Eval(Container.DataItem,"itemname") %>
    ItemTemplate>
    <SeparatorTemplate>
        <hr />
    SeparatorTemplate>
asp:Repeater>
asp:Panel>