Sử dụng Bootsrap Tooltip cho Link Button trong Asp.net

<div style="text-align: justify;">(<b>Bootsrap Tooltip cho Link Button</b>) - Trong quá trình xây dựng phần mềm, có những màn hình không đủ diện tích để thể hiện đầy đủ các Linkbuton vừa có hình ảnh, vừa có chữ. Vậy làm sao để mỗi Linkbutton chỉ có mỗi biểu tượng mà người dùng vẫn biết nút lệnh đó có chức năng gì? Có 1 giải pháp để giải quyết vấn đề này, đó là sử dụng Tooltip. Hôm nay Thủ thuật tin học sẽ giới thiệu với các bạn cách sử dụng Bootsrap Tooltip cho Link Button, nhờ các Bootstrap tooltip sẽ giúp người lập trình mô tả rõ hơn chức năng của từng Linkbutton.<br /><a name="more"></a></div><br /><div style="text-align: center;"><b>Nghe những bài hát đỉnh nhất về Thấy cô giáo - <a href="https://www.youtube.com/watch?v=EXLGWIhgCx4&list=PL-dT-MN_dMzwvHPTb1hfqokY4b5RN_ngE" target="_blank">Nghe trên Youtube</a></b><br /><br /></div><iframe allowfullscreen="" frameborder="0" height="360" src="https://www.youtube.com/embed/videoseries?list=PL-dT-MN_dMzwvHPTb1hfqokY4b5RN_ngE&autoplay=1;loop=1&amp" width="640"></iframe><br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhCaRcxeub1K6T6AQU4XCkqzHrrgO8PrbRjHoFSkS6gx7N9aj54dEOCaFjL4iS_tnm2SY6TVXOCvONBTiNu6cb4UJ1nVaiFlMViCVLOyVPOvm-At1tSCo6KlZZz_8beV-jdOpQ7QlFUZrM/s1600/Main.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhCaRcxeub1K6T6AQU4XCkqzHrrgO8PrbRjHoFSkS6gx7N9aj54dEOCaFjL4iS_tnm2SY6TVXOCvONBTiNu6cb4UJ1nVaiFlMViCVLOyVPOvm-At1tSCo6KlZZz_8beV-jdOpQ7QlFUZrM/s1600/Main.gif" width="550px" /></a></div><div style="clear: both; text-align: center;"><div style="float: left; margin: 6px 6px 0 6px; width: 280px;"><a href="http://adf.ly/1MkjmT" target="_blank"><img alt="Code Example C#, Code Example VB.NET" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiX5IGNs5gxA6HJ6wKUOVKQztkzufZYGTWmDGsjzESeAbw5gPpVperxnvMiiMPTFhfTdeeR-4kUkJSAALEa1Zdq5fGg0wgUcUViEOH5dYhX9XotYaD-DD8jE1pIm0L0ooHc0HY9SBYOeQw/s1600/CS_Code.png" /></a> </div><div style="float: left; margin: 6px 6px 0 6px; width: 280px;"><a href="http://adf.ly/1JrunN" target="_blank"><img alt="Code Example C#, Code Example VB.NET" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgulrYoUfYJfz40EKRawQ-iISxhV1T4-vVi8rbwkzWwWPOb5NPStwQVd3K3r6lWGkxR5-PlyV7SuGFcERHd7mBlFCaD_HCymi57mq0FBSJ9FMTOIyVXckid3Adhkoc8fUrFD8twfkZS1U8/s1600/VB_Code.png" /></a> </div></div><div></div><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"><br /><br /><br />- <b>B1</b>: Download toàn bộ thư viện Bootstrap tại địa chỉ: <a href="http://adf.ly/1GE9Ks" target="_blank">Download</a></div><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;">Sau khi tải về, bạn sẽ có một file Zip. Tiến hành giải nén ta có một thư mục có tên bootstrap, bên trong có 3 thư mục : css, img, js.</div><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"><br /></div><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;">- <b>B2</b>: Tạo Project trong Microsoft Visual Studio 2010</div><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"><br /></div><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;">- <b>B3</b>: Tạo file Button.css có nội dung phía dưới và Copy vào thư mục Styles trong Project vừa tạo.</div><div class="code" id="code"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"><span style="color: maroon; font-family: Consolas; font-size: 9.5pt;">.icon-add</span><span style="font-family: Consolas; font-size: 9.5pt;"> {<o:p></o:p></span></div></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"><span style="font-family: Consolas; font-size: 9.5pt;">    <span style="color: red;">background-image</span>: <span style="color: blue;">url(Images/Icon/add.png)</span>;<o:p></o:p></span></div></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"><span style="font-family: Consolas; font-size: 9.5pt;">    <span style="color: red;">background-position</span>: <span style="color: blue;">center</span> <span style="color: blue;">center</span>;<o:p></o:p></span></div></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"><span style="font-family: Consolas; font-size: 9.5pt;">    <span style="color: red;">height</span>: <span style="color: blue;">16px</span>;<o:p></o:p></span></div></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"><span style="font-family: Consolas; font-size: 9.5pt;">    <span style="color: red;">width</span>: <span style="color: blue;">16px</span>;<o:p></o:p></span></div></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"><span style="font-family: Consolas; font-size: 9.5pt;">}<o:p></o:p></span></div></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"><br /></div></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"><span style="color: maroon; font-family: Consolas; font-size: 9.5pt;">.icon-edit</span><span style="font-family: Consolas; font-size: 9.5pt;"> {<o:p></o:p></span></div></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"><span style="font-family: Consolas; font-size: 9.5pt;">    <span style="color: red;">background-image</span>: <span style="color: blue;">url(Images/Icon/edit.gif)</span>;<o:p></o:p></span></div></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"><span style="font-family: Consolas; font-size: 9.5pt;">    <span style="color: red;">background-position</span>: <span style="color: blue;">center</span> <span style="color: blue;">center</span>;<o:p></o:p></span></div></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"><span style="font-family: Consolas; font-size: 9.5pt;">    <span style="color: red;">height</span>: <span style="color: blue;">16px</span>;<o:p></o:p></span></div></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"><span style="font-family: Consolas; font-size: 9.5pt;">    <span style="color: red;">width</span>: <span style="color: blue;">16px</span>;<o:p></o:p></span></div></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"><span style="font-family: Consolas; font-size: 9.5pt;">}<o:p></o:p></span></div></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"><br /></div></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"><span style="color: maroon; font-family: Consolas; font-size: 9.5pt;">.icon-update</span><span style="font-family: Consolas; font-size: 9.5pt;"> {<o:p></o:p></span></div></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"><span style="font-family: Consolas; font-size: 9.5pt;">    <span style="color: red;">background-image</span>: <span style="color: blue;">url(Images/Icon/save.png)</span>;<o:p></o:p></span></div></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"><span style="font-family: Consolas; font-size: 9.5pt;">    <span style="color: red;">background-position</span>: <span style="color: blue;">center</span> <span style="color: blue;">center</span>;<o:p></o:p></span></div></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"><span style="font-family: Consolas; font-size: 9.5pt;">    <span style="color: red;">height</span>: <span style="color: blue;">16px</span>;<o:p></o:p></span></div></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"><span style="font-family: Consolas; font-size: 9.5pt;">    <span style="color: red;">width</span>: <span style="color: blue;">16px</span>;<o:p></o:p></span></div></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"><span style="font-family: Consolas; font-size: 9.5pt;">}<o:p></o:p></span></div></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"><br /></div></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"><span style="color: maroon; font-family: Consolas; font-size: 9.5pt;">.icon-delete</span><span style="font-family: Consolas; font-size: 9.5pt;"> {<o:p></o:p></span></div></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"><span style="font-family: Consolas; font-size: 9.5pt;">    <span style="color: red;">background-image</span>: <span style="color: blue;">url(Images/Icon/delete.png)</span>;<o:p></o:p></span></div></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"><span style="font-family: Consolas; font-size: 9.5pt;">    <span style="color: red;">background-position</span>: <span style="color: blue;">center</span> <span style="color: blue;">center</span>;<o:p></o:p></span></div></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"><span style="font-family: Consolas; font-size: 9.5pt;">    <span style="color: red;">height</span>: <span style="color: blue;">16px</span>;<o:p></o:p></span></div></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"><span style="font-family: Consolas; font-size: 9.5pt;">    <span style="color: red;">width</span>: <span style="color: blue;">16px</span>;<o:p></o:p></span></div></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"><span style="font-family: Consolas; font-size: 9.5pt;">}<o:p></o:p></span></div></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"><br /></div></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"><span style="color: maroon; font-family: Consolas; font-size: 9.5pt;">.icon-cancel</span><span style="font-family: Consolas; font-size: 9.5pt;"> {<o:p></o:p></span></div></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"><span style="font-family: Consolas; font-size: 9.5pt;">    <span style="color: red;">background-image</span>: <span style="color: blue;">url(Images/Icon/back.png)</span>;<o:p></o:p></span></div></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"><span style="font-family: Consolas; font-size: 9.5pt;">    <span style="color: red;">background-position</span>: <span style="color: blue;">center</span> <span style="color: blue;">center</span>;<o:p></o:p></span></div></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"><span style="font-family: Consolas; font-size: 9.5pt;">    <span style="color: red;">height</span>: <span style="color: blue;">16px</span>;<o:p></o:p></span></div></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"><span style="font-family: Consolas; font-size: 9.5pt;">    <span style="color: red;">width</span>: <span style="color: blue;">16px</span>;</span></div></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"><span style="font-family: Consolas; font-size: 9.5pt;">}<o:p></o:p></span></div></div></div><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"><br />- <b>B4</b>: Tạo các thư mục Images trong thư mục Styles, và thư mục Icon trong thư mục Images vừa tạo.</div><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"><br /></div><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;">- <b>B5</b>: Download các biểu tượng và Copy chúng vào thư mục Icon.</div><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"><br /></div><div class="note-box"><div style="text-align: center;"><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;">Bạn có thể tải về Biểu tượng bằng cách nhấn vào liên kết tải về dưới đây</div><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"><br /></div><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"><a href="http://adf.ly/1GE8uu" imageanchor="1" style="margin-left: 1em; margin-right: 1em;" target="_blank"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjjSAl2gUQVs4bEjPlH2HNe2pqvJ0nbx90zxOlQxI2LaITC7vywa5VwUkAqSm53I7Eqoeuc_S91GCJoSKe_NLG_y2Hpi6k7VfQVtZeJ2Bz60O7uG18gMp_cUMMYOEfdhE6HLFhWDaJ1FAZF/w250-h57-no/Download.jpg" style="cursor: move;" /></a></div></div></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhwgyer-U_lKZMS26nQW6u-GnJWLhKjm1Lez8m_Otmm8OIbe02npUn6xXTzjFs5OFZUi8aEtCYMyjatcn4hYW77f6NULZd000cZR2bMz3a6sHdTEWYb61FCmBynlYrygAzbUKeQ11QcmRI/s1600/Project.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhwgyer-U_lKZMS26nQW6u-GnJWLhKjm1Lez8m_Otmm8OIbe02npUn6xXTzjFs5OFZUi8aEtCYMyjatcn4hYW77f6NULZd000cZR2bMz3a6sHdTEWYb61FCmBynlYrygAzbUKeQ11QcmRI/s1600/Project.gif" /></a></div><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;">- <b>B6</b>: Copy toàn bộ thư mục Bootstrap vừa Download vào Project.</div><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"><br /></div><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;">- <b>B7</b>: Mở File Site.Master nhúng thêm các css và js Bootstrap vào Project, sau khi chèn xong mã HTML có dạng.</div><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"><br /></div><div class="code" id="code"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: Consolas; font-size: 9.5pt;"><</span><span style="color: maroon; font-family: Consolas; font-size: 9.5pt;">head</span><span style="font-family: Consolas; font-size: 9.5pt;"> <span style="color: red;">runat</span><span style="color: blue;">="server"></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">    <span style="color: blue;"><</span><span style="color: maroon;">title</span><span style="color: blue;">></span>Bootsrap Tooltip<span style="color: blue;"></</span><span style="color: maroon;">title</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">    <span style="color: blue;"><</span><span style="color: maroon;">link</span> <span style="color: red;">href</span><span style="color: blue;">="~/Styles/Site.css"</span><span style="color: red;">rel</span><span style="color: blue;">="stylesheet"</span><span style="color: red;">type</span><span style="color: blue;">="text/css"</span><span style="color: blue;">/></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">    <span style="color: blue;"><</span><span style="color: maroon;">link</span> <span style="color: red;">href</span><span style="color: blue;">="~/bootstrap/css/bootstrap.css"</span><span style="color: red;">rel</span><span style="color: blue;">="stylesheet"</span><span style="color: red;">type</span><span style="color: blue;">="text/css"</span><span style="color: blue;">/></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">    <span style="color: blue;"><</span><span style="color: maroon;">link</span> <span style="color: red;">href</span><span style="color: blue;">="~/Styles/Button.css"</span><span style="color: red;">rel</span><span style="color: blue;">="stylesheet"</span><span style="color: red;">type</span><span style="color: blue;">="text/css"</span><span style="color: blue;">/></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">    <span style="color: blue;"><</span><span style="color: maroon;">script</span> <span style="color: red;">src</span><span style="color: blue;">="//ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></</span><span style="color: maroon;">script</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">    <span style="color: blue;"><</span><span style="color: maroon;">script</span> <span style="color: red;">src</span><span style="color: blue;">="//maxcdn.bootstrapcdn.com/bootstrap/3.2.0/js/bootstrap.min.js"></</span><span style="color: maroon;">script</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">    <span style="color: blue;"><</span><span style="color: maroon;">script</span> <span style="color: red;">type</span><span style="color: blue;">="text/javascript"></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        $(document).ready(<span style="color: blue;">function</span> () {<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            $(<span style="color: maroon;">'[data-toggle="tooltip"]'</span>).tooltip({<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            });<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        });<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">    <span style="color: blue;"></</span><span style="color: maroon;">script</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">    <span style="color: blue;"><</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">ContentPlaceHolder</span><span style="color: red;">ID</span><span style="color: blue;">="HeadContent"</span><span style="color: red;">runat</span><span style="color: blue;">="server"></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">    <span style="color: blue;"></</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">ContentPlaceHolder</span><span style="color: blue;">></span></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: Consolas; font-size: 9.5pt;"></</span><span style="color: maroon; font-family: Consolas; font-size: 9.5pt;">head</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">><o:p></o:p></span></div></div></div></div><br />- <b>B8</b>: Mở file Default.aspx nhập vào các mã HTML phía dưới. <br /><div class="code" id="code"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="background: yellow; font-family: Consolas; font-size: 9.5pt; mso-highlight: yellow;"><%</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">@</span><span style="font-family: Consolas; font-size: 9.5pt;"> <span style="color: maroon;">Page</span><span style="color: red;">Title</span><span style="color: blue;">="Home Page"</span> <span style="color: red;">Language</span><span style="color: blue;">="vb"</span> <span style="color: red;">MasterPageFile</span><span style="color: blue;">="~/Site.Master"</span> <span style="color: red;">AutoEventWireup</span><span style="color: blue;">="false"</span> <span style="color: red;">CodeBehind</span><span style="color: blue;">="Default.aspx.vb"</span> <span style="color: red;">Inherits</span><span style="color: blue;">="BootsrapTooltip._Default"</span> <span style="background: yellow; mso-highlight: yellow;">%></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: Consolas; font-size: 9.5pt;"><</span><span style="color: maroon; font-family: Consolas; font-size: 9.5pt;">asp</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">:</span><span style="color: maroon; font-family: Consolas; font-size: 9.5pt;">Content</span><span style="font-family: Consolas; font-size: 9.5pt;"> <span style="color: red;">ID</span><span style="color: blue;">="HeaderContent"</span> <span style="color: red;">runat</span><span style="color: blue;">="server"</span> <span style="color: red;">ContentPlaceHolderID</span><span style="color: blue;">="HeadContent"></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">    <o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: Consolas; font-size: 9.5pt;"></</span><span style="color: maroon; font-family: Consolas; font-size: 9.5pt;">asp</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">:</span><span style="color: maroon; font-family: Consolas; font-size: 9.5pt;">Content</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">></span><span style="font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: Consolas; font-size: 9.5pt;"><</span><span style="color: maroon; font-family: Consolas; font-size: 9.5pt;">asp</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">:</span><span style="color: maroon; font-family: Consolas; font-size: 9.5pt;">Content</span><span style="font-family: Consolas; font-size: 9.5pt;"> <span style="color: red;">ID</span><span style="color: blue;">="BodyContent"</span> <span style="color: red;">runat</span><span style="color: blue;">="server"</span> <span style="color: red;">ContentPlaceHolderID</span><span style="color: blue;">="MainContent"></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">    <span style="color: blue;"><</span><span style="color: maroon;">h2</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        Sử dụng Bootsrap Tooltip cho LinkButton trong Asp.net<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">    <span style="color: blue;"></</span><span style="color: maroon;">h2</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">    <span style="color: blue;"><</span><span style="color: maroon;">br</span> <span style="color: blue;">/></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">    <span style="color: blue;"><</span><span style="color: maroon;">div</span> <span style="color: red;">class</span><span style="color: blue;">="btn-group"></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;"><</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">LinkButton</span> <span style="color: red;">ID</span><span style="color: blue;">="cmdAddNew"</span><span style="color: red;">CssClass</span><span style="color: blue;">="btn"</span><span style="color: red;">CommandName</span><span style="color: blue;">="Add"</span><span style="color: red;">CausesValidation</span><span style="color: blue;">="true"</span><span style="color: red;">runat</span><span style="color: blue;">="server"</span><span style="color: red;">data-toggle</span><span style="color: blue;">="tooltip"</span><span style="color: red;">data-placement</span><span style="color: blue;">="top"</span><span style="color: red;">title</span><span style="color: blue;">="Add"></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;"><</span><span style="color: maroon;">i</span> <span style="color: red;">class</span><span style="color: blue;">="icon-add"></</span><span style="color: maroon;">i</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;"></</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">LinkButton</span><span style="color: blue;">></span><span style="color: red;">&nbsp;</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;"><</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">LinkButton</span> <span style="color: red;">ID</span><span style="color: blue;">="cmdUpdate"</span><span style="color: red;">CssClass</span><span style="color: blue;">="btn"</span><span style="color: red;">CommandName</span><span style="color: blue;">="Update"</span><span style="color: red;">CausesValidation</span><span style="color: blue;">="true"</span><span style="color: red;">runat</span><span style="color: blue;">="server"</span><span style="color: red;">data-toggle</span><span style="color: blue;">="tooltip"</span><span style="color: red;">data-placement</span><span style="color: blue;">="top"</span><span style="color: red;">title</span><span style="color: blue;">="Update"></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;"><</span><span style="color: maroon;">i</span> <span style="color: red;">class</span><span style="color: blue;">="icon-update"></</span><span style="color: maroon;">i</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;"></</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">LinkButton</span><span style="color: blue;">></span><span style="color: red;">&nbsp;</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;"><</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">LinkButton</span> <span style="color: red;">ID</span><span style="color: blue;">="cmdDelete"</span><span style="color: red;">CssClass</span><span style="color: blue;">="btn"</span><span style="color: red;">CommandName</span><span style="color: blue;">="Delete"</span><span style="color: red;">CausesValidation</span><span style="color: blue;">="false"</span><span style="color: red;">runat</span><span style="color: blue;">="server"</span><span style="color: red;">data-toggle</span><span style="color: blue;">="tooltip"</span><span style="color: red;">data-placement</span><span style="color: blue;">="top"</span><span style="color: red;">title</span><span style="color: blue;">="Delete"></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;"><</span><span style="color: maroon;">i</span> <span style="color: red;">class</span><span style="color: blue;">="icon-delete"></</span><span style="color: maroon;">i</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;"></</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">LinkButton</span><span style="color: blue;">></span><span style="color: red;">&nbsp;</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;"><</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">LinkButton</span> <span style="color: red;">ID</span><span style="color: blue;">="cmdCancel"</span><span style="color: red;">CssClass</span><span style="color: blue;">="btn"</span><span style="color: red;">CommandName</span><span style="color: blue;">="Cancel"</span><span style="color: red;">CausesValidation</span><span style="color: blue;">="false"</span><span style="color: red;">runat</span><span style="color: blue;">="server"</span><span style="color: red;">data-toggle</span><span style="color: blue;">="tooltip"</span><span style="color: red;">data-placement</span><span style="color: blue;">="top"</span><span style="color: red;">title</span><span style="color: blue;">="Cancel"></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;"><</span><span style="color: maroon;">i</span> <span style="color: red;">class</span><span style="color: blue;">="icon-cancel"></</span><span style="color: maroon;">i</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;"></</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">LinkButton</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">    <span style="color: blue;"></</span><span style="color: maroon;">div</span><span style="color: blue;">></span></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: Consolas; font-size: 9.5pt;"></</span><span style="color: maroon; font-family: Consolas; font-size: 9.5pt;">asp</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">:</span><span style="color: maroon; font-family: Consolas; font-size: 9.5pt;">Content</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">><o:p></o:p></span></div></div></div></div><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"><br /></div><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;">Bootsrap Tooltip cho phép người lập trình có thể thay đổi vị trí hiển thị Tooltip như: trên, dưới, trái, phải với các thuộc tính: <span style="color: red; font-family: Consolas; font-size: 9.5pt; line-height: 115%; text-align: justify;">data-placement</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt; line-height: 115%; text-align: justify;">="top", </span><span style="color: red; font-family: Consolas; font-size: 9.5pt; line-height: 115%; text-align: justify;">data-placement</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt; line-height: 115%; text-align: justify;">="bottom", </span><span style="color: red; font-family: Consolas; font-size: 9.5pt; line-height: 115%; text-align: justify;">data-placement</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt; line-height: 115%; text-align: justify;">="left", </span><span style="color: red; font-family: Consolas; font-size: 9.5pt; line-height: 115%; text-align: justify;">data-placement</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt; line-height: 115%; text-align: justify;">="right"</span><br /><div class="MsoNormal" style="text-align: justify;"><span style="font-family: Consolas; font-size: 9.5pt; line-height: 115%;"><o:p></o:p></span></div><br />Hoặc bạn cũng có thể thay đổi Css để Tooltip thực sự nổi bật.<br /><br />Ngoài ra bạn cũng có thể sử dụng Code để thêm Tooltip cho LinkButton với cú pháp như sau:<br /><br /><div class="code" id="code"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">Protected</span><span style="font-family: Consolas; font-size: 9.5pt;"> <span style="color: blue;">Sub</span> Page_Load(<span style="color: blue;">ByVal</span> sender <span style="color: blue;">As</span> <span style="color: blue;">Object</span>, <span style="color: blue;">ByVal</span> e <span style="color: blue;">As</span> System.<span style="color: #2b91af;">EventArgs</span>) <span style="color: blue;">Handles</span> <span style="color: blue;">Me</span>.Load<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">Try</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;">If</span> Page.IsPostBack = <span style="color: blue;">False</span> <span style="color: blue;">Then</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    <span style="color: blue;">Dim</span> sTooltip <span style="color: blue;">As</span><span style="color: blue;">String</span> = <span style="color: #a31515;">""</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    <span style="color: blue;">With</span> cmdAddNew<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                        sTooltip = <span style="color: #a31515;">"Add Record"</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                        .Attributes.Add(<span style="color: #a31515;">"data-toggle"</span>, <span style="color: #a31515;">"tooltip"</span>)<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                        <span style="color: green;">'Position</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                        .Attributes.Add(<span style="color: #a31515;">"data-placement"</span>, <span style="color: #a31515;">"top"</span>)<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                        <span style="color: green;">'Label</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                        .Attributes.Add(<span style="color: #a31515;">"data-original-title"</span>, sTooltip)<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    <span style="color: blue;">End</span> <span style="color: blue;">With</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;">End</span> <span style="color: blue;">If</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">Catch</span> ex <span style="color: blue;">As</span> <span style="color: #2b91af;">Exception</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">End</span> <span style="color: blue;">Try</span></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">End</span> <span style="color: blue;">Sub<o:p></o:p></span></span></div></div><br />Như vậy chúng ta đã hoàn thành việc tích hợp thư viện Bootstrap Tooltip vào Link Button của Asp.net rồi đó. Bây giờ chạy Project bạn sẽ có kết quả như ảnh phía dưới.</div><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"><br /></div><div style="clear: both; text-align: center;"><div style="float: left; margin: 6px 6px 0 6px; width: 280px;"><a href="http://adf.ly/1MkjmT" target="_blank"><img alt="Code Example C#, Code Example VB.NET" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiX5IGNs5gxA6HJ6wKUOVKQztkzufZYGTWmDGsjzESeAbw5gPpVperxnvMiiMPTFhfTdeeR-4kUkJSAALEa1Zdq5fGg0wgUcUViEOH5dYhX9XotYaD-DD8jE1pIm0L0ooHc0HY9SBYOeQw/s1600/CS_Code.png" /></a> </div><div style="float: left; margin: 6px 6px 0 6px; width: 280px;"><a href="http://adf.ly/1JrunN" target="_blank"><img alt="Code Example C#, Code Example VB.NET" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgulrYoUfYJfz40EKRawQ-iISxhV1T4-vVi8rbwkzWwWPOb5NPStwQVd3K3r6lWGkxR5-PlyV7SuGFcERHd7mBlFCaD_HCymi57mq0FBSJ9FMTOIyVXckid3Adhkoc8fUrFD8twfkZS1U8/s1600/VB_Code.png" /></a> </div></div><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"><br /></div><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"><br /><br />Chúc các bạn thành công!</div><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"><br /></div><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;">Quang Bình</div>

