Jquery Multiselect DropDownList with CheckBoxes in ASP.Net

<div style="text-align: justify;">(<b>Multiple Select DropDownList with CheckBoxes in ASP.Net</b>) – Để giải quyết vấn đề cho phép chọn nhiều giá trị đồng thời bạn thường sử dụng Control Checkboxlist trong trường hợp có ít giá trị trong danh sách. Nếu danh sách có nhiều khi sử dụng Control Checkboxlist sẽ mất nhiều không gian trên Form. Hoặc bạn có thể sử dụng Duallistcontrol, tuy nhiên với Control này người sử dụng sẽ mất thêm thao tác chọn các giá trị và chuyển. Vậy có giải pháp nào tối ưu cho thao tác chọn nhiều giá trị  trong danh sách đồng thời không? Bài viết dưới đây sẽ hướng dẫn các bạn sử dụng Control DropDownList và cho phép người sử dụng chọn nhiều giá trị đồng thời.<br /><a name="more"></a></div><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhh4CaGQHATWtCiQhFUufYGTXq0K4upshLQundA4H9UoAsC8y3BAhEQ379kaDC64yS-NL1gUdAHWvRKEr6Q323zm2vmPSpsMaymv1aSc6MrpEYlsWjvxvrNauZkqil14UHgi9CJAT8c68U/s1600/Jquery-MultipleSelect-Dropdownlist-with-CheckBoxes.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhh4CaGQHATWtCiQhFUufYGTXq0K4upshLQundA4H9UoAsC8y3BAhEQ379kaDC64yS-NL1gUdAHWvRKEr6Q323zm2vmPSpsMaymv1aSc6MrpEYlsWjvxvrNauZkqil14UHgi9CJAT8c68U/s1600/Jquery-MultipleSelect-Dropdownlist-with-CheckBoxes.jpg" /></a></div><div style="text-align: center;"><b><br /></b><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 /><div class="separator" style="clear: both; text-align: center;"></div><div style="clear: both; text-align: center;"><div style="float: left; margin: 6px 6px 0px; width: 280px;"><a href="http://adf.ly/1O5NcP" 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 0px; width: 280px;"><a href="http://adf.ly/1O5NiE" 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="text-align: center;"><br /><br /></div><span style="text-align: justify;">- </span><b style="text-align: justify;">B1</b><span style="text-align: justify;">: </span>Download CSDL <b>Northwind</b><br /><br />- <b>B2</b>: Tạo Project trong Microsoft Visual Studio 2010<br /><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 /><div style="padding-bottom: 8px; padding-top: 8px;"><b>C# Code</b></div><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;">using</span><span style="font-family: Consolas; font-size: 9.5pt;"> System;<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;">using</span><span style="font-family: Consolas; font-size: 9.5pt;"> System.Collections.Generic;<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;">using</span><span style="font-family: Consolas; font-size: 9.5pt;"> System.Linq;<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;">using</span><span style="font-family: Consolas; font-size: 9.5pt;"> System.Web;<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;">using</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;">using</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;"><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">using</span><span style="font-family: Consolas; font-size: 9.5pt;"> System.Configuration;<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;"> JqueryMultipleSelectDropdownlist<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;">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;"><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;">        #region</span><span style="font-family: Consolas; font-size: 9.5pt;">"Membres Prives"<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;">string</span>_connectionString;<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;">        #endregion</span><span style="font-family: Consolas; font-size: 9.5pt;"><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;">"Constructeurs"<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> SqlDataProvider()<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;">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;">            {<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;">            }<o:p></o: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><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;">        }<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;">        #endregion</span><span style="font-family: Consolas; font-size: 9.5pt;"><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;">"Proprietes"<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;">string</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;">        {<o:p></o: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> { <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;">        }<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;">        #endregion</span><span style="font-family: Consolas; font-size: 9.5pt;"><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;">"Functions"<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: #2b91af;">DataTable</span>FillTable(<span style="color: blue;">string</span> sql)<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;">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;">            {<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: #2b91af;">DataTable</span> tb = <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: #2b91af;">SqlDataAdapter</span> adap = <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;">            }<o:p></o: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><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;">return</span> <span style="color: blue;">null</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;">        }<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;">        #endregion</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="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;">}<o:p></o:p></span></div></div></div></div></div><div style="padding-bottom: 8px; padding-top: 8px;"><b>VB.NET Code</b></div><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;">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;"> JqueryMultipleSelectDropdownlist<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="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><span style="color: blue; font-family: Consolas; font-size: 9.5pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-language: AR-SA; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin;">End</span><span style="font-family: Consolas; font-size: 9.5pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-language: AR-SA; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin;"> <span style="color: blue;">Namespace</span></span></div></div></div></div></div><br />- <b>B3</b>: Download thư viện jquery-ui-multiselect-widget  <a href="https://github.com/ehynds/jquery-ui-multiselect-widget/archive/master.zip" target="_blank">tại đây</a>.<br /><br />- <b>B4</b>: Copy các file Jquery.multiselect.css, Jquery.multiselect.filter.css vào thư mục Styles của Project.<br /><br />- <b>B5</b>: Copy các file Jquery.multiselect.js, Jquery.multiselect.filter.js copy vào thư mục Js của Project.<br /><br />- <b>B6</b>: Mở file Site.Master dạng HTML và bổ xung đoạn mã phía dưới trong thẻ Head<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: 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;">id</span><span style="color: blue;">="Head1"</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;">title</span><span style="color: blue;">></span>Jquery MultipleSelect Dropdownlist with CheckBoxes in ASP.Net<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;">rel</span><span style="color: blue;">="stylesheet"</span><span style="color: red;">href</span><span style="color: blue;">="Styles/Jquery.multiselect.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;">rel</span><span style="color: blue;">="stylesheet"</span><span style="color: red;">href</span><span style="color: blue;">="Styles/Jquery.multiselect.filter.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;">rel</span><span style="color: blue;">="stylesheet"</span><span style="color: red;">type</span><span style="color: blue;">="text/css"</span><span style="color: red;">href</span><span style="color: blue;">="http://ajax.googleapis.com/ajax/libs/jqueryui/1/themes/ui-lightness/jquery-ui.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;">="http://code.jquery.com/jquery-1.9.1.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;">type</span><span style="color: blue;">="text/javascript"</span><span style="color: red;">src</span><span style="color: blue;">="http://ajax.googleapis.com/ajax/libs/jqueryui/1/jquery-ui.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><span style="color: red;">src</span><span style="color: blue;">="Js/Jquery.multiselect.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><span style="color: red;">src</span><span style="color: blue;">="JS/Jquery.multiselect.filter.js"</span><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><br /><div class="MsoNormal" style="margin-bottom: 0.0001pt;">- <b>B7</b>: Mở file Default.aspx dưới dạng HTML và  nhập mã HTML</div><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;"><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;">="Jquery MultipleSelect Dropdownlist with CheckBoxes in ASP.Net"</span> <span style="color: red;">Language</span><span style="color: blue;">="C#"</span><span style="color: red;">MasterPageFile</span><span style="color: blue;">="~/Site.master"</span><span style="color: red;">AutoEventWireup</span><span style="color: blue;">="true"</span><span style="color: red;">CodeBehind</span><span style="color: blue;">="Default.aspx.cs"</span><span style="color: red;">Inherits</span><span style="color: blue;">="JqueryMultipleSelectDropdownlist._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="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="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;">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;">div</span> <span style="color: red;">class</span><span style="color: blue;">="panel panel-default"</span><span style="color: red;">style</span><span style="color: blue;">="</span><span style="color: red;">width</span><span style="color: blue;">:60%;</span><span style="color: red;">height</span><span style="color: blue;">:330px;"></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;">="panel-heading"></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;">h3</span><span style="color: blue;">></span>Jquery MultipleSelect Dropdownlist with CheckBoxes in ASP.Net<span style="color: blue;"></</span><span style="color: maroon;">h3</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><o:p></o: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;">="panel-body"></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;">="0"</span><span style="color: red;">cellspacing</span><span style="color: blue;">="0"</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;">DropDownList</span> <span style="color: red;">ID</span><span style="color: blue;">="ddlObject"</span> <span style="color: red;">runat</span><span style="color: blue;">="server"</span> <span style="color: red;">Width</span><span style="color: blue;">="250"</span> <span style="color: red;">multiple</span><span style="color: blue;">="multiple"></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;">DropDownList</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;">HiddenField</span> <span style="color: red;">ID</span><span style="color: blue;">="hdnObject"</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: red;">&nbsp;&nbsp;</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: red;">id</span><span style="color: blue;">="cmdSubmit"</span> <span style="color: red;">runat</span><span style="color: blue;">="server"</span> <span style="color: red;">OnClick</span><span style="color: blue;">="cmdSubmit_Click"</span> <span style="color: red;">Text</span><span style="color: blue;">="Submit"</span> <span style="color: red;">Causesvalidation</span><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;"></</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;">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: 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><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: 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;">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;">div</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><o:p></o: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;">        <span style="color: blue;">function</span> pageLoad() {<o:p></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;">'#<span style="background: yellow; mso-highlight: yellow;"><%</span>= ddlObject.ClientID <span style="background: yellow; mso-highlight: yellow;">%></span>'</span>).multiselect({<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                header: <span style="color: maroon;">''</span>,<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                close: <span style="color: blue;">function</span> (event, ui) {<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    <span style="color: blue;">var</span> arrObject = $(<span style="color: maroon;">'#<span style="background: yellow; mso-highlight: yellow;"><%</span>= ddlObject.ClientID <span style="background: yellow; mso-highlight: yellow;">%></span>'</span>).multiselect(<span style="color: maroon;">"getChecked"</span>).map(<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;">return</span> <span style="color: blue;">this</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;">                    }).get();<o:p></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;">'#<span style="background: yellow; mso-highlight: yellow;"><%</span>= hdnObject.ClientID <span style="background: yellow; mso-highlight: yellow;">%></span>'</span>).val(arrObject);<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;">            }).multiselectfilter();<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: maroon;">'#<span style="background: yellow; mso-highlight: yellow;"><%</span>= hdnObject.ClientID <span style="background: yellow; mso-highlight: yellow;">%></span>'</span>).val() != <span style="color: maroon;">''</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;">var</span> selected = $(<span style="color: maroon;">'#<span style="background: yellow; mso-highlight: yellow;"><%</span>= hdnObject.ClientID <span style="background: yellow; mso-highlight: yellow;">%></span>'</span>).val().split(<span style="color: maroon;">","</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;">"#<span style="background: yellow; mso-highlight: yellow;"><%</span>=ddlObject.ClientID<span style="background: yellow; mso-highlight: yellow;">%></span> > option"</span>).each(<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;">if</span> ($.inArray(<span style="color: blue;">this</span>.value, selected) > -1) {<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                        $(<span style="color: blue;">this</span>).attr(<span style="color: maroon;">"selected"</span>, <span style="color: maroon;">"selected"</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;">                });<o:p></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;">"#<span style="background: yellow; mso-highlight: yellow;"><%</span>=ddlObject.ClientID<span style="background: yellow; mso-highlight: yellow;">%></span>"</span>).multiselect(<span style="color: maroon;">'refresh'</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;">        };<o:p></o: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><span style="color: blue; font-family: Consolas; font-size: 9.5pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-language: AR-SA; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin;"></</span><span style="color: maroon; font-family: Consolas; font-size: 9.5pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-language: AR-SA; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin;">asp</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-language: AR-SA; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin;">:</span><span style="color: maroon; font-family: Consolas; font-size: 9.5pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-language: AR-SA; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin;">Content</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-language: AR-SA; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin;">></span></div></div></div><br />- <b>B8</b>: Viết Code cho file Default.aspx<br /><div style="padding-bottom: 8px; padding-top: 8px;"><b>C# Code</b></div><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: green; font-family: Consolas; font-size: 9.5pt;">//Visit http://www.laptrinhdotnet.com for more ASP.NET Tutorials</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;">using</span><span style="font-family: Consolas; font-size: 9.5pt;"> Microsoft.VisualBasic;<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;">using</span><span style="font-family: Consolas; font-size: 9.5pt;"> System;<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;">using</span><span style="font-family: Consolas; font-size: 9.5pt;"> System.Collections;<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;">using</span><span style="font-family: Consolas; font-size: 9.5pt;"> System.Collections.Generic;<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;">using</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;"><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">using</span><span style="font-family: Consolas; font-size: 9.5pt;"> System.IO;<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;">using</span><span style="font-family: Consolas; font-size: 9.5pt;"> System.Diagnostics;<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;">using</span><span style="font-family: Consolas; font-size: 9.5pt;"> System.Web.UI;<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;">using</span><span style="font-family: Consolas; font-size: 9.5pt;"> System.Web.UI.WebControls;<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;">using</span><span style="font-family: Consolas; font-size: 9.5pt;"> System.Web.Caching;<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;"> JqueryMultipleSelectDropdownlist<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;">public</span> <span style="color: blue;">partial</span> <span style="color: blue;">class</span> <span style="color: #2b91af;">_Default</span> : System.Web.UI.<span style="color: #2b91af;">Page</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;"><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;">"Bind 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="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">private</span> <span style="color: blue;">void</span>PopulateDropdownlist()<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: #2b91af;">DataTable</span> objBind = <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> (objBind != <span style="color: blue;">null</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 style="color: blue;">if</span> (objBind.Rows.Count > 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;">                    ddlObject.DataTextField = <span style="color: #a31515;">"CategoryName"</span>;<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    ddlObject.DataValueField = <span style="color: #a31515;">"CategoryID"</span>;<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    ddlObject.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;">                    ddlObject.DataBind();<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;">        }<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: #2b91af;">DataTable</span>BindData()<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: #2b91af;">SqlDataProvider</span> objSQL = <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;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: #2b91af;">DataTable</span> objBind = objSQL.FillTable(<span style="color: #a31515;">"Select CategoryID,CategoryName from Categories"</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;">        }<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;">        #endregion</span><span style="font-family: Consolas; font-size: 9.5pt;"><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;">"Event Handles"<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;">void</span>Page_Load(<span style="color: blue;">object</span> sender, System.<span style="color: #2b91af;">EventArgs</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;">        {<o:p></o: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;">            {<o:p></o: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> (!IsPostBack)<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;">                    PopulateDropdownlist();<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;">catch</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;">            }<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;"><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;">void</span>cmdSubmit_Click(<span style="color: blue;">object</span> sender, System.<span style="color: #2b91af;">EventArgs</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;">        {<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">string</span> sMessage = <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;">            sMessage = hdnObject.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;">if</span> (!<span style="color: blue;">string</span>.IsNullOrEmpty(sMessage))<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;">                  lblMessage.Text = <span style="color: #a31515;">"<b>Selected:</b> "</span> + sMessage;<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;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">        #endregion</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="font-family: Consolas; font-size: 9.5pt;">    }<o:p></o:p></span></div><span style="font-family: Consolas; font-size: 9.5pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-language: AR-SA; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin;">}</span></div></div></div></div><div style="padding-bottom: 8px; padding-top: 8px;"><b>VB.NET Code</b></div><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;"><span style="color: green; font-family: Consolas; font-size: 9.5pt;">'Visit http://www.laptrinhdotnet.com for more ASP.NET Tutorials</span><span style="font-family: Consolas; font-size: 9.5pt;"><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;"> JqueryMultipleSelectDropdownlist<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;">"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>PopulateDropdownlist()<o:p></o: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;">            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;">                    <span style="color: blue;">With</span> ddlObject<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                        .DataTextField = <span style="color: #a31515;">"CategoryName"</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                        .DataValueField = <span style="color: #a31515;">"CategoryID"</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;">                    ddlObject.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;">                    ddlObject.DataBind()<o:p></o: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;">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;"><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> objBind <span style="color: blue;">As</span> <span style="color: #2b91af;">DataTable</span> = objSQL.FillTable(<span style="color: #a31515;">"Select CategoryID,CategoryName from Categories"</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;">"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;">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;">                    PopulateDropdownlist()<o:p></o: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>cmdSubmit_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>cmdSubmit.Click<o:p></o: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> sMessage <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;">            sMessage = hdnObject.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;">If</span> sMessage <> <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;">                lblMessage.Text = <span style="color: #a31515;">"<b>Selected:</b> "</span> & sMessage<o:p></o: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="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><span style="color: blue; font-family: Consolas; font-size: 9.5pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-language: AR-SA; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin;">End</span><span style="font-family: Consolas; font-size: 9.5pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-language: AR-SA; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin;"> <span style="color: blue;">Namespace</span></span></div></div></div></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br />Bây giờ chạy Project bạn đã có thể lựa chọn 1 hoặc nhiều giá trị trong danh sách rồi.</div><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjbWp9rBohfH1etuPYZ0hA-1n19oK5zaYmFilmT_FpHcX6nxdwD3hF5CPccjrh_1pq-QBdM_Ok93dhXXGCc_VgzIh7NbrGXkVNkSkd2c-EAfFx8iy6n6SPwNmF09ahnBiepZwYO8lkpEeU/s1600/Jquery-MultipleSelect-Dropdownlist-with-CheckBoxes1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjbWp9rBohfH1etuPYZ0hA-1n19oK5zaYmFilmT_FpHcX6nxdwD3hF5CPccjrh_1pq-QBdM_Ok93dhXXGCc_VgzIh7NbrGXkVNkSkd2c-EAfFx8iy6n6SPwNmF09ahnBiepZwYO8lkpEeU/s1600/Jquery-MultipleSelect-Dropdownlist-with-CheckBoxes1.jpg" /></a></div><div class="separator" style="clear: both; text-align: center;"></div><div style="clear: both; text-align: center;"><div style="float: left; margin: 6px 6px 0px; width: 280px;"><a href="http://adf.ly/1O5NcP" 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 0px; width: 280px;"><a href="http://adf.ly/1O5NiE" 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

