/oboutSuite_3.5/Grid/aspnet_clearing_grid.aspx

https://github.com/michael2r/power-show · ASP.NET · 104 lines · 85 code · 19 blank · 0 comment · 1 complexity · 5da085a8ad927fc617112db344b601dc MD5 · raw file 

    

  1. <%@ Page Language="C#" %>
    2. 

  2. <%@ Register TagPrefix="obout" Namespace="Obout.Grid" Assembly="obout_Grid_NET" %>
    3. 

  3. <%@ Import Namespace="System.Data" %>
    4. 

  4. <%@ Import Namespace="System.Data.OleDb" %>
    5. 

  5. <%@ Import Namespace="System.Data.SqlClient" %>
    6. 

  6. 

  7. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    8. 

  8. 

  9. <script language="C#" runat="server">	
    10. 

  10. 	void Page_load(object sender, EventArgs e)		
    11. 

  11. 	{		
    12. 

  12. 		if (!Page.IsPostBack)
    13. 

  13. 		{
    14. 

  14. 			CreateGrid();			
    15. 

  15. 		}
    16. 

  16. 		
    17. 

  17. 	}
    18. 

  18. 	
    19. 

  19. 	void CreateGrid()
    20. 

  20. 	{
    21. 

  21. 		OleDbConnection myConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("../App_Data/Northwind.mdb"));
    22. 

  22. 

  23. 		OleDbCommand myComm = new OleDbCommand("SELECT TOP 25 * FROM Orders ORDER BY OrderID DESC", myConn);
    24. 

  24. 		myConn.Open();
    25. 

  25. 		/*OleDbDataAdapter da = new OleDbDataAdapter();
    26. 

  26. 		DataSet ds = new DataSet();
    27. 

  27. 		da.SelectCommand = myComm;
    28. 

  28. 		da.Fill(ds, "Orders");*/
    29. 

  29. 		OleDbDataReader myReader = myComm.ExecuteReader();
    30. 

  30. 

  31. 

  32. 		grid1.DataSource = myReader;
    33. 

  33. 		grid1.DataBind();
    34. 

  34. 

  35. 		myConn.Close();	
    36. 

  36. 	}
    37. 

  37.     
    38. 

  38.     void ClearGrid(object sender, EventArgs e)
    39. 

  39.     {
    40. 

  40.         grid1.ClearPreviousDataSource();
    41. 

  41.         grid1.DataSource = null;
    42. 

  42.         grid1.DataBind();
    43. 

  43.     }	
    44. 

  44. 	</script>
    45. 

  45. 

  46. <html>
    47. 

  47. 	<head>
    48. 

  48. 		<title>obout ASP.NET Grid examples</title>
    49. 

  49. 		<style type="text/css">
    50. 

  50. 			.tdText {
    51. 

  51. 				font:11px Verdana;
    52. 

  52. 				color:#333333;
    53. 

  53. 			}
    54. 

  54. 			.option2{
    55. 

  55. 				font:11px Verdana;
    56. 

  56. 				color:#0033cc;				
    57. 

  57. 				padding-left:4px;
    58. 

  58. 				padding-right:4px;
    59. 

  59. 			}
    60. 

  60. 			a {
    61. 

  61. 				font:11px Verdana;
    62. 

  62. 				color:#315686;
    63. 

  63. 				text-decoration:underline;
    64. 

  64. 			}
    65. 

  65. 

  66. 			a:hover {
    67. 

  67. 				color:crimson;
    68. 

  68. 			}
    69. 

  69. 		</style>		
    70. 

  70. 	</head>
    71. 

  71. 	<body>	
    72. 

  72. 		<form runat="server">
    73. 

  73. 					
    74. 

  74. 		<br />
    75. 

  75. 		<span class="tdText"><b>ASP.NET Grid - Clearing the Grid</b></span>
    76. 

  76. 		<br /><br />
    77. 

  77. 				
    78. 

  78. 		<obout:Grid id="grid1" runat="server" CallbackMode="true" Serialize="true" AutoGenerateColumns="false"
    79. 

  79. 			FolderStyle="styles/grand_gray" AllowAddingRecords="false">
    80. 

  80. 			<Columns>
    81. 

  81. 				<obout:Column DataField="OrderID" ReadOnly="true" HeaderText="ORDER ID" Width="100" runat="server"/>
    82. 

  82. 				<obout:Column DataField="ShipName" HeaderText="NAME" Width="200" runat="server"/>				
    83. 

  83. 				<obout:Column DataField="ShipCity" HeaderText="CITY" Width="150" runat="server" />
    84. 

  84. 				<obout:Column DataField="ShipPostalCode" HeaderText="POSTAL CODE" Width="150" runat="server" />
    85. 

  85. 				<obout:Column DataField="ShipCountry" HeaderText="COUNTRY" Width="150" runat="server" />				
    86. 

  86. 			</Columns>					
    87. 

  87. 		</obout:Grid>
    88. 

  88. 					
    89. 

  89. 		<br />
    90. 

  90. 		
    91. 

  91. 		<asp:Button runat="server" ID="btnClear" Text="Clear" OnClick="ClearGrid" CssClass="tdText" />
    92. 

  92. 		
    93. 

  93. 		<br /><br /><br />
    94. 

  94. 		<span class="tdText">
    95. 

  95. 		    To clear the records of the Grid, call the <b>ClearPreviousDataSource</b> method and set the <b>DataSource</b> property to <b>null</b>.
    96. 

  96. 		</span>
    97. 

  97. 		
    98. 

  98. 		<br /><br /><br />
    99. 

  99. 		
    100. 

  100. 		<a href="Default.aspx?type=ASPNET">« Back to examples</a>
    101. 

  101. 		
    102. 

  102. 		</form>
    103. 

  103. 	</body>
    104. 

  104. </html>
    105.