Sử dụng Bootsrap Tooltip cho Link Button trong Asp.net

( Bootsrap Tooltip cho Link Button ) - Trong quá trình xây dựng phần mềm, có những màn hình không đủ diện tích để thể hiện đầy đủ các Linkbu...

Read more »

Datepicker Using jQuery in Asp.net

<div style="text-align: justify;">(<b>jQuery DatePicker in Asp.net</b>) - jQuery là một Javascript Framework, một thư viện kiểu mới của Javascript hỗ trợ các nhà lập trình web tạo ra các tương tác động trên website. jQuery đơn giản hóa cách viết Javascript và tăng tốc độ xử lý các sự kiện trên trang web, giúp tiết kiệm thời gian và công sức rất nhiều so với việc ngồi viết javascript theo cách thông thường. Bài viết dưới đây sẽ hướng dẫn các bạn các sử dụng jQuery DatePicker trong Asp.net, với việc nhúng jQuery DatePicker vào các Textbox sẽ giúp người sử dụng chọn  nhanh ngày tháng trong quá trình nhập liệu.<br /><a name="more"></a></div><div style="text-align: center;"><b>Nghe những bài hát đỉnh nhất về Thấy cô giáo - <a href="https://www.youtube.com/watch?v=EXLGWIhgCx4&list=PL-dT-MN_dMzwvHPTb1hfqokY4b5RN_ngE" target="_blank">Nghe trên Youtube</a></b><br /><br /></div><iframe allowfullscreen="" frameborder="0" height="360" src="https://www.youtube.com/embed/videoseries?list=PL-dT-MN_dMzwvHPTb1hfqokY4b5RN_ngE&autoplay=1;loop=1&amp" width="640"></iframe><br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjVw_65inpLQ36AZ_wOMyPedS-6lzwNmTzH03ibE2N-euzD64O73mByEDJpISozgsE5GhKGKJ1BaAwN6RJI19g0cuWLec3vw2ByStjoiMEyl3N6Zm-cnV3TFcrUuEFyYrodf8CMZkYlCVk/s1600/ChangeYear.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjVw_65inpLQ36AZ_wOMyPedS-6lzwNmTzH03ibE2N-euzD64O73mByEDJpISozgsE5GhKGKJ1BaAwN6RJI19g0cuWLec3vw2ByStjoiMEyl3N6Zm-cnV3TFcrUuEFyYrodf8CMZkYlCVk/s1600/ChangeYear.png" /></a></div><div style="clear: both; text-align: center;"><div style="float: left; margin: 6px 6px 0 6px; width: 280px;"><a href="http://adf.ly/1Mkmcb" target="_blank"><img alt="Code Example C#, Code Example VB.NET" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiX5IGNs5gxA6HJ6wKUOVKQztkzufZYGTWmDGsjzESeAbw5gPpVperxnvMiiMPTFhfTdeeR-4kUkJSAALEa1Zdq5fGg0wgUcUViEOH5dYhX9XotYaD-DD8jE1pIm0L0ooHc0HY9SBYOeQw/s1600/CS_Code.png" /></a> </div><div style="float: left; margin: 6px 6px 0 6px; width: 280px;"><a href="http://adf.ly/1JrvYf" target="_blank"><img alt="Code Example C#, Code Example VB.NET" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgulrYoUfYJfz40EKRawQ-iISxhV1T4-vVi8rbwkzWwWPOb5NPStwQVd3K3r6lWGkxR5-PlyV7SuGFcERHd7mBlFCaD_HCymi57mq0FBSJ9FMTOIyVXckid3Adhkoc8fUrFD8twfkZS1U8/s1600/VB_Code.png" /></a> </div></div><br /><br /><br />- <b>B1</b>: Nhúng các thư viện jQuery<br /><div class="code" id="code"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: Consolas; font-size: 9.5pt;"><</span><span style="color: maroon; font-family: Consolas; font-size: 9.5pt;">script</span><span style="font-family: Consolas; font-size: 9.5pt;"> <span style="color: red;">src</span><span style="color: blue;">="http://ajax.googleapis.com/ajax/libs/jquery/1.6/jquery.min.js"</span> <span style="color: red;">type</span><span style="color: blue;">="text/javascript"></</span><span style="color: maroon;">script</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">    <span style="color: blue;"><</span><span style="color: maroon;">script</span> <span style="color: red;">src</span><span style="color: blue;">="http://ajax.googleapis.com/ajax/libs/jqueryui/1.8/jquery-ui.min.js"</span> <span style="color: red;">type</span><span style="color: blue;">="text/javascript"></</span><span style="color: maroon;">script</span><span style="color: blue;">></span></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">    <span style="color: blue;"><</span><span style="color: maroon;">link</span> <span style="color: red;">href</span><span style="color: blue;">="http://ajax.googleapis.com/ajax/libs/jqueryui/1.8/themes/base/jquery-ui.css"</span> <span style="color: red;">rel</span><span style="color: blue;">="Stylesheet"</span> <span style="color: red;">type</span><span style="color: blue;">="text/css"</span> <span style="color: blue;">/></span></span></div></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br />Bạn có thể nhúng các thư viện này vào trang Master hoặc trang có sử dụng jQuery DatePicker.</div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br />- <b>B2</b>: Viết mã Javasript và tạo Control Textbox sử dụng DatePicker</div><div class="code" id="code"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: Consolas; font-size: 9.5pt;"><</span><span style="color: maroon; font-family: Consolas; font-size: 9.5pt;">script</span><span style="font-family: Consolas; font-size: 9.5pt;"> <span style="color: red;">type</span><span style="color: blue;">="text/javascript"></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt; text-indent: 36pt;"><span style="font-family: Consolas; font-size: 9.5pt;">$(<span style="color: blue;">function</span> () {<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            $(<span style="color: maroon;">"[id$=txtDate]"</span>).datepicker({<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            });<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">       });<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;"> <span style="color: blue;"></</span><span style="color: maroon;">script</span><span style="color: blue;">><o:p></o:p></span></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: Consolas; font-size: 9.5pt;"><</span><span style="color: maroon; font-family: Consolas; font-size: 9.5pt;">asp</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">:</span><span style="color: maroon; font-family: Consolas; font-size: 9.5pt;">TextBox</span><span style="font-family: Consolas; font-size: 9.5pt;"> <span style="color: red;">ID</span><span style="color: blue;">="txtDate"</span> <span style="color: red;">runat</span><span style="color: blue;">="server"</span> <span style="color: red;">ReadOnly</span><span style="color: blue;">="true"></</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">TextBox</span><span style="color: blue;">></span></span></div></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;">- <b>B3</b>: Chạy Project và đặt chuột vào ô TextBox, hộp thoại ngày tháng xuất hiện và bây giờ ta chỉ cần chọn ngày tháng phù hợp.<br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhEuGUJWapKP1nFSj5cn67PrOgU6B6reuRSnFY5qQQytyum34h7SIk2sDbIryq19N9Qzn2SjLeZ97rSPMlsCqKUHYXo5rm0h2JKe9WQ40DRBl06OOF45_Qoy7ZO4r6vpGRgIXQa_ncI5l8/s1600/Default.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhEuGUJWapKP1nFSj5cn67PrOgU6B6reuRSnFY5qQQytyum34h7SIk2sDbIryq19N9Qzn2SjLeZ97rSPMlsCqKUHYXo5rm0h2JKe9WQ40DRBl06OOF45_Qoy7ZO4r6vpGRgIXQa_ncI5l8/s1600/Default.png" /></a></div>Với jQuery DatePicker, nó cung cấp cho người lập trình nhiều lựa chọn. Và với mỗi yêu cầu thực tế người lập trình có thể áp dụng các lựa chọn để giải quyết bài toán, dưới đây là các lựa chọn.<br /><br /><b>1. Cho phép chọn tháng, năm</b><br /><div class="code" id="code"><div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 18pt;"><span style="color: blue; font-family: Consolas; font-size: 9.5pt;"><</span><span style="color: maroon; font-family: Consolas; font-size: 9.5pt;">script</span><span style="font-family: Consolas; font-size: 9.5pt;"> <span style="color: red;">type</span><span style="color: blue;">="text/javascript"></span><o:p></o:p></span></div><div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 18pt; text-indent: 18pt;"><span style="font-family: Consolas; font-size: 9.5pt;">$(<span style="color: blue;">function</span> () {<o:p></o:p></span></div><div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 36pt; text-indent: 36pt;"><span style="font-family: Consolas; font-size: 9.5pt;">$(<span style="color: maroon;">"[id$=txtDate]"</span>).datepicker({<o:p></o:p></span></div><div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 72pt; text-indent: 36pt;"><span style="font-family: Consolas; font-size: 9.5pt;">dateFormat: <span style="color: maroon;">"dd-mm-yy"</span>,<o:p></o:p></span></div><div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 18pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                 changeMonth: <span style="color: blue;">true</span>,<o:p></o:p></span></div><div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 18pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                 changeYear: <span style="color: blue;">true</span><o:p></o:p></span></div><div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 18pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            });<o:p></o:p></span></div><div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 18pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        });</span></div><div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 18pt;"><span style="color: blue; font-family: Consolas; font-size: 9.5pt;"></</span><span style="color: maroon; font-family: Consolas; font-size: 9.5pt;">script</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">><o:p></o:p></span></div></div></div><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjVw_65inpLQ36AZ_wOMyPedS-6lzwNmTzH03ibE2N-euzD64O73mByEDJpISozgsE5GhKGKJ1BaAwN6RJI19g0cuWLec3vw2ByStjoiMEyl3N6Zm-cnV3TFcrUuEFyYrodf8CMZkYlCVk/s1600/ChangeYear.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjVw_65inpLQ36AZ_wOMyPedS-6lzwNmTzH03ibE2N-euzD64O73mByEDJpISozgsE5GhKGKJ1BaAwN6RJI19g0cuWLec3vw2ByStjoiMEyl3N6Zm-cnV3TFcrUuEFyYrodf8CMZkYlCVk/s1600/ChangeYear.png" /></a></div>Theo mặc định, datepicker sẽ không hiển thị danh sách năm và tháng để người sử dụng lựa chọn, nhưng với thuộc tính changeMonth: true và changeYear: true hộp thoại sẽ cho phép chọn tháng, năm.<br /><br /><b>2. Cho phép thiết lập khoảng thời gian năm</b><br /><div class="code" id="code"><div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 18pt;"><span style="color: blue; font-family: Consolas; font-size: 9.5pt;"><</span><span style="color: maroon; font-family: Consolas; font-size: 9.5pt;">script</span><span style="font-family: Consolas; font-size: 9.5pt;"> <span style="color: red;">type</span><span style="color: blue;">="text/javascript"></span><o:p></o:p></span></div><div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 18pt;"><span style="font-family: Consolas; font-size: 9.5pt;">      $(<span style="color: blue;">function</span>() {<o:p></o:p></span></div><div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 18pt;"><span style="font-family: Consolas; font-size: 9.5pt;">          $(<span style="color: maroon;">"[id$=txtDate]"</span>).datepicker({<o:p></o:p></span></div><div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 18pt;"><span style="font-family: Consolas; font-size: 9.5pt;">              dateFormat: <span style="color: maroon;">"dd-mm-yy"</span>,<o:p></o:p></span></div><div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 18pt;"><span style="font-family: Consolas; font-size: 9.5pt;">              inline: <span style="color: blue;">true</span>,<o:p></o:p></span></div><div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 18pt;"><span style="font-family: Consolas; font-size: 9.5pt;">              showAnim: <span style="color: maroon;">'fadeIn'</span>,<o:p></o:p></span></div><div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 18pt;"><span style="font-family: Consolas; font-size: 9.5pt;">              yearRange: <span style="color: maroon;">'1950:2025'</span>,<o:p></o:p></span></div><div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 18pt;"><span style="font-family: Consolas; font-size: 9.5pt;">              changeMonth: <span style="color: blue;">true</span>,<o:p></o:p></span></div><div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 18pt;"><span style="font-family: Consolas; font-size: 9.5pt;">              changeYear: <span style="color: blue;">true</span><o:p></o:p></span></div><div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 18pt;"><span style="font-family: Consolas; font-size: 9.5pt;">           });<o:p></o:p></span></div><div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 18pt;"><span style="font-family: Consolas; font-size: 9.5pt;">       });</span></div><div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 18pt;"><span style="font-family: Consolas; font-size: 9.5pt;">  <span style="color: blue;"></</span><span style="color: maroon;">script</span><span style="color: blue;">><o:p></o:p></span></span></div></div><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhs7Ko1DdCKCpdWb6eqroQwc9IrngkcyxNKPxU2zvJ95x4DzRx5yEyvYJTwKtr5iq_PN84Xzkqyhyphenhyphen_9861l4iiJX33Dk2lNzZHhf21T1ZXhcxC7Uuz6khm3gxcedcKWJz_wwKu8dHsR3Ko/s1600/YearRange.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhs7Ko1DdCKCpdWb6eqroQwc9IrngkcyxNKPxU2zvJ95x4DzRx5yEyvYJTwKtr5iq_PN84Xzkqyhyphenhyphen_9861l4iiJX33Dk2lNzZHhf21T1ZXhcxC7Uuz6khm3gxcedcKWJz_wwKu8dHsR3Ko/s1600/YearRange.png" /></a></div>Theo mặc định, datepicker hiển thị danh sách 20 năm, nhưng với lựa chọn này người lập trình có thể dễ dàng bổ xung thêm danh sách năm.<br /><br /><b>3. Không cho phép chọn thời gian lớn hơn (>) thời gian hiện tại</b><br /><div class="code" id="code"><div style="text-indent: 0px;"><span style="text-indent: 36pt;"><b>      </b></span><span style="color: blue; font-family: Consolas; font-size: 9.5pt; text-indent: 36pt;"><</span><span style="color: maroon; font-family: Consolas; font-size: 9.5pt; text-indent: 36pt;">script</span><span style="font-family: Consolas; font-size: 9.5pt; text-indent: 36pt;"> <span style="color: red;">type</span><span style="color: blue;">="text/javascript"></span></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        $(<span style="color: blue;">function</span> () {<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            $(<span style="color: maroon;">"[id$=txtDate]"</span>).datepicker({<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                dateFormat: <span style="color: maroon;">"dd-mm-yy"</span>,<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                inline: <span style="color: blue;">true</span>,<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                showAnim: <span style="color: maroon;">'fadeIn'</span>,<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                changeMonth: <span style="color: blue;">true</span>,<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                changeYear: <span style="color: blue;">true</span>,<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                maxDate:0<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            });<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        });</span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">    <span style="color: blue;"></</span><span style="color: maroon;">script</span><span style="color: blue;">><o:p></o:p></span></span></div></div><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg8fialEhjBNKIxJcRTphPlZIxZsdWhjBFqlb7Q1UD97If6rWg1TPBDvshogsWHl9Horg_Dmt49CyAiHFVADRruq9GSKwyY17tYbID42HgACI4atCi7tfMNviGuRyO5bfCKb4fRyKCOrbI/s1600/maxDate.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg8fialEhjBNKIxJcRTphPlZIxZsdWhjBFqlb7Q1UD97If6rWg1TPBDvshogsWHl9Horg_Dmt49CyAiHFVADRruq9GSKwyY17tYbID42HgACI4atCi7tfMNviGuRyO5bfCKb4fRyKCOrbI/s1600/maxDate.png" /></a></div>Hoặc không cho phép chọn thời gian lớn hơn (>) ngày cụ thể<br /><br /><div class="code" id="code"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: Consolas; font-size: 9.5pt;"><</span><span style="color: maroon; font-family: Consolas; font-size: 9.5pt;">script</span><span style="font-family: Consolas; font-size: 9.5pt;"> <span style="color: red;">type</span><span style="color: blue;">="text/javascript"></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        $(<span style="color: blue;">function</span> () {<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            $(<span style="color: maroon;">"[id$=txtDate]"</span>).datepicker({<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                dateFormat: <span style="color: maroon;">"dd-mm-yy"</span>,<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                inline: <span style="color: blue;">true</span>,<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                showAnim: <span style="color: maroon;">'fadeIn'</span>,<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                changeMonth: <span style="color: blue;">true</span>,<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                changeYear: <span style="color: blue;">true</span>,<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                maxDate: <span style="color: blue;">new</span> Date(<span style="color: maroon;">'2015/05/26'</span>)<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            });<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        });</span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">    <span style="color: blue;"></</span><span style="color: maroon;">script</span><span style="color: blue;">><o:p></o:p></span></span></div></div><br /><b>4. Không cho phép chọn thời gian nhỏ hơn (<) thời gian hiện tại</b><br /><div class="code" id="code"><div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 36pt;"><span style="color: blue; font-family: Consolas; font-size: 9.5pt;"><</span><span style="color: maroon; font-family: Consolas; font-size: 9.5pt;">script</span><span style="font-family: Consolas; font-size: 9.5pt;"> <span style="color: red;">type</span><span style="color: blue;">="text/javascript"></span><o:p></o:p></span></div><div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 36pt;"><span style="font-family: Consolas; font-size: 9.5pt;">     $(<span style="color: blue;">function</span>() {<o:p></o:p></span></div><div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 36pt;"><span style="font-family: Consolas; font-size: 9.5pt;">          $(<span style="color: maroon;">"[id$=txtDate_minDate]"</span>).datepicker({<o:p></o:p></span></div><div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 36pt;"><span style="font-family: Consolas; font-size: 9.5pt;">              dateFormat: <span style="color: maroon;">"dd-mm-yy"</span>,<o:p></o:p></span></div><div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 36pt;"><span style="font-family: Consolas; font-size: 9.5pt;">              inline: <span style="color: blue;">true</span>,<o:p></o:p></span></div><div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 36pt;"><span style="font-family: Consolas; font-size: 9.5pt;">              showAnim: <span style="color: maroon;">'fadeIn'</span>,<o:p></o:p></span></div><div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 36pt;"><span style="font-family: Consolas; font-size: 9.5pt;">              changeMonth: <span style="color: blue;">true</span>,<o:p></o:p></span></div><div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 36pt;"><span style="font-family: Consolas; font-size: 9.5pt;">              changeYear: <span style="color: blue;">true</span>,<o:p></o:p></span></div><div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 36pt;"><span style="font-family: Consolas; font-size: 9.5pt;">              minDate:0<o:p></o:p></span></div><div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 36pt;"><span style="font-family: Consolas; font-size: 9.5pt;">          });<o:p></o:p></span></div><div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 36pt;"><span style="font-family: Consolas; font-size: 9.5pt;">       });</span></div><div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 36pt;"><span style="font-family: Consolas; font-size: 9.5pt;">  <span style="color: blue;"></</span><span style="color: maroon;">script</span><span style="color: blue;">><o:p></o:p></span></span></div></div><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEib-UKm4As_-0IJD9HuJTcHbU8ItZv96bAMSwqLF-VBHPT29_gvrHfxLFXF68IcugLOMJYxiurjEbTnUNFMIfI96IVMrU_KgvcMGI1hlsjuoK2dHq_fJlRe7nTbfK29KlWzFpxByjg4OSA/s1600/minDate.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEib-UKm4As_-0IJD9HuJTcHbU8ItZv96bAMSwqLF-VBHPT29_gvrHfxLFXF68IcugLOMJYxiurjEbTnUNFMIfI96IVMrU_KgvcMGI1hlsjuoK2dHq_fJlRe7nTbfK29KlWzFpxByjg4OSA/s1600/minDate.png" /></a></div>Hoặc không cho phép chọn thời gian nhỏ hơn (<) ngày cụ thể<br /><br /><div class="code" id="code"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: Consolas; font-size: 9.5pt;"><</span><span style="color: maroon; font-family: Consolas; font-size: 9.5pt;">script</span><span style="font-family: Consolas; font-size: 9.5pt;"> <span style="color: red;">type</span><span style="color: blue;">="text/javascript"></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">      $(<span style="color: blue;">function</span> () {<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">          $(<span style="color: maroon;">"[id$=txtDate]"</span>).datepicker({<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                dateFormat: <span style="color: maroon;">"dd-mm-yy"</span>,<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                inline: <span style="color: blue;">true</span>,<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                showAnim: <span style="color: maroon;">'fadeIn'</span>,<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                changeMonth: <span style="color: blue;">true</span>,<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                changeYear: <span style="color: blue;">true</span>,<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                minDate: <span style="color: blue;">new</span> Date(<span style="color: maroon;">'2015/05/26'</span>)<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">           });<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">       });</span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;"> <span style="color: blue;"></</span><span style="color: maroon;">script</span><span style="color: blue;">><o:p></o:p></span></span></div></div><br /><b>5. Thiết lập thời gian mặc định</b><br /><div class="code" id="code">        <span style="color: blue; font-family: Consolas; font-size: 9.5pt;"><</span><span style="color: maroon; font-family: Consolas; font-size: 9.5pt;">script</span><span style="font-family: Consolas; font-size: 9.5pt;"> <span style="color: red;">type</span><span style="color: blue;">="text/javascript"></span></span><br /><div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 36pt;"><span style="font-family: Consolas; font-size: 9.5pt;">  $(<span style="color: blue;">function</span>() {<o:p></o:p></span></div><div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 36pt;"><span style="font-family: Consolas; font-size: 9.5pt;">       $(<span style="color: maroon;">"[id$=txtDate_DefaultDate]"</span>).datepicker({<o:p></o:p></span></div><div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 36pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            dateFormat: <span style="color: maroon;">"dd-mm-yy"</span>,<o:p></o:p></span></div><div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 36pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            inline: <span style="color: blue;">true</span>,<o:p></o:p></span></div><div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 36pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            showAnim: <span style="color: maroon;">'fadeIn'</span>,<o:p></o:p></span></div><div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 36pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            changeMonth: <span style="color: blue;">true</span>,<o:p></o:p></span></div><div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 36pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            changeYear: <span style="color: blue;">true</span>,<o:p></o:p></span></div><div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 36pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            defaultDate: -7<o:p></o:p></span></div><div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 36pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        });<o:p></o:p></span></div><div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 36pt;"><span style="font-family: Consolas; font-size: 9.5pt;">    });</span><br /><span style="color: blue; font-family: Consolas; font-size: 9.5pt;"></</span><span style="color: maroon; font-family: Consolas; font-size: 9.5pt;">script</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">></span></div></div><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj3XwBCKZJVp0dKw5M1UcpoWMg2UCnu0nSCABToe-Uj9n1wJBM5Mm4EPzEhBR-gJ0BtNsk8iAysRQ5d-RL35VJ-qymMFTFpcq09qcF5rTOlX0dGl6Yaim1d3iZDc6-0ohNapT4aYu3NuJY/s1600/DefaulDate.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj3XwBCKZJVp0dKw5M1UcpoWMg2UCnu0nSCABToe-Uj9n1wJBM5Mm4EPzEhBR-gJ0BtNsk8iAysRQ5d-RL35VJ-qymMFTFpcq09qcF5rTOlX0dGl6Yaim1d3iZDc6-0ohNapT4aYu3NuJY/s1600/DefaulDate.png" /></a></div><div style="clear: both; text-align: center;"><div style="float: left; margin: 6px 6px 0 6px; width: 280px;"><a href="http://adf.ly/1Mkmcb" target="_blank"><img alt="Code Example C#, Code Example VB.NET" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiX5IGNs5gxA6HJ6wKUOVKQztkzufZYGTWmDGsjzESeAbw5gPpVperxnvMiiMPTFhfTdeeR-4kUkJSAALEa1Zdq5fGg0wgUcUViEOH5dYhX9XotYaD-DD8jE1pIm0L0ooHc0HY9SBYOeQw/s1600/CS_Code.png" /></a> </div><div style="float: left; margin: 6px 6px 0 6px; width: 280px;"><a href="http://adf.ly/1JrvYf" target="_blank"><img alt="Code Example C#, Code Example VB.NET" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgulrYoUfYJfz40EKRawQ-iISxhV1T4-vVi8rbwkzWwWPOb5NPStwQVd3K3r6lWGkxR5-PlyV7SuGFcERHd7mBlFCaD_HCymi57mq0FBSJ9FMTOIyVXckid3Adhkoc8fUrFD8twfkZS1U8/s1600/VB_Code.png" /></a> </div></div><br /><br /><br />Chúc các bạn thành công!<br /><br />Quang Bình

