We will bind some data from the database and we are using SQLDataSource.

Initial chamber

Step 1: Open Visual Studio 2010 and create an empty website. Give a suitable name Listview_demo.

Step 2: In Solution Explorer you will get your empty website. Add a web form, SQL Database. By going like the following:

For Web Form:

Listview_demo (Your Empty Website) - Right Click, Add New Item, then Web Form. Name it Listview_demo.aspx.

For SQL Server Database:

Listview_demo (Your Empty Website) - Right Click, Add New Item, then SQL Server Database. Add Database inside the App_Data_folder.

Database chamber

Step 3: Go to your database Database.mdf, we will create a table - tbl_Data. Go to database.mdf - Table and add New table. Design your table like the following:

Table - tbl_data (Don’t forget to make ID, Identity Specification - Yes)

table design

Show Table Data

table

Design chamber

Step 5: Now open your Listview_demo.aspx file, where we create our design for BINDING ListView using SQLDataSource.

ListView_demo.aspx

  1. <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
  3. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  5. <html xmlns="http://www.w3.org/1999/xhtml">
  6. <head runat="server">
  7. <title></title>
  8. </head>
  9. <body>
  10. <form id="form1" runat="server">
  11. <div>
  13. <asp:ListView ID="ListView1" runat="server" DataKeyNames="Product ID"
  14. DataSourceID="SqlDataSource1">
  15. <AlternatingItemTemplate>
  16. <li style="">Product ID:
  17. <asp:Label ID="Product_IDLabel" runat="server"
  18. Text='<%# Eval("[Product ID]") %>' />
  19. <br />
  20. Product Name:
  21. <asp:Label ID="Product_NameLabel" runat="server"
  22. Text='<%# Eval("[Product Name]") %>' />
  23. <br />
  24. Quantity:
  25. <asp:Label ID="QuantityLabel" runat="server" Text='<%# Eval("Quantity") %>' />
  26. <br />
  27. Unit Price:
  28. <asp:Label ID="Unit_PriceLabel" runat="server"
  29. Text='<%# Eval("[Unit Price]") %>' />
  30. <br />
  31. </li>
  32. </AlternatingItemTemplate>
  33. <EditItemTemplate>
  34. <li style="">Product ID:
  35. <asp:Label ID="Product_IDLabel1" runat="server"
  36. Text='<%# Eval("[Product ID]") %>' />
  37. <br />
  38. Product Name:
  39. <asp:TextBox ID="Product_NameTextBox" runat="server"
  40. Text='<%# Bind("[Product Name]") %>' />
  41. <br />
  42. Quantity:
  43. <asp:TextBox ID="QuantityTextBox" runat="server"
  44. Text='<%# Bind("Quantity") %>' />
  45. <br />
  46. Unit Price:
  47. <asp:TextBox ID="Unit_PriceTextBox" runat="server"
  48. Text='<%# Bind("[Unit Price]") %>' />
  49. <br />
  50. <asp:Button ID="UpdateButton" runat="server" CommandName="Update"
  51. Text="Update" />
  52. <asp:Button ID="CancelButton" runat="server" CommandName="Cancel"
  53. Text="Cancel" />
  54. </li>
  55. </EditItemTemplate>
  56. <EmptyDataTemplate>
  57. No data was returned.
  58. </EmptyDataTemplate>
  59. <InsertItemTemplate>
  60. <li style="">Product Name:
  61. <asp:TextBox ID="Product_NameTextBox" runat="server"
  62. Text='<%# Bind("[Product Name]") %>' />
  63. <br />
  64. Quantity:
  65. <asp:TextBox ID="QuantityTextBox" runat="server"
  66. Text='<%# Bind("Quantity") %>' />
  67. <br />
  68. Unit Price:
  69. <asp:TextBox ID="Unit_PriceTextBox" runat="server"
  70. Text='<%# Bind("[Unit Price]") %>' />
  71. <br />
  72. <asp:Button ID="InsertButton" runat="server" CommandName="Insert"
  73. Text="Insert" />
  74. <asp:Button ID="CancelButton" runat="server" CommandName="Cancel"
  75. Text="Clear" />
  76. </li>
  77. </InsertItemTemplate>
  78. <ItemSeparatorTemplate>
  79. <br />
  80. </ItemSeparatorTemplate>
  81. <ItemTemplate>
  82. <li style="">Product ID:
  83. <asp:Label ID="Product_IDLabel" runat="server"
  84. Text='<%# Eval("[Product ID]") %>' />
  85. <br />
  86. Product Name:
  87. <asp:Label ID="Product_NameLabel" runat="server"
  88. Text='<%# Eval("[Product Name]") %>' />
  89. <br />
  90. Quantity:
  91. <asp:Label ID="QuantityLabel" runat="server" Text='<%# Eval("Quantity") %>' />
  92. <br />
  93. Unit Price:
  94. <asp:Label ID="Unit_PriceLabel" runat="server"
  95. Text='<%# Eval("[Unit Price]") %>' />
  96. <br />
  97. </li>
  98. </ItemTemplate>
  99. <LayoutTemplate>
  100. <ul ID="itemPlaceholderContainer" runat="server" style="">
  101. <li runat="server" id="itemPlaceholder" />
  102. </ul>
  103. <div style="">
  104. </div>
  105. </LayoutTemplate>
  106. <SelectedItemTemplate>
  107. <li style="">Product ID:
  108. <asp:Label ID="Product_IDLabel" runat="server"
  109. Text='<%# Eval("[Product ID]") %>' />
  110. <br />
  111. Product Name:
  112. <asp:Label ID="Product_NameLabel" runat="server"
  113. Text='<%# Eval("[Product Name]") %>' />
  114. <br />
  115. Quantity:
  116. <asp:Label ID="QuantityLabel" runat="server" Text='<%# Eval("Quantity") %>' />
  117. <br />
  118. Unit Price:
  119. <asp:Label ID="Unit_PriceLabel" runat="server"
  120. Text='<%# Eval("[Unit Price]") %>' />
  121. <br />
  122. </li>
  123. </SelectedItemTemplate>
  124. </asp:ListView>
  125. <asp:SqlDataSource ID="SqlDataSource1" runat="server"
  126. ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
  127. SelectCommand="SELECT * FROM [tbl_data]"></asp:SqlDataSource>
  129. </div>
  130. </form>
  131. </body>
  132. </html>
Output chamber

listview from database

Hope you liked this. Thank you for reading.