Showing posts with label SQL. Show all posts

Create stored procedure for paging sorting and searching jQuery DataTables

<div style="text-align: justify;">(<b>Create stored procedure for paging sorting and searching in SQL Server</b>) -Đối với những bảng dữ liệu có số lượng bản ghi nhỏ thì chuyện xử lý khi hiển thị không quá bận tâm, bạn có thể lấy đồng thời tất cả dữ liệu và xử lý trên  client-side. Tuy nhiên với những bảng dữ liệu lớn có đến hàng triệu bản ghi thì việc xử lý khi hiển thị sẽ phải đặc biệt lưu ý đến tốc độ xử lý, đặc biệt khi thực hiện các thao tác như: sắp xếp, phân trang, tìm kiếm dữ liệu. Nếu như việc xử lý không tối ưu sẽ làm người dùng có cảm giác khó chịu mỗi khi thao tác do mất quá nhiều thời gian. Vậy có giải pháp tối ưu nào để lấy dữ liệu trong 1 bảng có số lượng bản ghi lớn không?<br /><a name="more"></a><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjfb3JpBE1PG57ySD0_3Uhwc4dLRpD5PUA3DK_2uk5sBENjRrep59eCDVUrV_Ihlsn771bFYTnHhQVDHdUaM8ZQr_St9qRBA_zZfcT0s9NWiUXa-td1titpjMAj2gjHt1rN8G3Yqlh-vBY/s1600/Microsoft-SQL-Server.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjfb3JpBE1PG57ySD0_3Uhwc4dLRpD5PUA3DK_2uk5sBENjRrep59eCDVUrV_Ihlsn771bFYTnHhQVDHdUaM8ZQr_St9qRBA_zZfcT0s9NWiUXa-td1titpjMAj2gjHt1rN8G3Yqlh-vBY/s1600/Microsoft-SQL-Server.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 /><br />Bài viết dưới đây sẽ hướng dẫn các bạn viết 1 stored procedure để lấy dữ liệu từ bảng Customers trong CSDL Northwind. Mỗi khi thực hiện stored procedure này, nếu không có giá trị tìm kiếm nào được đưa vào thì nó cũng không lấy toàn bộ các bản ghi có trong bảng. Số lượng bản ghi sẽ được lấy căn cứ vào chính đối số @DisplayLength được truyền vào và đây thường chính là số bản ghi/trang. Như vậy với số lượng bản ghi được giới hạn như vậy mỗi khi được yêu cầu thì cho dù số lượng bản ghi có lớn đến mấy thì tốc độ xử lý vẫn sẽ được đảm bảo.<br /><div class="separator" style="clear: both; text-align: center;"><br /></div><span style="text-align: start;">Đây là cấu trúc bảng Customers trong CSDL Northwind</span><br /><span style="text-align: start;"><br /></span><br /><table border="1" bordercolor="#cccccc" cellpadding="3" cellspacing="1" style="border-collapse: collapse; width: 100%px;"><tbody><tr><td align="center" style="width: 31px;"><b>STT</b></td><td align="center" style="width: 159px;"><b>Tên trường</b></td><td align="center" style="width: 108px;"><b>Kiểu trường</b></td><td align="center"><b>Ghi chú</b></td></tr><tr><td align="center">1</td><td>CustomerID</td><td>Int</td><td>Trường tự tăng</td></tr><tr><td align="center">2</td><td>CompanyName</td><td>nvarchar(50)</td><td><br /></td></tr><tr><td align="center">3</td><td>ContactName</td><td>nvarchar(50)</td><td><br /></td></tr><tr><td align="center">4</td><td>ContactTitle</td><td>nvarchar(50)</td><td><br /></td></tr><tr><td align="center">5</td><td>Address</td><td>nvarchar(150)</td><td><br /></td></tr><tr><td align="center">6</td><td>City</td><td>nvarchar(50)</td><td><br /></td></tr><tr><td align="center">7</td><td>Region</td><td>nvarchar(50)</td><td><br /></td></tr><tr><td align="center">8</td><td>PostalCode</td><td>nvarchar(50)</td><td><br /></td></tr><tr><td align="center">9</td><td>Country</td><td>nvarchar(50)</td><td><br /></td></tr><tr><td align="center">10</td><td>Phone</td><td>nvarchar(24)</td><td><br /></td></tr><tr><td align="center">11</td><td>Fax</td><td>nvarchar(24)</td><td><br /></td></tr></tbody></table><span style="text-align: start;"><br /></span><span style="text-align: start;">1. Download CSDL </span><b style="text-align: start;">Northwind</b><span style="text-align: start;"> </span><a href="http://adf.ly/1N0QC3" style="text-align: start;" target="_blank">tại đây</a><span style="text-align: start;"> và thực hiện công việc Restore Data.</span><br /><br /><div style="text-align: start;">2. Tạo stored procedure</div><div style="text-align: start;"><br /></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;"><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: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">CREATE</span><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;"> <span style="color: blue;">proc</span> [dbo]<span style="color: grey;">.</span>[Pro_Customers_List]<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">      @DisplayStart <span style="color: blue;">int</span><span style="color: grey;">=</span>0<span style="color: grey;">,<o:p></o:p></span></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">      @DisplayLength <span style="color: blue;">int</span><span style="color: grey;">=</span>10<span style="color: grey;">,<o:p></o:p></span></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">      @Keyword <span style="color: blue;">nvarchar</span><span style="color: grey;">(</span>255<span style="color: grey;">)</span> <span style="color: grey;">=</span> <span style="color: grey;">NULL,<o:p></o:p></span></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">      @SortField <span style="color: blue;">nvarchar</span><span style="color: grey;">(</span>50<span style="color: grey;">)=</span><span style="color: red;">'CompanyName asc'<o:p></o:p></span></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">as<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">declare</span><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">@strSQL   <span style="color: blue;">nvarchar</span><span style="color: grey;">(</span><span style="color: magenta;">max</span><span style="color: grey;">)<o:p></o:p></span></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">declare</span><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">@strSubSQL   <span style="color: blue;">nvarchar</span><span style="color: grey;">(</span>3500<span style="color: grey;">)<o:p></o:p></span></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">declare</span><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;"> @strWhere <span style="color: blue;">nvarchar</span><span style="color: grey;">(</span>3500<span style="color: grey;">)<o:p></o:p></span></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">declare</span><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">@strSubWhere <span style="color: blue;">nvarchar</span><span style="color: grey;">(</span>3500<span style="color: grey;">)<o:p></o:p></span></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">set</span><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;"> @strSQL<span style="color: grey;">=</span> <span style="color: red;">'SELECT *  FROM '<o:p></o:p></span></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">set</span><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;"> @strSubSQL<span style="color: grey;">=</span> <span style="color: red;">'(Select ROW_NUMBER() over (order by '</span> <span style="color: grey;">+</span> @SortField <span style="color: grey;">+</span> <span style="color: red;">') as RowNumber,COUNT(*) over() as TotalDisplayRows, (SELECT COUNT(*) FROM Customers) AS TotalRecords,CustomerID,CompanyName,ContactName,ContactTitle,Address, City,Region,PostalCode from Customers'<o:p></o:p></span></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">set</span><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">@strSubWhere <span style="color: grey;">=</span><span style="color: red;">' where 1=1'<o:p></o:p></span></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">if</span><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;"> @Keyword<span style="color: grey;"><></span><span style="color: red;">''<o:p></o:p></span></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">      <span style="color: blue;">set</span> @strSubWhere<span style="color: grey;">=</span> @strSubWhere  <span style="color: grey;">+</span><span style="color: red;">' And (CompanyName like N''%'</span> <span style="color: grey;">+</span>@Keyword<span style="color: grey;">+</span><span style="color: red;">'%'' <o:p></o:p></span></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: red; font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">            Or ContactName like N''%'</span><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;"> <span style="color: grey;">+</span>@Keyword<span style="color: grey;">+</span><span style="color: red;">'%'' Or ContactTitle like N''%'</span> <span style="color: grey;">+</span>@Keyword<span style="color: grey;">+</span><span style="color: red;">'%'' <o:p></o:p></span></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: red; font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">            Or Address like N''%'</span><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;"> <span style="color: grey;">+</span>@Keyword<span style="color: grey;">+</span><span style="color: red;">'%'' Or City like N''%'</span> <span style="color: grey;">+</span>@Keyword<span style="color: grey;">+</span><span style="color: red;">'%'')'<o:p></o:p></span></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">set</span><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">@strSubWhere<span style="color: grey;">=</span> @strSubWhere  <span style="color: grey;">+</span><span style="color: red;">') Customers'<o:p></o:p></span></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">set</span><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;"> @strSubSQL<span style="color: grey;">=</span> @strSubSQL <span style="color: grey;">+</span>@strSubWhere <o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">set</span><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;"> @strSQL<span style="color: grey;">=</span>@strSQL <span style="color: grey;">+</span> @strSubSQL<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">set</span><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;"> @strWhere<span style="color: grey;">=</span> <span style="color: red;">' Where 1=1'<o:p></o:p></span></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">set</span><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;"> @strWhere<span style="color: grey;">=</span> @strWhere  <span style="color: grey;">+</span><span style="color: red;">' And RowNumber > '</span><span style="color: grey;">+</span> <span style="color: magenta;">convert</span><span style="color: grey;">(</span><span style="color: blue;">nvarchar</span><span style="color: grey;">,</span>@DisplayStart<span style="color: grey;">)</span> <span style="color: grey;">+</span> <span style="color: red;">' AND RowNumber <='</span><span style="color: grey;">+</span> <span style="color: magenta;">convert</span><span style="color: grey;">(</span><span style="color: blue;">nvarchar</span><span style="color: grey;">,</span>@DisplayStart <span style="color: grey;">+</span>@DisplayLength<span style="color: grey;">)<o:p></o:p></span></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">set</span><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;"> @strSQL<span style="color: grey;">=</span>@strSQL<span style="color: grey;">+</span>@strWhere<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;">print</span><span style="font-family: "Courier New"; font-size: 10.0pt; mso-no-proof: yes;"> @strSQL<o:p></o:p></span></div><span style="color: blue; font-family: "Courier New"; font-size: 10.0pt; 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; mso-no-proof: yes;">exec</span><span style="font-family: "Courier New"; font-size: 10.0pt; 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; mso-no-proof: yes;"> <span style="color: maroon;">sp_executesql</span>@strSQL</span></div></div></div></div></div></div></div></div></div></div><div style="text-align: start;"><br /></div><div style="text-align: start;"><div style="text-align: center;">Bạn có thể tải về bảng cơ sở dữ liệu SQL bằng cách nhấn vào liên kết tải về dưới đây</div><div style="text-align: center;"><a href="http://adf.ly/1O49Vi" imageanchor="1" style="margin-left: 1em; margin-right: 1em;" target="_blank"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjjSAl2gUQVs4bEjPlH2HNe2pqvJ0nbx90zxOlQxI2LaITC7vywa5VwUkAqSm53I7Eqoeuc_S91GCJoSKe_NLG_y2Hpi6k7VfQVtZeJ2Bz60O7uG18gMp_cUMMYOEfdhE6HLFhWDaJ1FAZF/w250-h57-no/Download.jpg" /></a></div>3. Chạy stored procedure<br /><br />- <b>B1</b>: Kích chuột phải vào stored -> Chọn Execute stored procedure<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgr1AAGuCpAxn4i23G_80-GyAVgQ8uVEjoUk_OdQS5KxbVx73n8e0QEZmHRtVF7-VqzbgJvSvBroCklxq9i1tAH9EBXUmD4lVt8WebsXBSZrPfW5JYk5d3OjGN16OfhEwGlF-mxysaZTpI/s1600/Execute-stored+procedure-sql.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgr1AAGuCpAxn4i23G_80-GyAVgQ8uVEjoUk_OdQS5KxbVx73n8e0QEZmHRtVF7-VqzbgJvSvBroCklxq9i1tAH9EBXUmD4lVt8WebsXBSZrPfW5JYk5d3OjGN16OfhEwGlF-mxysaZTpI/s1600/Execute-stored+procedure-sql.jpg" /></a></div><br /><div>- <b>B2</b>: Nhập các thông tin cho các đối số của stored như hình phía dưới</div><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiuj4El2uJe8UKD24Q8-veJX0N-LzM1VBxT9dZ2NpGXn79cFccl-mGRzszBQ9vtoUtPe-FSnFldwn81XmkuadVQFyguxXrBxodMomgY2HQ40fBgupG_3_kvu5ZHk5E-_hK7NTTfx1dZ4MQ/s1600/Execute-stored+procedure-sql1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiuj4El2uJe8UKD24Q8-veJX0N-LzM1VBxT9dZ2NpGXn79cFccl-mGRzszBQ9vtoUtPe-FSnFldwn81XmkuadVQFyguxXrBxodMomgY2HQ40fBgupG_3_kvu5ZHk5E-_hK7NTTfx1dZ4MQ/s1600/Execute-stored+procedure-sql1.jpg" /></a></div><div><br /></div><div>- <b>B3</b>: Chọn OK, bạn sẽ có kết quả phía dưới</div><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjLWhGKaaB5b0YeyyTaKM1xflzC3B_IWxT-QBuxIJcjqyTAKkqRMHxjFFCdrD7Apk1A-8d1JYgVkFPX-21vl9B3QFD2e5e9_fhjlyQoX4O3NlP7zaK6uDceOMhWfFcDkNVitL3XzlhbZ7Y/s1600/Execute-stored+procedure-sql2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjLWhGKaaB5b0YeyyTaKM1xflzC3B_IWxT-QBuxIJcjqyTAKkqRMHxjFFCdrD7Apk1A-8d1JYgVkFPX-21vl9B3QFD2e5e9_fhjlyQoX4O3NlP7zaK6uDceOMhWfFcDkNVitL3XzlhbZ7Y/s1600/Execute-stored+procedure-sql2.jpg" width="550" /></a></div>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>