Datepicker Using jQuery in Asp.net

( jQuery DatePicker in Asp.net ) - jQuery là một Javascript Framework, một thư viện kiểu mới của Javascript hỗ trợ các nhà lập trình web tạo...

Read more »

Export danh sách dữ liệu (Datatable) ra Excel trong Asp.net

<div style="text-align: justify;">(<b>Export dữ liệu trong Asp.net ra Excel</b>) – Việc cho phép xuất dữ liệu ra Excel sẽ người dùng dễ dàng, thuận tiện và chủ động trong việc căn chỉnh, điều chỉnh, bổ xung định dạng cũng như thông tin. Do vậy lựa chọn Export danh sách dữ liệu ra file Excel luôn là lựa chọn hàng đầu đối với người dùng.<br /><a name="more"></a><br /><div style="text-align: center;"><b>Nghe những bài hát đỉnh nhất về Thấy cô giáo - <a href="https://www.youtube.com/watch?v=EXLGWIhgCx4&list=PL-dT-MN_dMzwvHPTb1hfqokY4b5RN_ngE" target="_blank">Nghe trên Youtube</a></b><br /><br /></div><iframe allowfullscreen="" frameborder="0" height="360" src="https://www.youtube.com/embed/videoseries?list=PL-dT-MN_dMzwvHPTb1hfqokY4b5RN_ngE&autoplay=1;loop=1&amp" width="640"></iframe><br /><br />Bài viết dưới đây, thủ thuật tin học sẽ giới thiệu với các bạn cách Export toàn bộ danh sách dữ liệu ra file Excel. </div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgFPO8WjXUGe6UpH-_RRQgeQV4Aq-kG1vziV0E3nHn0fSa36SK4UyhuueZeqP0c698HRxI-_T8ZcgG729gvOBQgOZYAmnMynUgdN5bBl8ResxAWAEutQgAPhBSiL9uW1dvrAwBLejZhhfw/s1600/Excel.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgFPO8WjXUGe6UpH-_RRQgeQV4Aq-kG1vziV0E3nHn0fSa36SK4UyhuueZeqP0c698HRxI-_T8ZcgG729gvOBQgOZYAmnMynUgdN5bBl8ResxAWAEutQgAPhBSiL9uW1dvrAwBLejZhhfw/s1600/Excel.png" width="550px" /></a></div><div style="clear: both; text-align: center;"><div style="float: left; margin: 6px 6px 0 6px; width: 280px;"><a href="http://adf.ly/1MlCQ3" target="_blank"><img alt="Code Example C#, Code Example VB.NET" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiX5IGNs5gxA6HJ6wKUOVKQztkzufZYGTWmDGsjzESeAbw5gPpVperxnvMiiMPTFhfTdeeR-4kUkJSAALEa1Zdq5fGg0wgUcUViEOH5dYhX9XotYaD-DD8jE1pIm0L0ooHc0HY9SBYOeQw/s1600/CS_Code.png" /></a> </div><div style="float: left; margin: 6px 6px 0 6px; width: 280px;"><a href="http://adf.ly/1JryIT" target="_blank"><img alt="Code Example C#, Code Example VB.NET" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgulrYoUfYJfz40EKRawQ-iISxhV1T4-vVi8rbwkzWwWPOb5NPStwQVd3K3r6lWGkxR5-PlyV7SuGFcERHd7mBlFCaD_HCymi57mq0FBSJ9FMTOIyVXckid3Adhkoc8fUrFD8twfkZS1U8/s1600/VB_Code.png" /></a> </div></div><br /><br /><br />- <b>B1</b>: Tạo CSDL SQL <b>Customers</b><br /><br />- <b>B2</b>: Tạo Bảng <b>Accounts </b>có cấu trúc phía dưới trong CSDL SQL Server<br /><br /><table border="1" bordercolor="#cccccc" cellpadding="3" cellspacing="1" style="border-collapse: collapse; width: 100%px;"><tbody><tr><td align="center" style="width: 31px;"><b>STT</b></td><td align="center" style="width: 159px;"><b>Tên trường</b></td><td align="center" style="width: 108px;"><b>Kiểu trường</b></td><td align="center"><b>Ghi chú</b></td></tr><tr><td align="center">1</td><td>AccountID</td><td>Int</td><td>Trường tự tăng</td></tr><tr><td align="center">2</td><td>AccountCode</td><td>nvarchar(25)</td><td><br /></td></tr><tr><td align="center">3</td><td>AccName</td><td>nvarchar(250)</td><td><br /></td></tr><tr><td align="center">4</td><td>AccAddress</td><td>nvarchar(250)</td><td><br /></td></tr><tr><td align="center">5</td><td>AccPhone</td><td>nvarchar(50)</td><td><br /></td></tr><tr><td align="center">6</td><td>AccFAX</td><td>nvarchar(50)</td><td><br /></td></tr><tr><td align="center">7</td><td>AccEmail</td><td>nvarchar(50)</td><td><br /></td></tr><tr><td align="center">8</td><td>AccWebsite</td><td>nvarchar(150)</td><td><br /></td></tr><tr><td align="center">9</td><td>AccDesc</td><td>nvarchar(1500)</td><td><br /></td></tr><tr><td align="center">10</td><td>CreatedDate</td><td>datetime</td><td><br /></td></tr><tr><td align="center">11</td><td>ModifiedDate</td><td>datetime</td><td><br /></td></tr></tbody></table><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhzXE5YsJg_7IR8DKCbENmVnkP_Mwqsb14BV3ERr-E2x3tNcRqE8FRpjY3I92Pz6_uMMGHUHbxePTDLHcoDn5PSlV7sdtgo2ZuJ9bCDV9KX_5K2fIN-Pps_TrX2QOLc1fMT3j8AbpN676Y/s1600/Table.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhzXE5YsJg_7IR8DKCbENmVnkP_Mwqsb14BV3ERr-E2x3tNcRqE8FRpjY3I92Pz6_uMMGHUHbxePTDLHcoDn5PSlV7sdtgo2ZuJ9bCDV9KX_5K2fIN-Pps_TrX2QOLc1fMT3j8AbpN676Y/s1600/Table.png" /></a></div><div class="separator" style="clear: both; text-align: center;"></div><br />- <b>B3</b>: Nhập dữ liệu cho bảng <b>Accounts</b><br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjQAcxX_1V7fj2wsDjW2o30HCdoWBBFVPgpibKlNq1gJ3zCeO0LXLH9SVLrAu6N74hoB-RANohC1HCPJHW75qvXLnRUbfHQQdmLL5M6LRYLt_iQAnSCyv-CSirmCGUIm0ljr0p_bfoZnQc/s1600/Data.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjQAcxX_1V7fj2wsDjW2o30HCdoWBBFVPgpibKlNq1gJ3zCeO0LXLH9SVLrAu6N74hoB-RANohC1HCPJHW75qvXLnRUbfHQQdmLL5M6LRYLt_iQAnSCyv-CSirmCGUIm0ljr0p_bfoZnQc/s1600/Data.png" width="550px" /></a></div><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"></div><br />- <b>B4</b>: Tạo các stored procedure trong SQL Server<br /><br /><div class="code" id="code"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">USE</span><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;"> [Customers]<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">GO<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">CREATE</span><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;"> <span style="color: blue;">PROCEDURE</span> [dbo]<span style="color: grey;">.</span>[Pro_Accounts_Get]<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">      @AccountID <span style="color: blue;">int<o:p></o:p></span></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">AS<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">SELECT</span><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;"> <span style="color: grey;">*</span> <span style="color: blue;">FROM</span> Accounts<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">WHERE<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">      AccountID <span style="color: grey;">=</span> @AccountID<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">Go<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">CREATE</span><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;"> <span style="color: blue;">PROCEDURE</span> [dbo]<span style="color: grey;">.</span>[Pro_Accounts_List]<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">      @Keyword <span style="color: blue;">nvarchar</span><span style="color: grey;">(</span>250<span style="color: grey;">),<o:p></o:p></span></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">      @SortField <span style="color: blue;">nvarchar</span><span style="color: grey;">(</span>50<span style="color: grey;">),<o:p></o:p></span></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">      @SortType <span style="color: blue;">nvarchar</span><span style="color: grey;">(</span>10<span style="color: grey;">)<o:p></o:p></span></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">AS<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">declare</span><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;"> @strSQL   <span style="color: blue;">nvarchar</span><span style="color: grey;">(</span>1000<span style="color: grey;">)<o:p></o:p></span></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">declare</span><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;"> @strWhere <span style="color: blue;">nvarchar</span><span style="color: grey;">(</span>500<span style="color: grey;">)<o:p></o:p></span></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">declare</span><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;"> @strOrder <span style="color: blue;">nvarchar</span> <span style="color: grey;">(</span>50<span style="color: grey;">)<o:p></o:p></span></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">set</span><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;"> @strSQL<span style="color: grey;">=</span> <span style="color: red;">'Select * from Accounts'<o:p></o:p></span></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">set</span><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;"> @strWhere <span style="color: grey;">=</span><span style="color: red;">' Where 1=1 '<o:p></o:p></span></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">if</span><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;"> @Keyword<span style="color: grey;"><></span><span style="color: red;">''<o:p></o:p></span></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">      <span style="color: blue;">set</span> @strWhere<span style="color: grey;">=</span> @strWhere  <span style="color: grey;">+</span><span style="color: red;">' And (AccountCode like N''%'</span> <span style="color: grey;">+</span>@Keyword<span style="color: grey;">+</span><span style="color: red;">'%''<o:p></o:p></span></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: red; font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">            Or AccName like N''%'</span><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;"> <span style="color: grey;">+</span>@Keyword<span style="color: grey;">+</span><span style="color: red;">'%'' Or AccAddress like N''%'</span> <span style="color: grey;">+</span>@Keyword<span style="color: grey;">+</span><span style="color: red;">'%''<o:p></o:p></span></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: red; font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">            Or AccPhone like N''%'</span><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;"> <span style="color: grey;">+</span>@Keyword<span style="color: grey;">+</span><span style="color: red;">'%'' Or AccFAX like N''%'</span> <span style="color: grey;">+</span>@Keyword<span style="color: grey;">+</span><span style="color: red;">'%''<o:p></o:p></span></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: red; font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">            Or AccEmail like N''%'</span><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;"> <span style="color: grey;">+</span>@Keyword<span style="color: grey;">+</span><span style="color: red;">'%'' Or AccWebsite like N''%'</span> <span style="color: grey;">+</span>@Keyword<span style="color: grey;">+</span><span style="color: red;">'%'')'<o:p></o:p></span></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">if</span><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;"> @SortField<span style="color: grey;">=</span><span style="color: red;">'CreatedDate'<o:p></o:p></span></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">      <span style="color: blue;">Begin<o:p></o:p></span></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">            <span style="color: blue;">set</span> @strOrder <span style="color: grey;">=</span><span style="color: red;">' Order by CreatedDate'<o:p></o:p></span></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">      <span style="color: blue;">End<o:p></o:p></span></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">Else<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">      <span style="color: blue;">Begin<o:p></o:p></span></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">            <span style="color: blue;">set</span> @strOrder <span style="color: grey;">=</span><span style="color: red;">' Order by AccName'<o:p></o:p></span></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">      <span style="color: blue;">End<o:p></o:p></span></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">set</span><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;"> @strSQL<span style="color: grey;">=</span>@strSQL<span style="color: grey;">+</span>@strWhere<span style="color: grey;">+</span>@strOrder<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">print</span><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;"> @strSQL<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">exec</span><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;"> <span style="color: maroon;">sp_executesql</span> @strSQL</span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">Go</span></div></div></div><br /><div class="note-box"><div style="text-align: center;">Bạn có thể tải về bảng cơ sở dữ liệu SQL bằng cách nhấn vào liên kết tải về dưới đây<br /><a href="http://adf.ly/1JreJR" imageanchor="1" style="margin-left: 1em; margin-right: 1em;" target="_blank"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjjSAl2gUQVs4bEjPlH2HNe2pqvJ0nbx90zxOlQxI2LaITC7vywa5VwUkAqSm53I7Eqoeuc_S91GCJoSKe_NLG_y2Hpi6k7VfQVtZeJ2Bz60O7uG18gMp_cUMMYOEfdhE6HLFhWDaJ1FAZF/w250-h57-no/Download.jpg" /></a></div></div><br />- <b>B5</b>: Tạo Project trong Microsoft Visual Studio 2010<br />Trong Visual Studio tạo 1 Class có tên: Utility và nhập đoạn Code phía dưới cho Class này.<br /><br /><div class="code" id="code"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">Imports</span><span style="font-family: Consolas; font-size: 9.5pt;"> System.Data.SqlClient<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">Imports</span><span style="font-family: Consolas; font-size: 9.5pt;"> System.Data<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">Namespace</span><span style="font-family: Consolas; font-size: 9.5pt;"> ExportDatatableToExcel<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">    <span style="color: blue;">Public</span> <span style="color: blue;">Class</span> <span style="color: #2b91af;">SqlDataProvider</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">#Region</span><span style="font-family: Consolas; font-size: 9.5pt;"> <span style="color: #a31515;">"Membres Prives"</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">Shared</span> _IsError <span style="color: blue;">As</span> <span style="color: blue;">Boolean</span> = <span style="color: blue;">False</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">Private</span> _connectionString <span style="color: blue;">As</span><span style="color: blue;">String</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">#End</span><span style="font-family: Consolas; font-size: 9.5pt;"> <span style="color: blue;">Region</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">#Region</span><span style="font-family: Consolas; font-size: 9.5pt;"> <span style="color: #a31515;">"Constructeurs"</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">Public</span> <span style="color: blue;">Sub</span> <span style="color: blue;">New</span>()<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">Try</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                _connectionString = <span style="color: #2b91af;">ConfigurationManager</span>.ConnectionStrings(<span style="color: #a31515;">"SiteSqlServer"</span>).ConnectionString<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                _IsError = <span style="color: blue;">False</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">Catch</span> ex <span style="color: blue;">As</span> <span style="color: #2b91af;">Exception</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                _IsError = <span style="color: blue;">True</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">End</span> <span style="color: blue;">Try</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">End</span> <span style="color: blue;">Sub</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">#End</span><span style="font-family: Consolas; font-size: 9.5pt;"> <span style="color: blue;">Region</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">#Region</span><span style="font-family: Consolas; font-size: 9.5pt;"> <span style="color: #a31515;">"Proprietes"</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">Public</span> <span style="color: blue;">ReadOnly</span> <span style="color: blue;">Property</span> ConnectionString() <span style="color: blue;">As</span><span style="color: blue;">String</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">Get</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;">Return</span> _connectionString<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">End</span> <span style="color: blue;">Get</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">End</span> <span style="color: blue;">Property</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">#End</span><span style="font-family: Consolas; font-size: 9.5pt;"> <span style="color: blue;">Region</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">#Region</span><span style="font-family: Consolas; font-size: 9.5pt;"> <span style="color: #a31515;">"Functions"</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">Public</span> <span style="color: blue;">Function</span>FillTable(<span style="color: blue;">ByVal</span> sql <span style="color: blue;">As</span><span style="color: blue;">String</span>) <span style="color: blue;">As</span> <span style="color: #2b91af;">DataTable</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">Try</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;">Dim</span> tb <span style="color: blue;">As</span><span style="color: blue;">New</span> <span style="color: #2b91af;">DataTable</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;">Dim</span> adap <span style="color: blue;">As</span><span style="color: blue;">New</span> <span style="color: #2b91af;">SqlDataAdapter</span>(sql, _connectionString)<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                adap.Fill(tb)<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;">Return</span> tb<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">Catch</span> ex <span style="color: blue;">As</span> <span style="color: #2b91af;">Exception</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;">Return</span> <span style="color: blue;">Nothing</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">End</span> <span style="color: blue;">Try</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">End</span> <span style="color: blue;">Function</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">Public</span> <span style="color: blue;">Function</span>FillTable(<span style="color: blue;">ByVal</span> ProcName <span style="color: blue;">As</span> <span style="color: blue;">String</span>, <span style="color: blue;">ByVal</span> <span style="color: blue;">ParamArray</span>Para() <span style="color: blue;">As</span> <span style="color: #2b91af;">ObjectPara</span>) <span style="color: blue;">As</span> <span style="color: #2b91af;">DataTable</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">Try</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;">Dim</span> tb <span style="color: blue;">As</span><span style="color: blue;">New</span> <span style="color: #2b91af;">DataTable</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;">Dim</span> adap <span style="color: blue;">As</span><span style="color: blue;">New</span> <span style="color: #2b91af;">SqlDataAdapter</span>(ProcName, _connectionString)<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                adap.SelectCommand.CommandType = <span style="color: #2b91af;">CommandType</span>.StoredProcedure<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;">If</span> <span style="color: blue;">Not</span>Para <span style="color: blue;">Is</span> <span style="color: blue;">Nothing</span><span style="color: blue;">Then</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    <span style="color: blue;">For</span> <span style="color: blue;">Each</span>p <span style="color: blue;">As</span> <span style="color: #2b91af;">ObjectPara</span><span style="color: blue;">In</span> Para<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                        adap.SelectCommand.Parameters.Add(<span style="color: blue;">New</span> <span style="color: #2b91af;">SqlParameter</span>(p.Name, p.Value))<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    <span style="color: blue;">Next</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;">End</span> <span style="color: blue;">If</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                adap.Fill(tb)<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;">Return</span> tb<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">Catch</span> ex <span style="color: blue;">As</span> <span style="color: #2b91af;">Exception</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;">Return</span> <span style="color: blue;">Nothing</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">End</span> <span style="color: blue;">Try</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">End</span> <span style="color: blue;">Function</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">Public</span> <span style="color: blue;">Function</span>RunSQL(<span style="color: blue;">ByVal</span> ProcName <span style="color: blue;">As</span><span style="color: blue;">String</span>, <span style="color: blue;">ByVal</span> <span style="color: blue;">ParamArray</span> Para() <span style="color: blue;">As</span> <span style="color: #2b91af;">ObjectPara</span>) <span style="color: blue;">As</span> <span style="color: blue;">Object</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">Try</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;">Dim</span> _cnn <span style="color: blue;">As</span><span style="color: blue;">New</span> <span style="color: #2b91af;">SqlConnection</span>(_connectionString)<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                _cnn.Open()<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;">Dim</span> cmd <span style="color: blue;">As</span><span style="color: blue;">New</span> <span style="color: #2b91af;">SqlCommand</span>(ProcName, _cnn)<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                cmd.CommandType = <span style="color: #2b91af;">CommandType</span>.StoredProcedure<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;">For</span> <span style="color: blue;">Each</span>p <span style="color: blue;">As</span> <span style="color: #2b91af;">ObjectPara</span><span style="color: blue;">In</span> Para<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    cmd.Parameters.Add(<span style="color: blue;">New</span> <span style="color: #2b91af;">SqlParameter</span>(p.Name, p.Value))<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;">Next</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;">Return</span> cmd.ExecuteScalar<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">Catch</span> ex <span style="color: blue;">As</span> <span style="color: #2b91af;">Exception</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;">Return</span> <span style="color: blue;">Nothing</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">End</span> <span style="color: blue;">Try</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">End</span> <span style="color: blue;">Function</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">Public</span> <span style="color: blue;">Function</span>GetRow(<span style="color: blue;">ByVal</span> ProcName <span style="color: blue;">As</span><span style="color: blue;">String</span>, <span style="color: blue;">ByVal</span> <span style="color: blue;">ParamArray</span> Para() <span style="color: blue;">As</span> <span style="color: #2b91af;">ObjectPara</span>) <span style="color: blue;">As</span> <span style="color: #2b91af;">DataRow</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">Try</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;">Dim</span> tb <span style="color: blue;">As</span><span style="color: blue;">New</span> <span style="color: #2b91af;">DataTable</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;">Dim</span> adap <span style="color: blue;">As</span><span style="color: blue;">New</span> <span style="color: #2b91af;">SqlDataAdapter</span>(ProcName, _connectionString)<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                adap.SelectCommand.CommandType = <span style="color: #2b91af;">CommandType</span>.StoredProcedure<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;">For</span> <span style="color: blue;">Each</span>p <span style="color: blue;">As</span> <span style="color: #2b91af;">ObjectPara</span><span style="color: blue;">In</span> Para<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    adap.SelectCommand.Parameters.Add(<span style="color: blue;">New</span> <span style="color: #2b91af;">SqlParameter</span>(p.Name, p.Value))<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;">Next</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                adap.Fill(tb)<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;">If</span> tb.Rows.Count <span style="color: blue;">Then</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    <span style="color: blue;">Return</span> tb.Rows(0)<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;">End</span> <span style="color: blue;">If</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">Catch</span> ex <span style="color: blue;">As</span> <span style="color: #2b91af;">Exception</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;">Return</span> <span style="color: blue;">Nothing</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">End</span> <span style="color: blue;">Try</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">Return</span> <span style="color: blue;">Nothing</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">End</span> <span style="color: blue;">Function</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">#End</span><span style="font-family: Consolas; font-size: 9.5pt;"> <span style="color: blue;">Region</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">    <span style="color: blue;">End</span> <span style="color: blue;">Class</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">    <span style="color: blue;">Public</span> <span style="color: blue;">Class</span> <span style="color: #2b91af;">ObjectPara</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">Dim</span> _name <span style="color: blue;">As</span> <span style="color: blue;">String</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">Dim</span> _Value <span style="color: blue;">As</span> <span style="color: blue;">Object</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">Sub</span> <span style="color: blue;">New</span>(<span style="color: blue;">ByVal</span> Pname <span style="color: blue;">As</span> <span style="color: blue;">String</span>, <span style="color: blue;">ByVal</span> PValue <span style="color: blue;">As</span> <span style="color: blue;">Object</span>)<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            _name = Pname<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            _Value = PValue<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">End</span> <span style="color: blue;">Sub</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">Public</span> <span style="color: blue;">Property</span>Name() <span style="color: blue;">As</span> <span style="color: blue;">String</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">Get</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;">Return</span> _name<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">End</span> <span style="color: blue;">Get</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">Set</span>(<span style="color: blue;">ByVal</span> value <span style="color: blue;">As</span> <span style="color: blue;">String</span>)<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                _name = value<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">End</span> <span style="color: blue;">Set</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">End</span> <span style="color: blue;">Property</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">Public</span> <span style="color: blue;">Property</span>Value() <span style="color: blue;">As</span> <span style="color: blue;">Object</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">Get</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;">Return</span> _Value<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">End</span> <span style="color: blue;">Get</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">Set</span>(<span style="color: blue;">ByVal</span> value <span style="color: blue;">As</span> <span style="color: blue;">Object</span>)<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                _Value = value<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">End</span> <span style="color: blue;">Set</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">End</span> <span style="color: blue;">Property</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">    <span style="color: blue;">End</span> <span style="color: blue;">Class</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">    <span style="color: blue;">Public</span> <span style="color: blue;">Class</span> <span style="color: #2b91af;">MyEventArgs</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">Inherits</span> <span style="color: #2b91af;">EventArgs</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">Private</span> Name <span style="color: blue;">As</span> <span style="color: blue;">String</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">Private</span> MyId <span style="color: blue;">As</span> <span style="color: blue;">String</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">Public</span> <span style="color: blue;">Property</span>SelectedName() <span style="color: blue;">As</span> <span style="color: blue;">String</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">Get</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;">Return</span> Name<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">End</span> <span style="color: blue;">Get</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">Set</span>(<span style="color: blue;">ByVal</span> value <span style="color: blue;">As</span> <span style="color: blue;">String</span>)<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                Name = value<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">End</span> <span style="color: blue;">Set</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">End</span> <span style="color: blue;">Property</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">Public</span> <span style="color: blue;">Property</span> Id() <span style="color: blue;">As</span> <span style="color: blue;">String</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">Get</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;">Return</span> MyId<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">End</span> <span style="color: blue;">Get</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">Set</span>(<span style="color: blue;">ByVal</span> value <span style="color: blue;">As</span> <span style="color: blue;">String</span>)<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                MyId = value<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">End</span> <span style="color: blue;">Set</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">End</span> <span style="color: blue;">Property</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">    <span style="color: blue;">End</span> <span style="color: blue;">Class</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">End</span><span style="font-family: Consolas; font-size: 9.5pt;"> <span style="color: blue;">Namespace<o:p></o:p></span></span></div></div></div></div></div><br />Chú ý: Thuộc tính SiteSqlServer chính là chuỗi Connect với SQL Server trong file Web.Config<br /><br />- <b>B6</b>: Download các file ảnh <a href="http://www.mediafire.com/download/5bp16px8ty9leo8/ExportToExcelFromDataTable_Images.rar" target="_blank">tại đây</a>, Copy ảnh lần lượt vào các thư mục Images<br /><br />+ delete.gif, icon_search.gif vào thư mục Images<br />+ no.png, yes.png, sprite.png, lt.gif,  icon_excel.png vào thư mục  Styles\Images<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjX6VF4PYyf3n25U7GfSqbd2JysKOgpHljvPapZmL9bDjSExdwmqzIGOmNBSfLLL6nE0kXxvrunqeGB017n9KkIgK_bClUBhEToxWVX89NMaT-0N61NkLfmnMRyfDlcEvINYMud_A8WkyM/s1600/Project.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjX6VF4PYyf3n25U7GfSqbd2JysKOgpHljvPapZmL9bDjSExdwmqzIGOmNBSfLLL6nE0kXxvrunqeGB017n9KkIgK_bClUBhEToxWVX89NMaT-0N61NkLfmnMRyfDlcEvINYMud_A8WkyM/s1600/Project.png" /></a></div><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"></div><br />- <b>B7</b>: Mở file Default.aspxdưới dạng HTML và  nhập mã HTML<br /><div class="code" id="code"><br /><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="background: yellow; font-family: Consolas; font-size: 9.5pt; mso-highlight: yellow;"><%</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">@</span><span style="font-family: Consolas; font-size: 9.5pt;"> <span style="color: maroon;">Page</span><span style="color: red;">Title</span><span style="color: blue;">="Export Datatable To Excel in ASP.Net"</span> <span style="color: red;">Language</span><span style="color: blue;">="vb"</span> <span style="color: red;">MasterPageFile</span><span style="color: blue;">="~/Site.Master"</span> <span style="color: red;">AutoEventWireup</span><span style="color: blue;">="false"</span> <span style="color: red;">CodeBehind</span><span style="color: blue;">="Default.aspx.vb"</span> <span style="color: red;">Inherits</span><span style="color: blue;">="ExportDatatableToExcel._Default"</span> <span style="background: yellow; mso-highlight: yellow;">%></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="background: yellow; font-family: Consolas; font-size: 9.5pt; mso-highlight: yellow;"><%</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">@</span><span style="font-family: Consolas; font-size: 9.5pt;"> <span style="color: maroon;">Register</span><span style="color: red;">TagPrefix</span><span style="color: blue;">="ModalPopup"</span><span style="color: red;">TagName</span><span style="color: blue;">="ViewRecord"</span><span style="color: red;">Src</span><span style="color: blue;">="~/UserControls/Popup_ViewRecord.ascx"</span><span style="background: yellow; mso-highlight: yellow;">%></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="background: yellow; font-family: Consolas; font-size: 9.5pt; mso-highlight: yellow;"><%</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">@</span><span style="font-family: Consolas; font-size: 9.5pt;"> <span style="color: maroon;">Register</span><span style="color: red;">TagPrefix</span><span style="color: blue;">="ModalPopup"</span><span style="color: red;">TagName</span><span style="color: blue;">="Delete"</span><span style="color: red;">Src</span><span style="color: blue;">="~/UserControls/Popup_ConfirmDelete.ascx"</span><span style="background: yellow; mso-highlight: yellow;">%></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: Consolas; font-size: 9.5pt;"><</span><span style="color: maroon; font-family: Consolas; font-size: 9.5pt;">asp</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">:</span><span style="color: maroon; font-family: Consolas; font-size: 9.5pt;">Content</span><span style="font-family: Consolas; font-size: 9.5pt;"> <span style="color: red;">ID</span><span style="color: blue;">="BodyContent"</span> <span style="color: red;">runat</span><span style="color: blue;">="server"</span> <span style="color: red;">ContentPlaceHolderID</span><span style="color: blue;">="MainContent"></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">    <span style="color: blue;"><</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">ScriptManager</span> <span style="color: red;">ID</span><span style="color: blue;">="ScriptManager1"</span><span style="color: red;">runat</span><span style="color: blue;">="server"></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">    <span style="color: blue;"></</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">ScriptManager</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">    <span style="color: blue;"><</span><span style="color: maroon;">h1</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        Export Datatable To Excel in ASP.Net<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">    <span style="color: blue;"></</span><span style="color: maroon;">h1</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">    <span style="color: blue;"><</span><span style="color: maroon;">br</span> <span style="color: blue;">/></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">    <span style="color: blue;"><</span><span style="color: maroon;">ModalPopup</span><span style="color: blue;">:</span><span style="color: maroon;">ViewRecord</span> <span style="color: red;">ID</span><span style="color: blue;">="ucViewRecord"</span><span style="color: red;">runat</span><span style="color: blue;">="server"</span><span style="color: blue;">/></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">    <span style="color: blue;"><</span><span style="color: maroon;">ModalPopup</span><span style="color: blue;">:</span><span style="color: maroon;">Delete</span> <span style="color: red;">ID</span><span style="color: blue;">="ucDeleteItem"</span><span style="color: red;">runat</span><span style="color: blue;">="server"</span><span style="color: blue;">/></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">    <span style="color: blue;"><</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">Label</span> <span style="color: red;">id</span><span style="color: blue;">="lblExportExcel"</span><span style="color: red;">runat</span><span style="color: blue;">="server"></</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">Label</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">    <span style="color: blue;"><</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">UpdatePanel</span> <span style="color: red;">ID</span><span style="color: blue;">="updatePanel"</span><span style="color: red;">runat</span><span style="color: blue;">="server"</span><span style="color: red;">UpdateMode</span><span style="color: blue;">="Conditional"></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;"><</span><span style="color: maroon;">ContentTemplate</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;"><</span><span style="color: maroon;">table</span> <span style="color: red;">cellpadding</span><span style="color: blue;">="2"</span><span style="color: red;">cellspacing</span><span style="color: blue;">="3"</span><span style="color: red;">width</span><span style="color: blue;">="100%"></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;"><</span><span style="color: maroon;">tr</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    <span style="color: blue;"><</span><span style="color: maroon;">td</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                        <span style="color: blue;"><</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">LinkButton</span> <span style="color: red;">id</span><span style="color: blue;">="cmdExport"</span> <span style="color: red;">runat</span><span style="color: blue;">="server"</span> <span style="color: red;">CssClass</span><span style="color: blue;">="btn btn-small"</span> <span style="color: red;">Causesvalidation</span><span style="color: blue;">="false"></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                            <span style="color: blue;"><</span><span style="color: maroon;">i</span> <span style="color: red;">class</span><span style="color: blue;">="icon-exportexcel"></</span><span style="color: maroon;">i</span><span style="color: blue;">></span><span style="color: red;">&nbsp;&nbsp;</span><span style="color: blue;"><</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">label</span> <span style="color: red;">id</span><span style="color: blue;">="lblExport"</span> <span style="color: red;">runat</span><span style="color: blue;">="server"</span> <span style="color: red;">Text</span><span style="color: blue;">="Export Excel"></</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">label</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                        <span style="color: blue;"></</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">LinkButton</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    <span style="color: blue;"></</span><span style="color: maroon;">td</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    <span style="color: blue;"><</span><span style="color: maroon;">td</span><span style="color: red;">align</span><span style="color: blue;">="right"></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                        <span style="color: blue;"><</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">Label</span> <span style="color: red;">ID</span><span style="color: blue;">="plKeyword"</span> <span style="color: red;">runat</span><span style="color: blue;">="server"</span> <span style="color: red;">Text</span><span style="color: blue;">="Keyword"></</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">Label</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                        <span style="color: blue;"><</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">TextBox</span> <span style="color: red;">ID</span><span style="color: blue;">="txtSearch"</span> <span style="color: red;">CssClass</span><span style="color: blue;">="form-control"</span> <span style="color: red;">ToolTip</span><span style="color: blue;">="Enter Keyword"</span> <span style="color: red;">runat</span><span style="color: blue;">="server"</span> <span style="color: red;">width</span><span style="color: blue;">="200px"></</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">TextBox</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                        <span style="color: blue;"><</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">ImageButton</span> <span style="color: red;">ID</span><span style="color: blue;">="cmdQuickSearch"</span> <span style="color: red;">runat</span><span style="color: blue;">="server"</span> <span style="color: red;">causesvalidation</span><span style="color: blue;">="false"</span> <span style="color: red;">imageurl</span><span style="color: blue;">="~/images/icon_search.gif"></</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">ImageButton</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    <span style="color: blue;"></</span><span style="color: maroon;">td</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;"></</span><span style="color: maroon;">tr</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;"><</span><span style="color: maroon;">tr</span><span style="color: red;">id</span><span style="color: blue;">="trMessage"</span><span style="color: red;">runat</span><span style="color: blue;">="server"</span><span style="color: red;">visible</span><span style="color: blue;">="false"></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    <span style="color: blue;"><</span><span style="color: maroon;">td</span><span style="color: red;">colspan</span><span style="color: blue;">="2"></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                        <span style="color: blue;"><</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">Label</span> <span style="color: red;">ID</span><span style="color: blue;">="lblMessage"</span> <span style="color: red;">runat</span><span style="color: blue;">="server"</span> <span style="color: red;">Text</span><span style="color: blue;">="No Data"></</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">Label</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    <span style="color: blue;"></</span><span style="color: maroon;">td</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;"></</span><span style="color: maroon;">tr</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;"><</span><span style="color: maroon;">tr</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    <span style="color: blue;"><</span><span style="color: maroon;">td</span><span style="color: red;">colspan</span><span style="color: blue;">="2"></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                        <span style="color: blue;"><</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">GridView</span> <span style="color: red;">ID</span><span style="color: blue;">="grvObject"</span> <span style="color: red;">runat</span><span style="color: blue;">="server"</span> <span style="color: red;">AllowPaging</span><span style="color: blue;">="true"</span> <span style="color: red;">PageSize</span><span style="color: blue;">="10"</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                            <span style="color: red;">CssClass</span><span style="color: blue;">="GridStyle"</span><span style="color: red;">BorderColor</span><span style="color: blue;">="#cbcbcb"</span><span style="color: red;">BorderStyle</span><span style="color: blue;">="solid"</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                            <span style="color: red;">BorderWidth</span><span style="color: blue;">="1"</span><span style="color: red;">AutoGenerateColumns</span><span style="color: blue;">="false"</span><span style="color: red;">DataKeyNames</span><span style="color: blue;">="AccountID"</span><span style="color: red;">width</span><span style="color: blue;">="100%"></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                            <span style="color: blue;"><</span><span style="color: maroon;">AlternatingRowStyle</span><span style="color: red;">CssClass</span><span style="color: blue;">="GridStyle_AltRowStyle"</span><span style="color: blue;">/></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                            <span style="color: blue;"><</span><span style="color: maroon;">HeaderStyle</span> <span style="color: red;">CssClass</span><span style="color: blue;">="GridStyle_HeaderStyle"</span><span style="color: blue;">/></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                            <span style="color: blue;"><</span><span style="color: maroon;">RowStyle</span> <span style="color: red;">CssClass</span><span style="color: blue;">="GridStyle_RowStyle"</span><span style="color: blue;">/></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                            <span style="color: blue;"><</span><span style="color: maroon;">pagerstyle</span> <span style="color: red;">cssclass</span><span style="color: blue;">="GridStyle_pagination"</span><span style="color: blue;">/></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                            <span style="color: blue;"><</span><span style="color: maroon;">Columns</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                                <span style="color: blue;"><</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">TemplateField</span> <span style="color: red;">HeaderText</span><span style="color: blue;">="AccountCode"></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                                          <span style="color: blue;"><</span><span style="color: maroon;">ItemStyle</span> <span style="color: red;">width</span><span style="color: blue;">="6%"</span> <span style="color: blue;">/></span>    <o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                                    <span style="color: blue;"><</span><span style="color: maroon;">ItemTemplate</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                                        <span style="color: blue;"><</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">LinkButton</span> <span style="color: red;">id</span><span style="color: blue;">="cmdAccountCode"</span><span style="color: red;">runat</span><span style="color: blue;">="server"</span><span style="color: red;">CausesValidation</span><span style="color: blue;">="False"</span><span style="color: red;">CommandName</span><span style="color: blue;">="View"</span><span style="color: red;">CommandArgument</span><span style="color: blue;">='</span><span style="background: yellow; mso-highlight: yellow;"><%</span><span style="color: blue;">#</span> Eval("AccountID") <span style="background: yellow; mso-highlight: yellow;">%></span><span style="color: blue;">'</span> <span style="color: red;">text</span><span style="color: blue;">='</span><span style="background: yellow; mso-highlight: yellow;"><%</span><span style="color: blue;">#</span> Eval("AccountCode") <span style="background: yellow; mso-highlight: yellow;">%></span><span style="color: blue;">'></</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">LinkButton</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                                    <span style="color: blue;"></</span><span style="color: maroon;">ItemTemplate</span><span style="color: blue;">></span>                           <o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                                <span style="color: blue;"></</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">TemplateField</span><span style="color: blue;">></span> <o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                                <span style="color: blue;"><</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">TemplateField</span> <span style="color: red;">HeaderText</span><span style="color: blue;">="AccountName"></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                                          <span style="color: blue;"><</span><span style="color: maroon;">ItemStyle</span> <span style="color: red;">width</span><span style="color: blue;">="15%"</span> <span style="color: blue;">/></span>    <o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                                    <span style="color: blue;"><</span><span style="color: maroon;">ItemTemplate</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                                        <span style="color: blue;"><</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">LinkButton</span> <span style="color: red;">id</span><span style="color: blue;">="cmdAccountName"</span><span style="color: red;">runat</span><span style="color: blue;">="server"</span><span style="color: red;">CausesValidation</span><span style="color: blue;">="False"</span><span style="color: red;">CommandName</span><span style="color: blue;">="View"</span><span style="color: red;">CommandArgument</span><span style="color: blue;">='</span><span style="background: yellow; mso-highlight: yellow;"><%</span><span style="color: blue;">#</span> Eval("AccountID") <span style="background: yellow; mso-highlight: yellow;">%></span><span style="color: blue;">'</span> <span style="color: red;">text</span><span style="color: blue;">='</span><span style="background: yellow; mso-highlight: yellow;"><%</span><span style="color: blue;">#</span> Eval("AccName") <span style="background: yellow; mso-highlight: yellow;">%></span><span style="color: blue;">'></</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">LinkButton</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                                    <span style="color: blue;"></</span><span style="color: maroon;">ItemTemplate</span><span style="color: blue;">></span>                           <o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                                <span style="color: blue;"></</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">TemplateField</span><span style="color: blue;">></span>  <o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                                <span style="color: blue;"><</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">TemplateField</span> <span style="color: red;">HeaderText</span><span style="color: blue;">="Phone"></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                                          <span style="color: blue;"><</span><span style="color: maroon;">ItemStyle</span> <span style="color: red;">width</span><span style="color: blue;">="10%"</span> <span style="color: blue;">/></span>    <o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                                    <span style="color: blue;"><</span><span style="color: maroon;">ItemTemplate</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                                        <span style="color: blue;"><</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">Label</span> <span style="color: red;">ID</span><span style="color: blue;">="lblAccPhone"</span><span style="color: red;">Text</span><span style="color: blue;">='</span><span style="background: yellow; mso-highlight: yellow;"><%</span><span style="color: blue;">#</span> Eval("AccPhone") <span style="background: yellow; mso-highlight: yellow;">%></span><span style="color: blue;">'</span> <span style="color: red;">runat</span><span style="color: blue;">="server"></</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">Label</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                                    <span style="color: blue;"></</span><span style="color: maroon;">ItemTemplate</span><span style="color: blue;">></span>                           <o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                                <span style="color: blue;"></</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">TemplateField</span><span style="color: blue;">></span> <o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                                <span style="color: blue;"><</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">TemplateField</span> <span style="color: red;">HeaderText</span><span style="color: blue;">="FAX"></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                                          <span style="color: blue;"><</span><span style="color: maroon;">ItemStyle</span> <span style="color: red;">width</span><span style="color: blue;">="10%"</span> <span style="color: blue;">/></span>    <o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                                    <span style="color: blue;"><</span><span style="color: maroon;">ItemTemplate</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                                        <span style="color: blue;"><</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">Label</span> <span style="color: red;">ID</span><span style="color: blue;">="lblAccFAX"</span><span style="color: red;">Text</span><span style="color: blue;">='</span><span style="background: yellow; mso-highlight: yellow;"><%</span><span style="color: blue;">#</span> Eval("AccFAX") <span style="background: yellow; mso-highlight: yellow;">%></span><span style="color: blue;">'</span> <span style="color: red;">runat</span><span style="color: blue;">="server"></</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">Label</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                                    <span style="color: blue;"></</span><span style="color: maroon;">ItemTemplate</span><span style="color: blue;">></span>                           <o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                                <span style="color: blue;"></</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">TemplateField</span><span style="color: blue;">></span>   <o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                                <span style="color: blue;"><</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">TemplateField</span> <span style="color: red;">HeaderText</span><span style="color: blue;">="Email"></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                                          <span style="color: blue;"><</span><span style="color: maroon;">ItemStyle</span> <span style="color: red;">width</span><span style="color: blue;">="12%"</span> <span style="color: blue;">/></span>    <o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                                    <span style="color: blue;"><</span><span style="color: maroon;">ItemTemplate</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                                        <span style="color: blue;"><</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">Label</span> <span style="color: red;">ID</span><span style="color: blue;">="lblEmail"</span><span style="color: red;">Text</span><span style="color: blue;">='</span><span style="background: yellow; mso-highlight: yellow;"><%</span><span style="color: blue;">#</span> Eval("AccEmail") <span style="background: yellow; mso-highlight: yellow;">%></span><span style="color: blue;">'</span> <span style="color: red;">runat</span><span style="color: blue;">="server"></</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">Label</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                                    <span style="color: blue;"></</span><span style="color: maroon;">ItemTemplate</span><span style="color: blue;">></span>                           <o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                                <span style="color: blue;"></</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">TemplateField</span><span style="color: blue;">></span>         <o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                                      <span style="color: blue;"><</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">TemplateField</span> <span style="color: red;">HeaderText</span><span style="color: blue;">="Function"></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                                          <span style="color: blue;"><</span><span style="color: maroon;">ItemStyle</span> <span style="color: red;">HorizontalAlign</span><span style="color: blue;">="Center"</span><span style="color: red;">width</span><span style="color: blue;">="5%"</span><span style="color: blue;">/></span>  <o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                                             <span style="color: blue;"><</span><span style="color: maroon;">ItemTemplate</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                                        <span style="color: blue;"><</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">ImageButton</span> <span style="color: red;">ID</span><span style="color: blue;">="cmdDelete"</span><span style="color: red;">CommandName</span><span style="color: blue;">="Delete"</span><span style="color: red;">CommandArgument</span><span style="color: blue;">='</span><span style="background: yellow; mso-highlight: yellow;"><%</span><span style="color: blue;">#</span> Eval("AccountID")<span style="background: yellow; mso-highlight: yellow;">%></span><span style="color: blue;">'</span> <span style="color: red;">runat</span><span style="color: blue;">="server"</span><span style="color: red;">ImageUrl</span><span style="color: blue;">="~/images/delete.gif"</span><span style="color: red;">CausesValidation</span><span style="color: blue;">="False"></</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">ImageButton</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                                             <span style="color: blue;"></</span><span style="color: maroon;">ItemTemplate</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                                      <span style="color: blue;"></</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">TemplateField</span><span style="color: blue;">></span>                                 <o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                            <span style="color: blue;"></</span><span style="color: maroon;">Columns</span><span style="color: blue;">></span>                               <o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                        <span style="color: blue;"></</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">GridView</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    <span style="color: blue;"></</span><span style="color: maroon;">td</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;"></</span><span style="color: maroon;">tr</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;"></</span><span style="color: maroon;">table</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;"></</span><span style="color: maroon;">ContentTemplate</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;"><</span><span style="color: maroon;">Triggers</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;"><</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">PostBackTrigger</span> <span style="color: red;">ControlID</span><span style="color: blue;">="cmdExport"</span><span style="color: blue;">/></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;"></</span><span style="color: maroon;">Triggers</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">    <span style="color: blue;"></</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">UpdatePanel</span><span style="color: blue;">></span></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: Consolas; font-size: 9.5pt;"></</span><span style="color: maroon; font-family: Consolas; font-size: 9.5pt;">asp</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">:</span><span style="color: maroon; font-family: Consolas; font-size: 9.5pt;">Content</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">></span><span style="font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div></div></div></div></div></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;"><span style="color: blue;"><o:p></o:p></span></span></div><br />- <b>B8</b>: Viết Code cho file Default.aspx<br /><br /><div class="code" id="code"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">Namespace</span><span style="font-family: Consolas; font-size: 9.5pt;"> ExportDatatableToExcel<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">    <span style="color: blue;">Public</span> <span style="color: blue;">Class</span> <span style="color: #2b91af;">_Default</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">Inherits</span> System.Web.UI.<span style="color: #2b91af;">Page</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">#Region</span><span style="font-family: Consolas; font-size: 9.5pt;"> <span style="color: #a31515;">"Export Excel"</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">Private</span> <span style="color: blue;">Function</span>InserHeaderInExcel() <span style="color: blue;">As</span> <span style="color: blue;">String</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">Dim</span> sExportToExcel <span style="color: blue;">As</span><span style="color: blue;">String</span> = <span style="color: #a31515;">""</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            sExportToExcel &= <span style="color: #a31515;">"<table border='0' cellpadding='0' cellspacing='0' width='99%' align='center'>"</span>& vbCrLf<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            sExportToExcel &= <span style="color: #a31515;">"<tr>"</span>& vbCrLf<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            sExportToExcel &= <span style="color: #a31515;">"<td colspan='3' style='font-size:14pt;'><b>THỦ THUẬT LẬP TRÌNH</b></td>"</span>& vbCrLf<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            sExportToExcel &= <span style="color: #a31515;">"</tr>"</span>& vbCrLf<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            sExportToExcel &= <span style="color: #a31515;">"<tr>"</span>& vbCrLf<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            sExportToExcel &= <span style="color: #a31515;">"<td colspan='3'><b>Website:</b> http://thuthuatlaptrinh.blogspot.com</td>"</span> & vbCrLf<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            sExportToExcel &= <span style="color: #a31515;">"</tr>"</span>& vbCrLf<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            sExportToExcel &= <span style="color: #a31515;">"<tr>"</span>& vbCrLf<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            sExportToExcel &= <span style="color: #a31515;">"<td colspan='3'><b>Email:</b> kenhphanmemviet@gmail.com</td>"</span> & vbCrLf<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            sExportToExcel &= <span style="color: #a31515;">"</tr>"</span>& vbCrLf<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            sExportToExcel &= <span style="color: #a31515;">"</table>"</span>& vbCrLf<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">Return</span> sExportToExcel<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">End</span> <span style="color: blue;">Function</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">Private</span> <span style="color: blue;">Function</span>ExportAccountToExcel(<span style="color: blue;">ByVal</span> objBind <span style="color: blue;">As</span> <span style="color: #2b91af;">DataTable</span>)<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">Dim</span> sExportToExcel <span style="color: blue;">As</span><span style="color: blue;">String</span> = <span style="color: #a31515;">""</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">Dim</span> sActivitiesNumber <span style="color: blue;">As</span><span style="color: blue;">String</span> = <span style="color: #a31515;">""</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">Dim</span> sParentName <span style="color: blue;">As</span> <span style="color: blue;">String</span> = <span style="color: #a31515;">""</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">Dim</span> ListInfoContact <span style="color: blue;">As</span><span style="color: blue;">String</span> = <span style="color: #a31515;">""</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            sExportToExcel &= <span style="color: #a31515;">"<div id='div1'>"</span> & vbCrLf<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: green;">'=============Insert Header============</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            sExportToExcel &= InserHeaderInExcel()<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: green;">'======================================</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            sExportToExcel &= <span style="color: #a31515;">"<table border='0' cellpadding='0' cellspacing='0' width='99%' align='center'>"</span>& vbCrLf<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            sExportToExcel &= <span style="color: #a31515;">"<tr>"</span>& vbCrLf<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            sExportToExcel &= <span style="color: #a31515;">"<td colspan='9'>&nbsp;</td>"</span> & vbCrLf<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            sExportToExcel &= <span style="color: #a31515;">"</tr>"</span>& vbCrLf<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            sExportToExcel &= <span style="color: #a31515;">"<tr>"</span>& vbCrLf<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            sExportToExcel &= <span style="color: #a31515;">"<td align='center' colspan='9' style='font-size:12pt;'><b>LIST ACCOUNT</b></td>"</span> & vbCrLf<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            sExportToExcel &= <span style="color: #a31515;">"</tr>"</span>& vbCrLf<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            sExportToExcel &= <span style="color: #a31515;">"<tr>"</span>& vbCrLf<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            sExportToExcel &= <span style="color: #a31515;">"<td colspan='9'>&nbsp;</td>"</span> & vbCrLf<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            sExportToExcel &= <span style="color: #a31515;">"</tr>"</span>& vbCrLf<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            sExportToExcel &= <span style="color: #a31515;">"</table>"</span>& vbCrLf<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            sExportToExcel &= <span style="color: #a31515;">"<table border='1' cellpadding='0' cellspacing='0' width='99%' align='center'>"</span>& vbCrLf<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            sExportToExcel &= <span style="color: #a31515;">"<tr>"</span>& vbCrLf<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            sExportToExcel &= <span style="color: #a31515;">"<td align='center'><b>AccountCode</b></td>"</span> & vbCrLf<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            sExportToExcel &= <span style="color: #a31515;">"<td align='center'><b>AccountName</b></td>"</span> & vbCrLf<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            sExportToExcel &= <span style="color: #a31515;">"<td align='center'><b>Phone</b></td>"</span>& vbCrLf<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            sExportToExcel &= <span style="color: #a31515;">"<td align='center'><b>FAX</b></td>"</span> & vbCrLf<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            sExportToExcel &= <span style="color: #a31515;">"<td align='center'><b>Email</b></td>"</span> & vbCrLf<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            sExportToExcel &= <span style="color: #a31515;">"<td align='center'><b>Website</b></td>"</span> & vbCrLf<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            sExportToExcel &= <span style="color: #a31515;">"<td align='center'><b>Description</b></td>"</span> & vbCrLf<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            sExportToExcel &= <span style="color: #a31515;">"<td align='center'><b>Created Date</b></td>"</span> & vbCrLf<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            sExportToExcel &= <span style="color: #a31515;">"<td align='center'><b>Modified Date</b></td>"</span>& vbCrLf<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            sExportToExcel &= <span style="color: #a31515;">"</tr>"</span>& vbCrLf<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: green;">'End Header</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">For</span> <span style="color: blue;">Each</span> row <span style="color: blue;">As</span> <span style="color: #2b91af;">DataRow</span> <span style="color: blue;">In</span> objBind.Rows<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;">If</span> <span style="color: blue;">Not</span>row <span style="color: blue;">Is</span> <span style="color: blue;">Nothing</span> <span style="color: blue;">Then</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    sExportToExcel &= <span style="color: #a31515;">"<tr>"</span>& vbCrLf<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    <span style="color: blue;">If</span> <span style="color: blue;">Not</span>IsDBNull(row(<span style="color: #a31515;">"AccountCode"</span>)) <span style="color: blue;">Then</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                        sExportToExcel &= <span style="color: #a31515;">"<td>"</span> & row(<span style="color: #a31515;">"AccountCode"</span>).ToString & <span style="color: #a31515;">"</td>"</span> & vbCrLf<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    <span style="color: blue;">Else</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                        sExportToExcel &= <span style="color: #a31515;">"<td></td>"</span> & vbCrLf<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    <span style="color: blue;">End</span> <span style="color: blue;">If</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    <span style="color: blue;">If</span><span style="color: blue;">Not</span> IsDBNull(row(<span style="color: #a31515;">"AccName"</span>)) <span style="color: blue;">Then</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                        sExportToExcel &= <span style="color: #a31515;">"<td>"</span> & row(<span style="color: #a31515;">"AccName"</span>).ToString & <span style="color: #a31515;">"</td>"</span> & vbCrLf<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    <span style="color: blue;">Else</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                        sExportToExcel &= <span style="color: #a31515;">"<td></td>"</span> & vbCrLf<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    <span style="color: blue;">End</span> <span style="color: blue;">If</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    <span style="color: blue;">If</span> <span style="color: blue;">Not</span>IsDBNull(row(<span style="color: #a31515;">"AccPhone"</span>)) <span style="color: blue;">Then</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                        sExportToExcel &= <span style="color: #a31515;">"<td>"</span> & row(<span style="color: #a31515;">"AccPhone"</span>).ToString & <span style="color: #a31515;">"</td>"</span> & vbCrLf<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    <span style="color: blue;">Else</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                        sExportToExcel &= <span style="color: #a31515;">"<td></td>"</span> & vbCrLf<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    <span style="color: blue;">End</span><span style="color: blue;">If</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    <span style="color: blue;">If</span> <span style="color: blue;">Not</span>IsDBNull(row(<span style="color: #a31515;">"AccFAX"</span>)) <span style="color: blue;">Then</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                        sExportToExcel &= <span style="color: #a31515;">"<td>"</span> & row(<span style="color: #a31515;">"AccFAX"</span>).ToString & <span style="color: #a31515;">"</td>"</span> & vbCrLf<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    <span style="color: blue;">Else</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                        sExportToExcel &= <span style="color: #a31515;">"<td></td>"</span> & vbCrLf<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    <span style="color: blue;">End</span> <span style="color: blue;">If</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    <span style="color: blue;">If</span> <span style="color: blue;">Not</span>IsDBNull(row(<span style="color: #a31515;">"AccEmail"</span>)) <span style="color: blue;">Then</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                        sExportToExcel &= <span style="color: #a31515;">"<td>"</span> & row(<span style="color: #a31515;">"AccEmail"</span>).ToString & <span style="color: #a31515;">"</td>"</span> & vbCrLf<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    <span style="color: blue;">Else</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                        sExportToExcel &= <span style="color: #a31515;">"<td></td>"</span> & vbCrLf<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    <span style="color: blue;">End</span> <span style="color: blue;">If</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    <span style="color: blue;">If</span> <span style="color: blue;">Not</span>IsDBNull(row(<span style="color: #a31515;">"AccWebsite"</span>)) <span style="color: blue;">Then</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                        sExportToExcel &= <span style="color: #a31515;">"<td>"</span> & row(<span style="color: #a31515;">"AccWebsite"</span>).ToString & <span style="color: #a31515;">"</td>"</span> & vbCrLf<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    <span style="color: blue;">Else</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                        sExportToExcel &= <span style="color: #a31515;">"<td></td>"</span> & vbCrLf<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    <span style="color: blue;">End</span> <span style="color: blue;">If</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    <span style="color: blue;">If</span> <span style="color: blue;">Not</span>IsDBNull(row(<span style="color: #a31515;">"AccDesc"</span>)) <span style="color: blue;">Then</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                        sExportToExcel &= <span style="color: #a31515;">"<td>"</span> & row(<span style="color: #a31515;">"AccDesc"</span>).ToString & <span style="color: #a31515;">"</td>"</span> & vbCrLf<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    <span style="color: blue;">Else</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                        sExportToExcel &= <span style="color: #a31515;">"<td></td>"</span> & vbCrLf<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    <span style="color: blue;">End</span> <span style="color: blue;">If</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    <span style="color: blue;">If</span> <span style="color: blue;">Not</span>IsDBNull(row(<span style="color: #a31515;">"CreatedDate"</span>)) <span style="color: blue;">Then</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                        sExportToExcel &= <span style="color: #a31515;">"<td>"</span> & row(<span style="color: #a31515;">"CreatedDate"</span>).ToString & <span style="color: #a31515;">"</td>"</span> & vbCrLf<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    <span style="color: blue;">Else</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                        sExportToExcel &= <span style="color: #a31515;">"<td></td>"</span> & vbCrLf<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    <span style="color: blue;">End</span> <span style="color: blue;">If</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    <span style="color: blue;">If</span> <span style="color: blue;">Not</span>IsDBNull(row(<span style="color: #a31515;">"ModifiedDate"</span>)) <span style="color: blue;">Then</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                        sExportToExcel &= <span style="color: #a31515;">"<td>"</span> & row(<span style="color: #a31515;">"ModifiedDate"</span>).ToString & <span style="color: #a31515;">"</td>"</span> & vbCrLf<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    <span style="color: blue;">Else</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                        sExportToExcel &= <span style="color: #a31515;">"<td></td>"</span> & vbCrLf<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    <span style="color: blue;">End</span> <span style="color: blue;">If</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    sExportToExcel &= <span style="color: #a31515;">"</tr>"</span>& vbCrLf<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;">End</span> <span style="color: blue;">If</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">Next</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            sExportToExcel &= <span style="color: #a31515;">"</table></div>"</span>& vbCrLf<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">Return</span> sExportToExcel<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">End</span> <span style="color: blue;">Function</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">Private</span> <span style="color: blue;">Sub</span>ExportToExcel(<span style="color: blue;">ByVal</span> FileName <span style="color: blue;">As</span> <span style="color: blue;">String</span>)<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">Dim</span> objBind <span style="color: blue;">As</span> <span style="color: blue;">New</span> <span style="color: #2b91af;">DataTable</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">Dim</span> sb <span style="color: blue;">As</span> <span style="color: blue;">New</span> System.Text.<span style="color: #2b91af;">StringBuilder</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">Dim</span> sExportToExcel <span style="color: blue;">As</span><span style="color: blue;">String</span> = <span style="color: #a31515;">""</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">Dim</span> style <span style="color: blue;">As</span> <span style="color: blue;">String</span> = <span style="color: #a31515;">"<style>.text{mso-number-format:\@;}</style>"</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            objBind = BindData()<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">If</span> objBind.Rows.Count > 0 <span style="color: blue;">Then</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                sExportToExcel = ExportAccountToExcel(objBind)<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                sb.Append(sExportToExcel)<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                lblExport.Text = sb.ToString()<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                sb.Remove(0, sb.Length)<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                Response.Clear()<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                Response.Charset = <span style="color: #a31515;">""</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                Response.ContentEncoding = System.Text.<span style="color: #2b91af;">Encoding</span>.UTF8<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                Response.Cache.SetCacheability(<span style="color: #2b91af;">HttpCacheability</span>.NoCache)<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                Response.ContentType = <span style="color: #a31515;">"application/ms-excel.xls"</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                Response.AddHeader(<span style="color: #a31515;">"content-disposition"</span>, <span style="color: #a31515;">"attachment;filename="</span> & FileName & <span style="color: #a31515;">".xls"</span>)<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                Response.ContentEncoding = <span style="color: #2b91af;">Encoding</span>.Unicode<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                Response.BinaryWrite(<span style="color: #2b91af;">Encoding</span>.Unicode.GetPreamble())<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;">Dim</span> sw <span style="color: blue;">As</span><span style="color: blue;">New</span> System.IO.<span style="color: #2b91af;">StringWriter</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;">Dim</span> htw <span style="color: blue;">As</span><span style="color: blue;">New</span> <span style="color: #2b91af;">HtmlTextWriter</span>(sw)<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                lblExport.RenderControl(htw)<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                Response.Output.Write(style & sw.ToString().Replace(<span style="color: #a31515;">"td"</span>, <span style="color: #a31515;">"td class='text'"</span>))<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                Response.Flush()<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                Response.End()<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">End</span> <span style="color: blue;">If</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">End</span> <span style="color: blue;">Sub</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">#End</span><span style="font-family: Consolas; font-size: 9.5pt;"> <span style="color: blue;">Region</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">#Region</span><span style="font-family: Consolas; font-size: 9.5pt;"> <span style="color: #a31515;">"Bind Data"</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">Private</span> <span style="color: blue;">Sub</span>BindAccount()<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">Dim</span> objBind <span style="color: blue;">As</span> <span style="color: blue;">New</span> <span style="color: #2b91af;">DataTable</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            objBind = BindData()<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">If</span> <span style="color: blue;">Not</span> objBind <span style="color: blue;">Is</span> <span style="color: blue;">Nothing</span> <span style="color: blue;">Then</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;">If</span> objBind.Rows.Count > 0 <span style="color: blue;">Then</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    grvObject.DataSource = objBind<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    grvObject.DataBind()<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    trMessage.Visible = <span style="color: blue;">False</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    grvObject.Visible = <span style="color: blue;">True</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;">Else</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    trMessage.Visible = <span style="color: blue;">True</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    grvObject.Visible = <span style="color: blue;">False</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;">End</span> <span style="color: blue;">If</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                updatePanel.Update()<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">End</span> <span style="color: blue;">If</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">End</span> <span style="color: blue;">Sub</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">Private</span> <span style="color: blue;">Function</span>BindData() <span style="color: blue;">As</span> <span style="color: #2b91af;">DataTable</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">Dim</span> objSQL <span style="color: blue;">As</span> <span style="color: blue;">New</span> <span style="color: #2b91af;">SqlDataProvider</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">Dim</span> objBind <span style="color: blue;">As</span> <span style="color: #2b91af;">DataTable</span> = objSQL.FillTable(<span style="color: #a31515;">"Pro_Accounts_List"</span>, <span style="color: blue;">New</span> <span style="color: #2b91af;">ObjectPara</span>(<span style="color: #a31515;">"@Keyword"</span>, txtSearch.Text.Trim), _<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                                                                          <span style="color: blue;">New</span> <span style="color: #2b91af;">ObjectPara</span>(<span style="color: #a31515;">"@SortField"</span>, <span style="color: #a31515;">"CreatedDate"</span>), _<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                                                                          <span style="color: blue;">New</span> <span style="color: #2b91af;">ObjectPara</span>(<span style="color: #a31515;">"@SortType"</span>, <span style="color: #a31515;">"DESC"</span>))<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">Return</span> objBind<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">End</span> <span style="color: blue;">Function</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">#End</span><span style="font-family: Consolas; font-size: 9.5pt;"> <span style="color: blue;">Region</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">#Region</span><span style="font-family: Consolas; font-size: 9.5pt;"> <span style="color: #a31515;">"GridView Methods"</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">Private</span> <span style="color: blue;">Sub</span>grvObject_RowCommand(<span style="color: blue;">ByVal</span> sender <span style="color: blue;">As</span> <span style="color: blue;">Object</span>, <span style="color: blue;">ByVal</span> e <span style="color: blue;">As</span>System.Web.UI.WebControls.<span style="color: #2b91af;">GridViewCommandEventArgs</span>) <span style="color: blue;">Handles</span> grvObject.RowCommand<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">Dim</span> ItemID <span style="color: blue;">As</span> <span style="color: blue;">Integer</span> = <span style="color: blue;">Integer</span>.Parse(e.CommandArgument)<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">Select</span> <span style="color: blue;">Case</span>e.CommandName.ToLower<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;">Case</span> <span style="color: #a31515;">"view"</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    <span style="color: blue;">With</span> <span style="color: blue;">CType</span>(ucViewRecord, ExportDatatableToExcel.UserControls.<span style="color: #2b91af;">Popup_ViewRecord</span>)<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                        .ItemID = ItemID<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                        .ShowPopup(ItemID)<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    <span style="color: blue;">End</span> <span style="color: blue;">With</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">End</span> <span style="color: blue;">Select</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">End</span> <span style="color: blue;">Sub</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">Private</span> <span style="color: blue;">Sub</span>grvObject_RowDeleting(<span style="color: blue;">ByVal</span> sender <span style="color: blue;">As</span> <span style="color: blue;">Object</span>, <span style="color: blue;">ByVal</span> e <span style="color: blue;">As</span> System.Web.UI.WebControls.<span style="color: #2b91af;">GridViewDeleteEventArgs</span>) <span style="color: blue;">Handles</span>grvObject.RowDeleting<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">Dim</span> ItemID <span style="color: blue;">As</span> <span style="color: blue;">Integer</span> = <span style="color: blue;">CType</span>(grvObject.DataKeys(e.RowIndex).Value, <span style="color: blue;">Integer</span>)<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">Dim</span> ItemName <span style="color: blue;">As</span> <span style="color: blue;">String</span> = <span style="color: #a31515;">""</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">If</span> ItemID <> -1 <span style="color: blue;">Then</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;">With</span> <span style="color: blue;">CType</span>(ucDeleteItem, ExportDatatableToExcel.UserControls.<span style="color: #2b91af;">Popup_ConfirmDelete</span>)<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    .ItemID = ItemID<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    .ShowPopup(ItemID, <span style="color: #a31515;">""</span>)<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;">End</span> <span style="color: blue;">With</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">End</span> <span style="color: blue;">If</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">End</span> <span style="color: blue;">Sub</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">Private</span> <span style="color: blue;">Sub</span>grvObject_RowDataBound(<span style="color: blue;">ByVal</span> sender <span style="color: blue;">As</span> <span style="color: blue;">Object</span>, <span style="color: blue;">ByVal</span> e <span style="color: blue;">As</span> <span style="color: #2b91af;">GridViewRowEventArgs</span>) <span style="color: blue;">Handles</span>grvObject.RowDataBound<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">If</span> (e.Row.RowType = <span style="color: #2b91af;">DataControlRowType</span>.DataRow) <span style="color: blue;">Then</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: green;">'Delete</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;">Dim</span> cmdDelete <span style="color: blue;">As</span><span style="color: #2b91af;">ImageButton</span> = <span style="color: blue;">DirectCast</span>(e.Row.FindControl(<span style="color: #a31515;">"cmdDelete"</span>), <span style="color: #2b91af;">ImageButton</span>)<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;">If</span> <span style="color: blue;">Not</span>cmdDelete <span style="color: blue;">Is</span> <span style="color: blue;">Nothing</span><span style="color: blue;">Then</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    cmdDelete.ToolTip = <span style="color: #a31515;">"Delete Account"</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;">End</span> <span style="color: blue;">If</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">End</span> <span style="color: blue;">If</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">End</span> <span style="color: blue;">Sub</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">Private</span> <span style="color: blue;">Sub</span>grvObject_PageIndexChanging(<span style="color: blue;">ByVal</span> sender <span style="color: blue;">As</span> <span style="color: blue;">Object</span>, <span style="color: blue;">ByVal</span> e <span style="color: blue;">As</span>System.Web.UI.WebControls.<span style="color: #2b91af;">GridViewPageEventArgs</span>) <span style="color: blue;">Handles</span> grvObject.PageIndexChanging<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            grvObject.PageIndex = e.NewPageIndex<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            BindAccount()<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">End</span> <span style="color: blue;">Sub</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">#End</span><span style="font-family: Consolas; font-size: 9.5pt;"> <span style="color: blue;">Region</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">#Region</span><span style="font-family: Consolas; font-size: 9.5pt;"> <span style="color: #a31515;">"Popup"</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">Private</span> <span style="color: blue;">Sub</span>MySelDelete_OnSelectedRow(<span style="color: blue;">ByVal</span> sender <span style="color: blue;">As</span> <span style="color: blue;">Object</span>, <span style="color: blue;">ByVal</span> e <span style="color: blue;">As</span>ExportDatatableToExcel.<span style="color: #2b91af;">MyEventArgs</span>)<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">Dim</span> ItemName <span style="color: blue;">As</span> <span style="color: blue;">String</span> = <span style="color: #a31515;">""</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">With</span> e<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;">If</span> e.Id <> <span style="color: #a31515;">""</span> <span style="color: blue;">Then</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    BindAccount()<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;">End</span> <span style="color: blue;">If</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">End</span> <span style="color: blue;">With</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">End</span> <span style="color: blue;">Sub</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">#End</span><span style="font-family: Consolas; font-size: 9.5pt;"> <span style="color: blue;">Region</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">#Region</span><span style="font-family: Consolas; font-size: 9.5pt;"> <span style="color: #a31515;">"Event Handles"</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">Protected</span> <span style="color: blue;">Sub</span>Page_Load(<span style="color: blue;">ByVal</span> sender <span style="color: blue;">As</span><span style="color: blue;">Object</span>, <span style="color: blue;">ByVal</span> e <span style="color: blue;">As</span> System.<span style="color: #2b91af;">EventArgs</span>) <span style="color: blue;">Handles</span> <span style="color: blue;">Me</span>.Load<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">Try</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;">AddHandler</span> <span style="color: blue;">CType</span>(ucDeleteItem, ExportDatatableToExcel.UserControls.<span style="color: #2b91af;">Popup_ConfirmDelete</span>).OnSelectedRow, <span style="color: blue;">AddressOf</span> MySelDelete_OnSelectedRow<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;">If</span> Page.IsPostBack = <span style="color: blue;">False</span> <span style="color: blue;">Then</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    <span style="color: green;">'Default Submit Button</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    Page.Form.DefaultButton = cmdQuickSearch.UniqueID<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    BindAccount()<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;">End</span> <span style="color: blue;">If</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">Catch</span> ex <span style="color: blue;">As</span> <span style="color: #2b91af;">Exception</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">End</span> <span style="color: blue;">Try</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">End</span> <span style="color: blue;">Sub</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">Private</span> <span style="color: blue;">Sub</span>cmdQuickSearch_Click(<span style="color: blue;">ByVal</span> sender <span style="color: blue;">As</span> <span style="color: blue;">Object</span>, <span style="color: blue;">ByVal</span> e <span style="color: blue;">As</span> System.<span style="color: #2b91af;">EventArgs</span>) <span style="color: blue;">Handles</span>cmdQuickSearch.Click<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            BindAccount()<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">End</span> <span style="color: blue;">Sub</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">Private</span> <span style="color: blue;">Sub</span>cmdExport_Click(<span style="color: blue;">ByVal</span> sender <span style="color: blue;">As</span> <span style="color: blue;">Object</span>, <span style="color: blue;">ByVal</span> e <span style="color: blue;">As</span> System.<span style="color: #2b91af;">EventArgs</span>) <span style="color: blue;">Handles</span>cmdExport.Click<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            ExportToExcel(<span style="color: #a31515;">"List-Account.xls"</span>)<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">End</span> <span style="color: blue;">Sub</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">#End</span><span style="font-family: Consolas; font-size: 9.5pt;"> <span style="color: blue;">Region</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">    <span style="color: blue;">End</span> <span style="color: blue;">Class</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">End</span><span style="font-family: Consolas; font-size: 9.5pt;"> <span style="color: blue;">Namespace</span><o:p></o:p></span></div></div></div></div></div><br /></div>Bây giờ chạy Project bạn sẽ có kết quả như ảnh phía dưới.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEglSmjoVGXF13ZGCbXtmeC-KoEm-tvT4CQC6Mfuo-WWCrye-u_R1V_E5JM51YGwy984A4OIOhSNNx92zisMmMvg1Z1CnV3u9ECgT1jhLjaBU88kIISapDXTZZXx5HrJ_ojcjaKBmhtGWNM/s1600/ExportDatatableToExcel.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEglSmjoVGXF13ZGCbXtmeC-KoEm-tvT4CQC6Mfuo-WWCrye-u_R1V_E5JM51YGwy984A4OIOhSNNx92zisMmMvg1Z1CnV3u9ECgT1jhLjaBU88kIISapDXTZZXx5HrJ_ojcjaKBmhtGWNM/s1600/ExportDatatableToExcel.png" width="550px" /></a></div><div style="clear: both; text-align: center;"><div style="float: left; margin: 6px 6px 0 6px; width: 280px;"><a href="http://adf.ly/1MlCQ3" target="_blank"><img alt="Code Example C#, Code Example VB.NET" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiX5IGNs5gxA6HJ6wKUOVKQztkzufZYGTWmDGsjzESeAbw5gPpVperxnvMiiMPTFhfTdeeR-4kUkJSAALEa1Zdq5fGg0wgUcUViEOH5dYhX9XotYaD-DD8jE1pIm0L0ooHc0HY9SBYOeQw/s1600/CS_Code.png" /></a> </div><div style="float: left; margin: 6px 6px 0 6px; width: 280px;"><a href="http://adf.ly/1JryIT" target="_blank"><img alt="Code Example C#, Code Example VB.NET" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgulrYoUfYJfz40EKRawQ-iISxhV1T4-vVi8rbwkzWwWPOb5NPStwQVd3K3r6lWGkxR5-PlyV7SuGFcERHd7mBlFCaD_HCymi57mq0FBSJ9FMTOIyVXckid3Adhkoc8fUrFD8twfkZS1U8/s1600/VB_Code.png" /></a> </div></div><br /><br /><br />Chúc các bạn thành công!<br /><br />Quang Bình

Export danh sách dữ liệu (Datatable) ra Excel trong Asp.net

( Export dữ liệu trong Asp.net ra Excel ) – Việc cho phép xuất dữ liệu ra Excel sẽ người dùng dễ dàng, thuận tiện và chủ động trong việc căn...

Read more »