Jquery Multiselect DropDownList with CheckBoxes in ASP.Net

( Multiple Select DropDownList with CheckBoxes in ASP.Net ) – Để giải quyết vấn đề cho phép chọn nhiều giá trị đồng thời bạn thường sử dụng ...

Read more »

Sử dụng Bootstrap để thay đổi Style cho Dropdownlist trong Asp.net

<div style="text-align: justify;"><div>(<b>Using Bootstrap to change DropDownList style in ASP.Net</b>) – Theo mặc định khi lựa chọn giá trị trong danh sách Dropdownlist, chương  trình sẽ không đánh dấu giá trị nào đã được người dùng đã chọn. Chính việc  này sẽ gây khó khăn cho người dùng khi sửa và chọn lại giá trị trong Dropdownlist. Bài viết dưới đây sẽ hướng dẫn các bạn cách thay đổi Style để Dropdownlist trông đẹp và chuyên nghiệp hơn, ngoài ra đối với giá trị đã được chọn sẽ được đánh dấu giúp người dùng dễ dàng quan sát hơn.<br /><a name="more"></a><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjzvoAGhGNdUGKdFeeege6j89o6_4MLSZEPbWmBwyrwGj1R5J2-H-76MyUHRam7c61ImqG1ecDPBvQfau0tth5w64MzXS37V-I92cQmUd1CojMcPLSh0Mvu3s6xzMnz-0faMEpiTxn9fLY/s1600/Change-Dropdownlist-Style-ASPNET.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><br /><img border="0" height="237" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjzvoAGhGNdUGKdFeeege6j89o6_4MLSZEPbWmBwyrwGj1R5J2-H-76MyUHRam7c61ImqG1ecDPBvQfau0tth5w64MzXS37V-I92cQmUd1CojMcPLSh0Mvu3s6xzMnz-0faMEpiTxn9fLY/s320/Change-Dropdownlist-Style-ASPNET.jpg" width="320" /></a></div><div class="separator" style="clear: both; text-align: center;"></div><div style="text-align: center;"><b><br /></b><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 style="clear: both; text-align: center;"><div style="float: left; margin: 6px 6px 0px; width: 280px;"><a href="http://adf.ly/1NeXTg" 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 0px; width: 280px;"><a href="http://adf.ly/1NeXRn" 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>: Download CSDL Northwind  tại đây và thực hiện công việc Restore Data.<br /><br />- <b>B2</b>: Tạo Project trong Microsoft Visual Studio 2010<br /><div style="text-align: start;">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.</div><div style="padding-bottom: 8px; padding-top: 8px;"><b>C# Code</b></div><div class="code" id="code" style="text-align: start;"><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;"><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;">using</span><span style="font-family: Consolas; font-size: 9.5pt;"> System;<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;">using</span><span style="font-family: Consolas; font-size: 9.5pt;"> System.Collections.Generic;<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;">using</span><span style="font-family: Consolas; font-size: 9.5pt;"> System.Linq;<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;">using</span><span style="font-family: Consolas; font-size: 9.5pt;"> System.Web;<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;">using</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;">using</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;"><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">using</span><span style="font-family: Consolas; font-size: 9.5pt;"> System.Configuration;<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;"> <o:p></o:p></span><span style="font-family: Consolas; font-size: 9.5pt; line-height: 115%;">UsingBootstrapChangeDropdownlistStyle</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;">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;"><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;">        #region</span><span style="font-family: Consolas; font-size: 9.5pt;"> "Membres Prives"<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;">string</span> _connectionString;<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;">        #endregion</span><span style="font-family: Consolas; font-size: 9.5pt;"><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;"> "Constructeurs"<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> SqlDataProvider()<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;">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;">            {<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;">            }<o:p></o: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><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;">        }<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;">        #endregion</span><span style="font-family: Consolas; font-size: 9.5pt;"><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;"> "Proprietes"<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;">string</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;">        {<o:p></o: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> { <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;">        }<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;">        #endregion</span><span style="font-family: Consolas; font-size: 9.5pt;"><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;"> "Functions"<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: #2b91af;">DataTable</span> FillTable(<span style="color: blue;">string</span> sql)<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;">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;">            {<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: #2b91af;">DataTable</span> tb = <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: #2b91af;">SqlDataAdapter</span> adap = <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;">            }<o:p></o: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><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;">return</span> <span style="color: blue;">null</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;">        }<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;">        #endregion</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="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;">}<o:p></o:p></span></div></div></div></div></div></div></div></div><div style="padding-bottom: 8px; padding-top: 8px;"><b>VB.NET Code</b></div><div class="code" id="code" style="text-align: start;"><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;"><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;">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;"> <o:p></o:p></span><span style="font-family: Consolas; font-size: 9.5pt; line-height: 115%;">UsingBootstrapChangeDropdownlistStyle</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="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><span style="color: blue; font-family: Consolas; font-size: 9.5pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-language: AR-SA; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin;">End</span><span style="font-family: Consolas; font-size: 9.5pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-language: AR-SA; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin;"> <span style="color: blue;">Namespace</span></span></div></div></div></div></div></div></div></div></div></div><br />- <b>B3</b>: Download file bootstrap-select.css -> Copy vào thư mục Styles<br /><br />- <b>B4</b>: Download file bootstrap-select.js -> Copy vào thư mục Js<br /><br /><div class="separator" style="clear: both; text-align: center;"></div>- <b>B5</b>: Mở file Site.Master dạng HTML và bổ xung đoạn mã phía dưới trong thẻ Head<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: 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;">id</span><span style="color: blue;">="Head1"</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;">title</span><span style="color: blue;">></span>Using BootStrap to change DropDownList style in ASP.Net<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;">rel</span><span style="color: blue;">="stylesheet"</span><span style="color: red;">href</span><span style="color: blue;">="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.4/css/bootstrap.min.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;">rel</span><span style="color: blue;">="stylesheet"</span><span style="color: red;">href</span><span style="color: blue;">="Styles/bootstrap-select.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;">type</span><span style="color: blue;">="text/javascript"</span><span style="color: red;">src</span><span style="color: blue;">="https://ajax.googleapis.com/ajax/libs/jquery/1.11.3/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;">type</span><span style="color: blue;">="text/javascript"</span><span style="color: red;">src</span><span style="color: blue;">="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.4/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><span style="color: red;">src</span><span style="color: blue;">="Js/bootstrap-select.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;">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;">></span></div></div></div></div><div style="text-align: start;"><br /></div><div style="text-align: start;">- <b>B6</b>: Mở file Default.aspx dưới dạng HTML và  nhập mã HTML</div><div class="code" id="code" style="text-align: start;"><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;"><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;">="Using Bootstrap to change DropDownList style in ASP.Net"</span> <span style="color: red;">Language</span><span style="color: blue;">="C#"</span><span style="color: red;">MasterPageFile</span><span style="color: blue;">="~/Site.master"</span><span style="color: red;">AutoEventWireup</span><span style="color: blue;">="true"</span><span style="color: red;">CodeBehind</span><span style="color: blue;">="Default.aspx.cs"</span><span style="color: red;">Inherits</span><span style="color: blue;">="UsingBootstrapChangeDropdownlistStyle._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="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="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;">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;">h4</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;">       Using Bootstrap to change DropDownList style 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;">h4</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;">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;">="0"</span><span style="color: red;">cellspacing</span><span style="color: blue;">="0"</span><span style="color: red;">width</span><span style="color: blue;">="60%"></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>Category: <o:p></o: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;">DropDownList</span> <span style="color: red;">ID</span><span style="color: blue;">="ddlObject"</span> <span style="color: red;">runat</span><span style="color: blue;">="server"</span> <span style="color: red;">Width</span><span style="color: blue;">="320px"</span> <span style="color: red;">class</span><span style="color: blue;">="selectpicker show-tick"></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;">DropDownList</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;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">UpdatePanel</span><span style="color: blue;">></span><o:p></o:p></span></div><span style="color: blue; font-family: Consolas; font-size: 9.5pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-language: AR-SA; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin;"></</span><span style="color: maroon; font-family: Consolas; font-size: 9.5pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-language: AR-SA; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin;">asp</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-language: AR-SA; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin;">:</span><span style="color: maroon; font-family: Consolas; font-size: 9.5pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-language: AR-SA; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin;">Content</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-language: AR-SA; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin;">></span></div></div></div></div></div></div></div></div></div></div><div style="text-align: start;"><br /></div><div style="text-align: start;">- <b>B7</b>: Viết Code cho file Default.aspx</div><div style="padding-bottom: 8px; padding-top: 8px; text-align: start;"><b>C# Code</b></div><div class="code" id="code" style="text-align: start;"><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;"><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;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: green; font-family: Consolas; font-size: 9.5pt;">//Visit http://www.laptrinhdotnet.com for more ASP.NET Tutorials</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;">using</span><span style="font-family: Consolas; font-size: 9.5pt;"> Microsoft.VisualBasic;<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;">using</span><span style="font-family: Consolas; font-size: 9.5pt;"> System;<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;">using</span><span style="font-family: Consolas; font-size: 9.5pt;"> System.Collections;<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;">using</span><span style="font-family: Consolas; font-size: 9.5pt;"> System.Collections.Generic;<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;">using</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;"><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">using</span><span style="font-family: Consolas; font-size: 9.5pt;"> System.IO;<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;">using</span><span style="font-family: Consolas; font-size: 9.5pt;"> System.Diagnostics;<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;">using</span><span style="font-family: Consolas; font-size: 9.5pt;"> System.Web.UI;<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;">using</span><span style="font-family: Consolas; font-size: 9.5pt;"> System.Web.UI.WebControls;<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;"> UsingBootstrapChangeDropdownlistStyle<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;">public</span> <span style="color: blue;">partial</span> <span style="color: blue;">class</span> <span style="color: #2b91af;">_Default</span> : System.Web.UI.<span style="color: #2b91af;">Page</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;"><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;">"Bind 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="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">private</span> <span style="color: blue;">void</span>PopulateDropdownlist()<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: #2b91af;">DataTable</span> objBind = <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;">int</span> CategoryID = -1;<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">string</span> CategoryName = <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;">string</span> TotalProducts = <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;">            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 != <span style="color: blue;">null</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 style="color: blue;">if</span> (objBind.Rows.Count > 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 style="color: blue;">for</span>(<span style="color: blue;">int</span> i = 0; i <= objBind.Rows.Count - 1; i++)<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;">if</span> (objBind.Rows[i][<span style="color: #a31515;">"CategoryID"</span>] != <span style="color: blue;">null</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;">                            CategoryID =<span style="color: #2b91af;">Convert</span>.ToInt32(objBind.Rows[i][<span style="color: #a31515;">"CategoryID"</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 style="color: blue;">if</span> (objBind.Rows[i][<span style="color: #a31515;">"CategoryName"</span>] != <span style="color: blue;">null</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;">                            CategoryName = objBind.Rows[i][<span style="color: #a31515;">"CategoryName"</span>].ToString();<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;">if</span>(objBind.Rows[i][<span style="color: #a31515;">"TotalProducts"</span>] != <span style="color: blue;">null</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;">                            TotalProducts = objBind.Rows[i][<span style="color: #a31515;">"TotalProducts"</span>].ToString();<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;">                        ddlObject.Items.Add(<span style="color: blue;">new</span> <span style="color: #2b91af;">ListItem</span>(CategoryName + <span style="color: #a31515;">" ("</span> + TotalProducts + <span style="color: #a31515;">")"</span>, CategoryID.ToString()));<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;">            }<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;"><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: #2b91af;">DataTable</span>BindData()<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: #2b91af;">SqlDataProvider</span> objSQL = <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;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: #2b91af;">DataTable</span> objBind = objSQL.FillTable(<span style="color: #a31515;">"Select Products.CategoryID, Categories.CategoryName, COUNT(Products.ProductID) AS TotalProducts FROM Products INNER JOIN Categories ON Products.CategoryID = Categories.CategoryID GROUP BY Products.CategoryID, Categories.CategoryName ORDER BY Categories.CategoryName"</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;">        }<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;">        #endregion</span><span style="font-family: Consolas; font-size: 9.5pt;"><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;">"Event Handles"<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;">void</span>Page_Load(<span style="color: blue;">object</span> sender, System.<span style="color: #2b91af;">EventArgs</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;">        {<o:p></o: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;">            {<o:p></o: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>(!IsPostBack)<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;">                    PopulateDropdownlist();<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;">catch</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;">            }<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;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">        #endregion</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="font-family: Consolas; font-size: 9.5pt;">    }<o:p></o:p></span></div><span style="font-family: Consolas; font-size: 9.5pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-language: AR-SA; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin;">}</span></div></div></div></div></div></div></div></div></div></div></div><div style="padding-bottom: 8px; padding-top: 8px; text-align: start;"><b>VB.NET Code</b></div><div class="code" id="code" style="text-align: start;"><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;"><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;"><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: green; font-family: Consolas; font-size: 9.5pt;">'Visit http://www.laptrinhdotnet.com for more ASP.NET Tutorials</span><span style="font-family: Consolas; font-size: 9.5pt;"><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;"> UsingBootstrapChangeDropdownlistStyle<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;">"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>PopulateDropdownlist()<o:p></o: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;">            <span style="color: blue;">Dim</span> CategoryID <span style="color: blue;">As</span> <span style="color: blue;">Integer</span> = -1<o:p></o: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> CategoryName <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> TotalProducts <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;">            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;">                    <span style="color: blue;">For</span> i <span style="color: blue;">As</span><span style="color: blue;">Integer</span> = 0 <span style="color: blue;">To</span>objBind.Rows.Count - 1<o:p></o: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(objBind.Rows(i).Item(<span style="color: #a31515;">"CategoryID"</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;">                            CategoryID = objBind.Rows(i).Item(<span style="color: #a31515;">"CategoryID"</span>).ToString<o:p></o: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(objBind.Rows(i).Item(<span style="color: #a31515;">"CategoryName"</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;">                            CategoryName = objBind.Rows(i).Item(<span style="color: #a31515;">"CategoryName"</span>).ToString<o:p></o: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(objBind.Rows(i).Item(<span style="color: #a31515;">"TotalProducts"</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;">                            TotalProducts = objBind.Rows(i).Item(<span style="color: #a31515;">"TotalProducts"</span>).ToString<o:p></o: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;">With</span> ddlObject<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                            .Items.Add(<span style="color: blue;">New</span> <span style="color: #2b91af;">ListItem</span>(CategoryName & <span style="color: #a31515;">" ("</span> & TotalProducts & <span style="color: #a31515;">")"</span>, CategoryID))<o:p></o: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;">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;">            <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;"><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> objBind <span style="color: blue;">As</span> <span style="color: #2b91af;">DataTable</span> = objSQL.FillTable(<span style="color: #a31515;">"Select Products.CategoryID, Categories.CategoryName, COUNT(Products.ProductID) AS TotalProducts FROM Products INNER JOIN Categories ON Products.CategoryID = Categories.CategoryID GROUP BY Products.CategoryID, Categories.CategoryName ORDER BY Categories.CategoryName"</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;">"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;">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;">                    PopulateDropdownlist()<o:p></o: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="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></div></div></div></div></div></div></div></div></div></div></div><div style="clear: both; text-align: center;"><div style="float: left; margin: 6px 6px 0px; width: 280px;"><a href="http://adf.ly/1NeXTg" 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 0px; width: 280px;"><a href="http://adf.ly/1NeXRn" 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="text-align: start;"><br /><br /><br />Chúc các bạn thành công!</div><div style="text-align: start;"><br /></div><div style="text-align: start;">Quang Bình</div></div>

Sử dụng Bootstrap để thay đổi Style cho Dropdownlist trong Asp.net

( Using Bootstrap to change DropDownList style in ASP.Net ) – Theo mặc định khi lựa chọn giá trị trong danh sách Dropdownlist, chương  trình...

Read more »