This article shows how to bind data in data controls without using any database and also shows paging on controls. We will learn here how to bind controls with data without a database and how to handle paging on controls.

Initial Chamber

Step 1

Open your Visual Studio and create an empty website then provide a suitable name such as DataControlExp.

Step 2

In Solution Explorer you will get your empty website, then add some web forms.

DataControlExp (your empty website). Right-click and select Add New Item Web Form. Name it DataControlExp.aspx.

Design Chamber

Step 3

Open the DataControlExp.aspx file and write some code for the design of the application.

This is the ListView design phase.

Here I've designed the ListView Control and used some property as in the following:

  1. <div>
  2. <h3>ListView</h3>
  3. <asp:ListView ID="lvCustomers" runat="server" GroupPlaceholderID="groupPlaceHolder1"
  4. ItemPlaceholderID="itemPlaceHolder1" OnPagePropertiesChanging="OnPagePropertiesChanging">
  5. <LayoutTemplate>
  6. <table border="1">
  7. <tr>
  8. <th>Product </th>
  9. <th>Quantity </th>
  10. <th>Price </th>
  11. </tr>
  12. <asp:PlaceHolder runat="server" ID="groupPlaceHolder1"></asp:PlaceHolder>
  13. <tr>
  14. <td colspan="3">
  15. <asp:DataPager ID="DataPager1" runat="server" PagedControlID="lvCustomers" PageSize="2">
  16. <Fields>
  17. <asp:NextPreviousPagerField ButtonType="Link" ShowFirstPageButton="false" ShowPreviousPageButton="true"
  18. ShowNextPageButton="false" />
  19. <asp:NumericPagerField ButtonType="Link" />
  20. <asp:NextPreviousPagerField ButtonType="Link" ShowNextPageButton="true" ShowLastPageButton="false" ShowPreviousPageButton="false" />
  21. </Fields>
  22. </asp:DataPager>
  23. </td>
  24. </tr>
  25. </table>
  26. </LayoutTemplate>
  27. <GroupTemplate>
  28. <tr>
  29. <asp:PlaceHolder runat="server" ID="itemPlaceHolder1"></asp:PlaceHolder>
  30. </tr>
  31. </GroupTemplate>
  32. <ItemTemplate>
  33. <td><%# Eval("Product_Name") %>
  34. </td>
  35. <td><%# Eval("Quantity") %>
  36. </td>
  37. <td><%# Eval("Price") %>
  38. </td>
  39. </ItemTemplate>
  40. </asp:ListView>
  41. </div>

FormView control

I've designed a FormView control as in the following:

  1. <h3>FormView</h3>
  2. <div>
  3. <asp:FormView ID="FormView1" runat="server"
  4. AllowPaging="True" EnableViewState="False" OnPageIndexChanging="FormView1_PageIndexChanging" BackColor="Green">
  5. <ItemTemplate>
  6. <hr />
  7. <h3><%# Eval("Product_Name") %>
  8. </h3>
  9. <table border="0">
  10. <tr>
  11. <td class="ProductPropertyLabel">Quantity:</td>
  12. <td class="ProductPropertyValue"><%# Eval("Quantity") %>
  13. </td>
  14. <td class="ProductPropertyLabel">Price:</td>
  15. <td class="ProductPropertyValue"><%# Eval("Price")%>
  16. </td>
  17. </tr>
  18. </table>
  19. <hr />
  20. </ItemTemplate>
  21. </asp:FormView>
  22. </div>
  23. Here design DetailsView-
  25. <h3>DetailsView</h3>
  26. <div>
  27. <div>
  28. <asp:DetailsView ID="DetailsView1" OnPageIndexChanging="DetailsView1_PageIndexChanging" BackColor="Wheat"
  29. AllowPaging="true" runat="server" />
  30. </div>
  31. </div>
  32. Here design GridView-
  34. <h3>GridView</h3>
  35. <div>
  36. <asp:GridView ID="gvExample" runat="server" AllowPaging="true" PageSize="2" AutoGenerateColumns="False" BackColor="PINK" BorderColor="#E7E7FF"
  37. BorderWidth="1px" CellPadding="3" OnPageIndexChanging="gvExample_PageIndexChanging">
  38. <Columns>
  39. <asp:TemplateField HeaderText="Product_Name">
  40. <ItemTemplate>
  41. <asp:Label ID="lblProduct" runat="server" Text='<%#Eval("Product_Name")%>'>
  42. </asp:Label>
  43. </ItemTemplate>
  44. </asp:TemplateField>
  45. <asp:TemplateField HeaderText="Quantity">
  46. <ItemTemplate>
  47. <asp:Label ID="lblQuantity" runat="server" Text='<%#Eval("Quantity")%>'>
  48. </asp:Label>
  49. </ItemTemplate>
  50. </asp:TemplateField>
  51. <asp:TemplateField HeaderText="Price">
  52. <ItemTemplate>
  53. <asp:Label ID="lblPrice" runat="server" Text='<%#Eval("Price")%>'>
  54. </asp:Label>
  55. </ItemTemplate>
  56. </asp:TemplateField>
  57. </Columns>
  58. </asp:GridView>
  59. </div>