Create stored procedure for paging sorting and searching jQuery DataTables

( Create stored procedure for paging sorting and searching in SQL Server ) -Đối với những bảng dữ liệu có số lượng bản ghi nhỏ thì chuyện xử...

3:08:00 AM

Hiển thị danh sách toàn bộ bảng và cột trong SQL Server trên Gridview

<div style="text-align: justify;">(<b>List of Tables in Database in SQL Server</b>) –  Bài viết dưới đây sẽ hướng dẫn các bạn các lấy toàn bộ danh sách các bảng trong 1 Database SQL, và danh sách các trường trong 1 bảng dữ liệu được chọn. Toàn bộ danh sách các bảng được hiển thị trong Control Dropdownlist và khi chọn tên bảng tại đây danh sách các cột trong bảng được chọn sẽ hiển thị tại Gridview.<br /><a name="more"></a><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgJk3j3mjUmPyJ8mkn-TOA5OXYMWGAkB6TRiAMcd23PgzUx0cz4aYiahkRBcslyjomY2wPEjvlL9qapKKDiSBzOsI0KF7X89ptTHdOzbbYFyaHapkBd-fH8tany9A_RKinycb6B9N_48jo/s1600/List+of+Tables+in+Database+in+SQL.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgJk3j3mjUmPyJ8mkn-TOA5OXYMWGAkB6TRiAMcd23PgzUx0cz4aYiahkRBcslyjomY2wPEjvlL9qapKKDiSBzOsI0KF7X89ptTHdOzbbYFyaHapkBd-fH8tany9A_RKinycb6B9N_48jo/s1600/List+of+Tables+in+Database+in+SQL.gif" width="550" /></a></div></div><div style="text-align: center;"><br /><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/1NUdqx" 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/1NUdoA" 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: justify;"><div style="margin: 0px;"><div style="text-align: start;"><br /><br /><br />- <b>B1</b>: Download CSDL Northwind<br /><br /></div><div style="text-align: center;"></div></div><div style="text-align: start;">- <b>B2</b>: Tạo Project trong Microsoft Visual Studio 2010</div><div style="text-align: start;"><br /></div><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.<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;"> ListofTablesinDatabase<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;"><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 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;"><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;"> ListofTablesinDatabase<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></span></div><br /><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">End</span><span style="font-family: Consolas; font-size: 9.5pt;"> <span style="color: blue;">Namespace<o:p></o:p></span></span></div></div></div></div></div></div></div></div><div style="text-align: start;"><br />Chú ý: Thuộc tính <b><i>SiteSqlServer</i></b> chính là chuỗi Connect với SQL Server trong file Web.Config</div><div style="text-align: start;"><br /></div><div style="text-align: start;">- <b>B3</b>: Mở file Default.aspx dưới dạng HTML và nhập mã HTML<br /><div class="code" id="code"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><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;">="List of Tables in Database in Gridview"</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;">="ListofTablesinDatabase._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;">="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;">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;">        List of Tables in Database in Gridview<o:p></o: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><o:p></o: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;">="2"</span><span style="color: red;">cellspacing</span><span style="color: blue;">="3"</span><span style="color: red;">width</span><span style="color: blue;">="100%"></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;"><</span><span style="color: maroon;">tr</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    <span style="color: blue;"><</span><span style="color: maroon;">td</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                        <span style="color: blue;"><</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">Label</span> <span style="color: red;">ID</span><span style="color: blue;">="plTableName"</span> <span style="color: red;">runat</span><span style="color: blue;">="server"</span> <span style="color: red;">Text</span><span style="color: blue;">="Table Name"></</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">Label</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                         <span style="color: blue;"><</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">DropDownList</span> <span style="color: red;">ID</span><span style="color: blue;">="ddlTables"</span><span style="color: red;">AutoPostBack</span><span style="color: blue;">="true"</span><span style="color: red;">OnSelectedIndexChanged</span><span style="color: blue;">="ddlTables_SelectedIndexChanged"</span><span style="color: red;">CssClass</span><span style="color: blue;">="form-control"</span><span style="color: red;">runat</span><span style="color: blue;">="server"</span><span style="color: red;">Width</span><span style="color: blue;">="250px"></span><o:p></o: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;">tr</span><span style="color: red;">id</span><span style="color: blue;">="trMessage"</span><span style="color: red;">runat</span><span style="color: blue;">="server"</span><span style="color: red;">visible</span><span style="color: blue;">="false"></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    <span style="color: blue;"><</span><span style="color: maroon;">td</span><span style="color: red;">colspan</span><span style="color: blue;">="2"></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                        <span style="color: blue;"><</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">Label</span> <span style="color: red;">ID</span><span style="color: blue;">="lblMessage"</span> <span style="color: red;">runat</span><span style="color: blue;">="server"</span> <span style="color: red;">Text</span><span style="color: blue;">="No Data"></</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">Label</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    <span style="color: blue;"></</span><span style="color: maroon;">td</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;"></</span><span style="color: maroon;">tr</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;"><</span><span style="color: maroon;">tr</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    <span style="color: blue;"><</span><span style="color: maroon;">td</span><span style="color: red;">colspan</span><span style="color: blue;">="2"></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                        <span style="color: blue;"><</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">GridView</span> <span style="color: red;">ID</span><span style="color: blue;">="grvObject"</span> <span style="color: red;">runat</span><span style="color: blue;">="server"</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                            <span style="color: red;">CssClass</span><span style="color: blue;">="GridStyle"</span><span style="color: red;">BorderColor</span><span style="color: blue;">="#cbcbcb"</span><span style="color: red;">BorderStyle</span><span style="color: blue;">="solid"</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                            <span style="color: red;">BorderWidth</span><span style="color: blue;">="1"</span><span style="color: red;">AutoGenerateColumns</span><span style="color: blue;">="true"</span><span style="color: red;">width</span><span style="color: blue;">="100%"></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                            <span style="color: blue;"><</span><span style="color: maroon;">AlternatingRowStyle</span><span style="color: red;">CssClass</span><span style="color: blue;">="GridStyle_AltRowStyle"</span><span style="color: blue;">/></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                            <span style="color: blue;"><</span><span style="color: maroon;">HeaderStyle</span> <span style="color: red;">CssClass</span><span style="color: blue;">="GridStyle_HeaderStyle"</span><span style="color: blue;">/></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                            <span style="color: blue;"><</span><span style="color: maroon;">RowStyle</span> <span style="color: red;">CssClass</span><span style="color: blue;">="GridStyle_RowStyle"</span><span style="color: blue;">/></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                            <span style="color: blue;"><</span><span style="color: maroon;">pagerstyle</span> <span style="color: red;">cssclass</span><span style="color: blue;">="GridStyle_pagination"</span> <span style="color: blue;">/></span>               <o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                        <span style="color: blue;"></</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">GridView</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    <span style="color: blue;"></</span><span style="color: maroon;">td</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;"></</span><span style="color: maroon;">tr</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;"></</span><span style="color: maroon;">table</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;"></</span><span style="color: maroon;">ContentTemplate</span><span style="color: blue;">></span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">    <span style="color: blue;"></</span><span style="color: maroon;">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 class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: start;"><span style="font-family: Consolas; font-size: 9.5pt;"><span style="color: blue;"><o:p></o:p></span></span></div><div style="text-align: start;"><span style="font-family: Consolas; font-size: 9.5pt;"><span style="color: blue;"><br /></span></span>- <b>B4</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;"><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.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.UI.HtmlControls;<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;"><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;"> ListofTablesinDatabase<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;">"Private Methods"<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;">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;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: #2b91af;">DataTable</span> objBind = objSQL.FillTable(<span style="color: #a31515;">"SELECT * FROM information_schema.tables"</span>);<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            ddlTables.DataTextField = <span style="color: #a31515;">"Table_Name"</span>;<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            ddlTables.DataValueField = <span style="color: #a31515;">"Table_Name"</span>;<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            ddlTables.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;">            ddlTables.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;"><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;">"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: #2b91af;">DataTable</span>BindData(<span style="color: blue;">string</span> TableName)<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;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: #2b91af;">DataTable</span> objBind = objSQL.FillTable(<span style="color: #a31515;">"Select C.COLUMN_NAME as 'Column name', C.DATA_TYPE as 'Data type', C.CHARACTER_MAXIMUM_LENGTH as 'Character maximum length', C.IS_NULLABLE as 'IsNullable' , TC.CONSTRAINT_NAME as 'Constraint Name' From INFORMATION_SCHEMA.COLUMNS As C Left Join INFORMATION_SCHEMA.TABLE_CONSTRAINTS As TC On TC.TABLE_SCHEMA = C.TABLE_SCHEMA And TC.TABLE_NAME = C.TABLE_NAME And TC.CONSTRAINT_TYPE = 'PRIMARY KEY' Where C.TABLE_NAME ='"</span> + TableName + <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;">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="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">private</span> <span style="color: blue;">void</span>BindColumns()<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;">string</span> TableName = ddlTables.SelectedValue;<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(TableName);<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;">                    grvObject.DataSource = objBind;<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    grvObject.DataBind();<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    trMessage.Visible = <span style="color: blue;">false</span>;<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    grvObject.Visible = <span style="color: blue;">true</span>;<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                }<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;">else</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                {<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    trMessage.Visible = <span style="color: blue;">true</span>;<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    grvObject.Visible = <span style="color: blue;">false</span>;<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                }<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                updatePanel.Update();<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            }<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;">                    BindColumns();<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>ddlTables_SelectedIndexChanged(<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;">            BindColumns();<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;"> </span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">    }</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 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;"><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;">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;"><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;"> ListofTablesinDatabase<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;">"Private Methods"</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">Private</span> <span style="color: blue;">Sub</span>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> objSQL <span style="color: blue;">As</span> <span style="color: blue;">New</span> <span style="color: #2b91af;">SqlDataProvider</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">Dim</span> objBind <span style="color: blue;">As</span> <span style="color: #2b91af;">DataTable</span> = objSQL.FillTable(<span style="color: #a31515;">"SELECT * FROM information_schema.tables"</span>)<o:p></o: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> ddlTables<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;">"Table_Name"</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;">"Table_Name"</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                .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;">                .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;">With</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">End</span> <span style="color: blue;">Sub</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">#End</span><span style="font-family: Consolas; font-size: 9.5pt;"> <span style="color: blue;">Region</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">#Region</span><span style="font-family: Consolas; font-size: 9.5pt;"> <span style="color: #a31515;">"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;">Function</span>BindData(<span style="color: blue;">ByVal</span> TableName <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;">Dim</span> objSQL <span style="color: blue;">As</span> <span style="color: blue;">New</span> <span style="color: #2b91af;">SqlDataProvider</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">Dim</span> objBind <span style="color: blue;">As</span> <span style="color: #2b91af;">DataTable</span> = objSQL.FillTable(<span style="color: #a31515;">"Select C.COLUMN_NAME as 'Column name', C.DATA_TYPE as 'Data type', C.CHARACTER_MAXIMUM_LENGTH as 'Character maximum length', C.IS_NULLABLE as 'IsNullable' , TC.CONSTRAINT_NAME as 'Constraint Name' From INFORMATION_SCHEMA.COLUMNS As C Left Join INFORMATION_SCHEMA.TABLE_CONSTRAINTS As TC On TC.TABLE_SCHEMA = C.TABLE_SCHEMA And TC.TABLE_NAME = C.TABLE_NAME And TC.CONSTRAINT_TYPE = 'PRIMARY KEY' Where C.TABLE_NAME ='"</span> & TableName & <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;">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="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">Private</span> <span style="color: blue;">Sub</span>BindColumns()<o:p></o: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> TableName <span style="color: blue;">As</span> <span style="color: blue;">String</span> = ddlTables.SelectedValue<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(TableName)<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">If</span> <span style="color: blue;">Not</span> objBind <span style="color: blue;">Is</span> <span style="color: blue;">Nothing</span> <span style="color: blue;">Then</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;">If</span> objBind.Rows.Count > 0 <span style="color: blue;">Then</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    grvObject.DataSource = objBind<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    grvObject.DataBind()<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    trMessage.Visible = <span style="color: blue;">False</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    grvObject.Visible = <span style="color: blue;">True</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;">Else</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    trMessage.Visible = <span style="color: blue;">True</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                    grvObject.Visible = <span style="color: blue;">False</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                <span style="color: blue;">End</span> <span style="color: blue;">If</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">                updatePanel.Update()<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            <span style="color: blue;">End</span> <span style="color: blue;">If</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">        <span style="color: blue;">End</span> <span style="color: blue;">Sub</span><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="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;">                    BindColumns()<o:p></o: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>ddlTables_SelectedIndexChanged(<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>ddlTables.SelectedIndexChanged<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-family: Consolas; font-size: 9.5pt;">            BindColumns()<o:p></o: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></div></div></div></div></div></div></div><div style="text-align: start;"><br /></div>Bây giờ chạy Project bạn sẽ có kết quả như ảnh phía dưới.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiMxWakIQ7g5Tt1zKCr1E24AfQ9hD3_0Fbaohz3ZiyLNbikn6d5hyphenhyphenDOevt97fh5y0bVZdQ6szcQ5cylDtLqOQQJZX5QnLpRBG5x5OHuCH44iD1fc77B32LVRphvMgcgtsWn3jWwL7TQ4vU/s1600/List+of+Tables+in+Database+in+SQL_Main.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiMxWakIQ7g5Tt1zKCr1E24AfQ9hD3_0Fbaohz3ZiyLNbikn6d5hyphenhyphenDOevt97fh5y0bVZdQ6szcQ5cylDtLqOQQJZX5QnLpRBG5x5OHuCH44iD1fc77B32LVRphvMgcgtsWn3jWwL7TQ4vU/s1600/List+of+Tables+in+Database+in+SQL_Main.gif" width="550" /></a></div><div style="text-align: start;"><div style="clear: both; text-align: center;"><div style="float: left; margin: 6px 6px 0px; width: 280px;"><a href="http://adf.ly/1NUdqx" 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/1NUdoA" 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!</div><div style="text-align: start;"><br /></div><div style="text-align: start;">Quang Bình</div></div>

Hiển thị danh sách toàn bộ bảng và cột trong SQL Server trên Gridview

( List of Tables in Database in SQL Server ) – Bài viết dưới đây sẽ hướng dẫn các bạn các lấy toàn bộ danh sách các bảng trong 1 Database S...

10:10:00 AM

Subscribe to: Posts ( Atom )