The page looks as in the following.

DataControlExp.aspx
  1. <%@ Page Language="C#" AutoEventWireup="true" CodeFile="DataControlExp.aspx.cs" Inherits="DataControlExp" %>
  2. <!DOCTYPE html>
  3. <html
  4. xmlns="http://www.w3.org/1999/xhtml">
  5. <head runat="server">
  6. <title></title>
  7. </head>
  8. <body>
  9. <form id="form1" runat="server">
  10. <div>
  11. <div style="width: 50%">
  12. <div>
  13. <h3>ListView</h3>
  14. <asp:ListView ID="lvCustomers" runat="server" GroupPlaceholderID="groupPlaceHolder1"
  15. ItemPlaceholderID="itemPlaceHolder1" OnPagePropertiesChanging="OnPagePropertiesChanging">
  16. <LayoutTemplate>
  17. <table border="1">
  18. <tr>
  19. <th>Product
  20. </th>
  21. <th>Quantity
  22. </th>
  23. <th>Price
  24. </th>
  25. </tr>
  26. <asp:PlaceHolder runat="server" ID="groupPlaceHolder1"></asp:PlaceHolder>
  27. <tr>
  28. <td colspan="3">
  29. <asp:DataPager ID="DataPager1" runat="server" PagedControlID="lvCustomers" PageSize="2">
  30. <Fields>
  31. <asp:NextPreviousPagerField ButtonType="Link" ShowFirstPageButton="false" ShowPreviousPageButton="true"
  32. ShowNextPageButton="false" />
  33. <asp:NumericPagerField ButtonType="Link" />
  34. <asp:NextPreviousPagerField ButtonType="Link" ShowNextPageButton="true" ShowLastPageButton="false" ShowPreviousPageButton="false" />
  35. </Fields>
  36. </asp:DataPager>
  37. </td>
  38. </tr>
  39. </table>
  40. </LayoutTemplate>
  41. <GroupTemplate>
  42. <tr>
  43. <asp:PlaceHolder runat="server" ID="itemPlaceHolder1"></asp:PlaceHolder>
  44. </tr>
  45. </GroupTemplate>
  46. <ItemTemplate>
  47. <td><%# Eval("Product_Name") %>
  48. </td>
  49. <td><%# Eval("Quantity") %>
  50. </td>
  51. <td><%# Eval("Price") %>
  52. </td>
  53. </ItemTemplate>
  54. </asp:ListView>
  55. </div>
  56. <br />
  57. <h3>FormView</h3>
  58. <div>
  59. <asp:FormView ID="FormView1" runat="server"
  60. AllowPaging="True" EnableViewState="False" OnPageIndexChanging="FormView1_PageIndexChanging" BackColor="Green">
  61. <ItemTemplate>
  62. <hr />
  63. <h3><%# Eval("Product_Name") %>
  64. </h3>
  65. <table border="0">
  66. <tr>
  67. <td class="ProductPropertyLabel">Quantity:</td>
  68. <td class="ProductPropertyValue"><%# Eval("Quantity") %>
  69. </td>
  70. <td class="ProductPropertyLabel">Price:</td>
  71. <td class="ProductPropertyValue"><%# Eval("Price")%>
  72. </td>
  73. </tr>
  74. </table>
  75. <hr />
  76. </ItemTemplate>
  77. </asp:FormView>
  78. </div>
  79. </div>
  80. <div style="width: 50%">
  81. <h3>DetailsView</h3>
  82. <div>
  83. <div>
  84. <asp:DetailsView ID="DetailsView1" OnPageIndexChanging="DetailsView1_PageIndexChanging" BackColor="Wheat"
  85. AllowPaging="true" runat="server" />
  86. </div>
  87. </div>
  88. <h3>GridView</h3>
  89. <div>
  90. <asp:GridView ID="gvExample" runat="server" AllowPaging="true" PageSize="2" AutoGenerateColumns="False" BackColor="PINK" BorderColor="#E7E7FF"
  91. BorderWidth="1px" CellPadding="3" OnPageIndexChanging="gvExample_PageIndexChanging">
  92. <Columns>
  93. <asp:TemplateField HeaderText="Product_Name">
  94. <ItemTemplate>
  95. <asp:Label ID="lblProduct" runat="server" Text='<%#Eval("Product_Name")%>'>
  96. </asp:Label>
  97. </ItemTemplate>
  98. </asp:TemplateField>
  99. <asp:TemplateField HeaderText="Quantity">
  100. <ItemTemplate>
  101. <asp:Label ID="lblQuantity" runat="server" Text='<%#Eval("Quantity")%>'>
  102. </asp:Label>
  103. </ItemTemplate>
  104. </asp:TemplateField>
  105. <asp:TemplateField HeaderText="Price">
  106. <ItemTemplate>
  107. <asp:Label ID="lblPrice" runat="server" Text='<%#Eval("Price")%>'>
  108. </asp:Label>
  109. </ItemTemplate>
  110. </asp:TemplateField>
  111. </Columns>
  112. </asp:GridView>
  113. </div>
  114. </div>
  115. </div>
  116. </form>
  117. </body>
  118. </html>
CODE CHAMBER

Step 4

In the code chamber we will write some code so that our application works.

DataControlExp.aspx.cs
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Data;
  4. using System.Data.SqlClient;
  5. using System.Linq;
  6. using System.Web;
  7. using System.Web.UI;
  8. using System.Web.UI.WebControls;
  11. public partial class DataControlExp: System.Web.UI.Page
  12. {
  13. protected void Page_Load(object sender, EventArgs e)
  14. {
  15. if (!IsPostBack) {
  16. BindListView();
  17. BindFormView();
  18. BindDetailsView();
  19. BindGridView();
  20. }
  22. }
  24. protected void BindListView()
  25. {
  26. //Creating a dataset
  27. DataSet ds = new DataSet();
  28. DataTable dt;
  29. DataRow dr;
  30. DataColumn pName;
  31. DataColumn pQty;
  32. DataColumn pPrice;
  33. //create an object of datatable
  34. dt = new DataTable();
  35. //creating column of datatable with datatype
  36. pName = new DataColumn("Product_Name", Type.GetType("System.String"));
  37. pQty = new DataColumn("Quantity", Type.GetType("System.Int32"));
  38. pPrice = new DataColumn("Price", Type.GetType("System.Int32"));
  39. //bind data table columns in datatable
  40. dt.Columns.Add(pName);
  41. dt.Columns.Add(pQty);
  42. dt.Columns.Add(pPrice);
  43. //creating data row and assiging the value to columns of datatable
  44. dr = dt.NewRow();
  45. dr["Product_Name"] = "Product 1";
  46. dr["Quantity"] = 2;
  47. dr["Price"] = 200;
  48. dt.Rows.Add(dr);
  50. dr = dt.NewRow();
  51. dr["Product_Name"] = "Product 2";
  52. dr["Quantity"] = 5;
  53. dr["Price"] = 480;
  54. dt.Rows.Add(dr);
  56. dr = dt.NewRow();
  57. dr["Product_Name"] = "Product 3";
  58. dr["Quantity"] = 8;
  59. dr["Price"] = 100;
  60. dt.Rows.Add(dr);
  62. dr = dt.NewRow();
  63. dr["Product_Name"] = "Product 4";
  64. dr["Quantity"] = 2;
  65. dr["Price"] = 500;
  66. dt.Rows.Add(dr);
  67. //Add datatable to the dataset
  68. ds.Tables.Add(dt);
  69. //bind data to data controls
  70. lvCustomers.DataSource = ds.Tables[0];
  71. lvCustomers.DataBind();
  72. }
  73. //paging code
  74. protected void OnPagePropertiesChanging(object sender, PagePropertiesChangingEventArgs e)
  75. {
  76. (lvCustomers.FindControl("DataPager1") as DataPager).SetPageProperties(e.StartRowIndex, e.MaximumRows, false);
  77. this.BindListView();
  78. }
  80. protected void BindFormView()
  81. {
  83. //Creating a dataset
  84. DataSet ds = new DataSet();
  85. DataTable dt;
  86. DataRow dr;
  87. DataColumn pName;
  88. DataColumn pQty;
  89. DataColumn pPrice;
  90. //create an object of datatable
  91. dt = new DataTable();
  92. //creating column of datatable with datatype
  93. pName = new DataColumn("Product_Name", Type.GetType("System.String"));
  94. pQty = new DataColumn("Quantity", Type.GetType("System.Int32"));
  95. pPrice = new DataColumn("Price", Type.GetType("System.Int32"));
  96. //bind data table columns in datatable
  97. dt.Columns.Add(pName);
  98. dt.Columns.Add(pQty);
  99. dt.Columns.Add(pPrice);
  100. //creating data row and assiging the value to columns of datatable
  101. dr = dt.NewRow();
  102. dr["Product_Name"] = "Product 1";
  103. dr["Quantity"] = 2;
  104. dr["Price"] = 200;
  105. dt.Rows.Add(dr);
  107. dr = dt.NewRow();
  108. dr["Product_Name"] = "Product 2";
  109. dr["Quantity"] = 5;
  110. dr["Price"] = 480;
  111. dt.Rows.Add(dr);
  113. dr = dt.NewRow();
  114. dr["Product_Name"] = "Product 3";
  115. dr["Quantity"] = 8;
  116. dr["Price"] = 100;
  117. dt.Rows.Add(dr);
  119. dr = dt.NewRow();
  120. dr["Product_Name"] = "Product 4";
  121. dr["Quantity"] = 2;
  122. dr["Price"] = 500;
  123. dt.Rows.Add(dr);
  124. //Add datatable to the dataset
  125. ds.Tables.Add(dt);
  126. //bind data to data controls
  127. FormView1.DataSource = ds.Tables[0];
  128. FormView1.DataBind();
  129. }
  130. //paging code
  131. protected void FormView1_PageIndexChanging(object sender, FormViewPageEventArgs e)
  132. {
  133. FormView1.PageIndex = e.NewPageIndex;
  134. BindFormView();
  135. }
  137. protected void BindDetailsView()
  138. {
  139. //Creating a dataset
  140. DataSet ds = new DataSet();
  141. DataTable dt;
  142. DataRow dr;
  143. DataColumn pName;
  144. DataColumn pQty;
  145. DataColumn pPrice;
  146. //create an object of datatable
  147. dt = new DataTable();
  148. //creating column of datatable with datatype
  149. pName = new DataColumn("Product_Name", Type.GetType("System.String"));
  150. pQty = new DataColumn("Quantity", Type.GetType("System.Int32"));
  151. pPrice = new DataColumn("Price", Type.GetType("System.Int32"));
  152. //bind data table columns in datatable
  153. dt.Columns.Add(pName);
  154. dt.Columns.Add(pQty);
  155. dt.Columns.Add(pPrice);
  156. //creating data row and assiging the value to columns of datatable
  157. dr = dt.NewRow();
  158. dr["Product_Name"] = "Product 1";
  159. dr["Quantity"] = 2;
  160. dr["Price"] = 200;
  161. dt.Rows.Add(dr);
  163. dr = dt.NewRow();
  164. dr["Product_Name"] = "Product 2";
  165. dr["Quantity"] = 5;
  166. dr["Price"] = 480;
  167. dt.Rows.Add(dr);
  169. dr = dt.NewRow();
  170. dr["Product_Name"] = "Product 3";
  171. dr["Quantity"] = 8;
  172. dr["Price"] = 100;
  173. dt.Rows.Add(dr);
  175. dr = dt.NewRow();
  176. dr["Product_Name"] = "Product 4";
  177. dr["Quantity"] = 2;
  178. dr["Price"] = 500;
  179. dt.Rows.Add(dr);
  180. //Add datatable to the dataset
  181. ds.Tables.Add(dt);
  182. //bind data to data controls
  183. DetailsView1.DataSource = ds.Tables[0];
  184. DetailsView1.DataBind();
  185. }
  186. //paging code
  187. protected void DetailsView1_PageIndexChanging(object sender, DetailsViewPageEventArgs e)
  188. {
  189. DetailsView1.PageIndex = e.NewPageIndex;
  190. BindDetailsView();
  191. }
  193. protected void BindGridView()
  194. {
  195. //Creating a dataset
  196. DataSet ds = new DataSet();
  197. DataTable dt;
  198. DataRow dr;
  199. DataColumn pName;
  200. DataColumn pQty;
  201. DataColumn pPrice;
  202. //create an object of datatable
  203. dt = new DataTable();
  204. //creating column of datatable with datatype
  205. pName = new DataColumn("Product_Name", Type.GetType("System.String"));
  206. pQty = new DataColumn("Quantity", Type.GetType("System.Int32"));
  207. pPrice = new DataColumn("Price", Type.GetType("System.Int32"));
  208. //bind data table columns in datatable
  209. dt.Columns.Add(pName);
  210. dt.Columns.Add(pQty);
  211. dt.Columns.Add(pPrice);
  212. //creating data row and assiging the value to columns of datatable
  213. dr = dt.NewRow();
  214. dr["Product_Name"] = "Product 1";
  215. dr["Quantity"] = 2;
  216. dr["Price"] = 200;
  217. dt.Rows.Add(dr);
  219. dr = dt.NewRow();
  220. dr["Product_Name"] = "Product 2";
  221. dr["Quantity"] = 5;
  222. dr["Price"] = 480;
  223. dt.Rows.Add(dr);
  225. dr = dt.NewRow();
  226. dr["Product_Name"] = "Product 3";
  227. dr["Quantity"] = 8;
  228. dr["Price"] = 100;
  229. dt.Rows.Add(dr);
  231. dr = dt.NewRow();
  232. dr["Product_Name"] = "Product 4";
  233. dr["Quantity"] = 2;
  234. dr["Price"] = 500;
  235. dt.Rows.Add(dr);
  236. //Add datatable to the dataset
  237. ds.Tables.Add(dt);
  238. //bind data to data controls
  239. gvExample.DataSource = ds.Tables[0];
  240. gvExample.DataBind();
  242. }
  243. //paging code
  244. protected void gvExample_PageIndexChanging(object sender, GridViewPageEventArgs e)
  245. {
  246. gvExample.PageIndex = e.NewPageIndex;
  247. BindGridView();
  248. }
  249. }

Output

Figure 1:Output

I hope you liked this. Have a good day. Thank you for reading.