How To Use ALTER TABLE in SQL Server

Sometime you want to modify exists table in database. You don't want to delete and recreate. So in SQL Server we can use Alter Table to modify table. We can delete columns, add new columns, modify columns name, modify datatype.

Please follow below scripts:

1. Add Column

Syntax: Alter Table TableName ADD NewField DataType

EX: Alter Table tbl_Staff Add DOB DateTime

How to know Last Backup Date in SQL Server

My friend asked me about one problem in SQL Server. He cannot find the last backup date in SQL Server. He asked me help him find scripts to query last backup date. I try a few days for find this scripts. Finally I found one scripts that can query this data.

How to Remove Pagefile.sys on Hard Disk

I have a problem with my laptop, in drive C has grew up without reason. I tried to find all folders but didn’t see big file or folder. I have wondered why my hard drive is growing up like this. Then I found the cause of this issued. This problem is happened by has pagefile.sys in drive C. What is pagefile.sys? Pagefile.sys is the “Virtual Memory” or “Swap Space” that it come from RAM when not currently begin used. I never delete this file, now its size is 8GB. To solves this issued we can reduce its size or don’t allow to have this file in hard disk.

How to Find Empty Table in SQL Server

Today I have a good tip to share about find empty table in SQL Server. Sometime you created table in database, but you didn’t insert any rows. Once day you want to optimize or want to delete some table, you should run this query to know which empty table. It is necessary to clarifies the empty table for prevent lost your data before you delete it.

5 Ways to Improve Computer performance

This topic will guide you to improve your computer speed. After you read this tips you are able to fix when your computer going to slow. Because when we use computer everyday it will be grow of unnecessary file and have a lot case to make your computer slowly. You didn't know there are a lot of service is running when we use computer for other work. Some services also run while computer no need. So we need to know how to stop those services. But first we must know why and what the

5 Ways to Improve Execution Query in SQL Server

SQL Server is the popular products to store data in database. When the database growth up to large we need to care about two things. The first we must care about security. We could make schedule to backup and set policy to the user. And the second we should know when the data is large we will has problem with queries data from database. Why it make queries data slowly? Because it has a lot record, need take time to find data that we want. To increase performance of query in database is not

How to resolve Selected Partition Error 0x8007045d

Many users met the selected partition error 0x8007045d when they used SATA hard drive. This problem is missing boot file in the system. If we met this problem please try this solution.

Try open window in safe mode and copy necessary data. If we can’t open computer in safe mode please try with third party application to open window.

 

How to Make High Security in MS SQL Server

Security is very important think that we need to know and careful on your data. As you know data in each organization is kept secret. They don’t allow someone know except theirs staff. Another thing they must prevents the data lost. If your data are stolen it effect to your organization because they will know your secret data. How to prevent above problem? Here are some tips to make high security to prevent your data from hacker or other person that want to steal your data. To make high security on MS SQL Server there are 2 things. One is prevent someone steal and prevent it lost.

MS SQL Server with Khmer Unicode

MS SQL Server is a product of Microsoft that we use it for store data, information and we can easy find that data when you need. MS SQL Server is the database application for manage data or any information of organization. If we compare with MS Access we can say MS SQL Server is better because MS SQL Server have more features, tools, function than MS Access in manage data.  Today I have one topic to share you about how to make MS SQL Server support with Khmer Unicode.

Make MySQL support Khmer Unicode

Hi everyone today I write one topic about MySQL why it doesn’t support Khmer Unicode.  It depends on version of MySQL too. The new version of MySQL is support with Khmer Unicode just change Collation to UFT-8 like this picture when you create.

Resolve problem install .Net Framework (HRESULT 0xc8000222)

When your install Visual Studio it will install .Net Framework. In case it has the problem (HRESULT 0xc8000222). How can solve it? Please see the solution below:

    - Click Start => Run => Type cmd => Press Enter command prompt will appear

    - Then type net stop WuAuServ in Command prompt => Click Enter

    - Click Start => Run => Type %windir% => Press Enter it will open Window explorer 

    - Find and rename folder SoftwareDistribution to new name(Ex: SoftDold)

    - Click Start => Run => Type cmd => Press Enter command prompt will appear

    - Then type net start WuAuServ

Then please install again. 

Wish this topic can helps you and if have anything issue please comment. 

How to Create Yahoo Account

Yahoo is the popular company that provides email services to all people in the world. So if we want to use theirs service, we need to register. After you register we can send email to our friend, relative, or our customer. Yahoo have many service like Yahoo Messenger for make chat to our friend. In using the Yahoo mail is easy use and understands about tools and feature. The best thing for Yahoo mail is high security. It mean you don’t worry to lost our email and don’t care about our email is stolen. So let go to follow below step to create Yahoo mail.

Understanding about Features of WordPress

WordPress is more powerful to build and update website. Functionality of WordPress is very easy to install and use (More detail: http://kh-code.blogspot.com/2014/12/easy-to-install-wordpress.html). There are many useful tools to design and update your contents. Why many people like to use WordPress for build theirs website? The easy answer because WordPress is easy to install and update your content events you don’t know the code or any programming language. But before you create website using WordPress you need to know about tools and features.

How to Share File in Google Drive

Google Drive is a product of Google. It is important to store your data that you don’t worry to lost data and you can access it everywhere that have internet connect. In the previous topic I wrote one topic about How to create and Use Google Drive but it has other option that I need to show in this topic. In Google Drive have one option that you can share your data file like document, PDF, image to your friend without using flash to copy or attach by email.

Easy to Install WordPress

Nowadays, there is a lot of website in the world that show information of theirs company or personal information of people. The websites are created for show information, services, and products of company and the people can know about everything of company by go to visit the website. How to easy to create website? There are many ways to create website, but you should choose one way that easy and fast to create it. Now I guide you to use WordPress to create website that it easy and fast. What is WordPress? WordPress is the CMS (Content Management System) like Joomla, Drupal and we use it to create website

How to Create and Use Google Drive

       What is Google Drive? Google Drive is one of product’s Google. It is the place that provide by Google to store documents, PDF and image file that we can access from anywhere via internet. There are two way to access Google Drive. We can access by web browser and we can install application in computer or mobile also. After we install Google Drive application in computer and mobile we can easy to create, upload, download, delete, prints your documents that have in Google Drive. Please follow below step to create account in Google Drive.

Easy Way to Create Gmail Account

Gmail is the one product of Google Company.  People in the world has been created Gmail account to contacts to other people for communication, businesses, chat or created to use another products of Google that it requite to have Gmail account. To create Gmail account is very easy and quick. After you created Gmail account you can access to other products of Google such as: Google+, YouTube, Chat etc.

So Gmail account is very important for you to use. Here is the easy way to create Gmail account. Please follow below step:

Use Select Case In SQL Server

In Sql Server you can use Select Case for select data from table
bye use Select Case. It is importance to use because you can used it
for select data that have complicate condition.

Please see example as below:

SELECT title, price,
Budget = CASE price
WHEN price > 20.00 THEN 'Expensive'
WHEN price BETWEEN 10.00 AND 19.99 THEN 'Moderate'
WHEN price <>
ELSE 'Unknown'
END,
FROM titles

In this example, price is a condition that we want to show Message by quality of price

Count String In SQL Server

T-SQL is the language for find data in database. It can insert, search, update and delete all data. We also can join table or find complexly data(data in other table). we also use T-SQL to make application or function to run in database. Today I want to know some knowledge about count string in SQL Server.

Ex: We have string as below

@str='9-9-99-99-999'

We want to count symbol (-) in this string
Please write this statement:

Declare @countStr varchar(100)
Set @countStr=Len(Replace(@str,'9',''))
Print @countStr

It will show result =4

I will have other tips about SQL Server to share. If you have any problem please comment. I will try to help and find the solution for you.

How To Put Symbol Into Table In C#(ASP.Net)

Insert symbol into table in database isn't easy. There are many developer know about it. When I meet this problem I search a long time to find the way for completed this task. Finally I found the solution that very easy.

The solution just add some property in page design as code below:

<@ Page Language="C#" AutoEventWireup="true" CodeBehind="CustomerExtraField.aspx.cs" Inherits="System" ValidateRequest="false" %>

When you add this properties you will can insert symbol in table.

Create Dynamic AJAX Control - Calendar Extender

If you want to create Ajax Control Toolkit- Calendar Extender please follow
code below:

// Create a textbox to hold the date
TextBox dateValue = new TextBox();
dateValue.ID = "dateValue";

// Create the calendar extender
AjaxControlToolkit.CalendarExtender ajaxCalendar =
  new AjaxControlToolkit.CalendarExtender();
ajaxCalendar.ID = "ajaxCalendar";
ajaxCalendar.Format = "MM/dd/yyyy";
ajaxCalendar.TargetControlID = dateValue.ID;

placeHolder1.Controls.Add(dateValue);
placeHolder1.Controls.Add(ajaxCalendar);

In the ASPX, I have just a simple PlaceHolder where I append the dynamically created controls:

<asp:placeholder id="placeHolder1" runat="server">
asp:placeholder>

Please see picture below:

How to Visible Field of GridView in C#

While I develop application using ASP.Net with C#, I want to share small knowledge to visible unnecessary fields in GridView. Sometime you don't want to show some data in interface, but you still can use theirs values. It just high on the form. Please see code below to visible field in gridview:

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
        e.Row.Cells[1].Visible = false;
}

- e.Row.Cells[1].Visible is the field index that you want to visible.

In page design of GridView:

OnRowDataBound="GridView1_RowDataBound"

When you run code, it will not see field index No1. and you can also add other field in gridview.

How to Convert Text To Number In SQL Server

In Sql Server we can convert text to number by use two properties.
If table column is VARCHAR and has all the numeric values in it, it can be retrieved as Integer using CAST or CONVERT function.

1. CAST

Please see example below:

SELECT CAST(YourVarcharCol AS INT) FROM Table

it mean you can convert text to number by use CAST then select field in table that you want to
select and assign data type.

2. CONVERT

SELECT CONVERT(INT, YourVarcharCol) FROM Table

Two properties have different in used.
so if you want which properties you msut see Syntax clearly.

How to Create Class For Encrypt and Decrypt Password In C#

If you want to Encrypt and Decrypt password when insert into table
you can use code below:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Security.Cryptography;
using System.Configuration;

namespace EnCryptDecrypt
{
class CryptorEngine
{
public static string Encrypt(string toEncrypt, bool useHashing)
{
byte[] keyArray;
byte[] toEncryptArray = UTF8Encoding.UTF8.GetBytes(toEncrypt);

System.Configuration.AppSettingsReader settingsReader = new AppSettingsReader();
string key = (string)settingsReader.GetValue("SecurityKey", typeof(String));

if (useHashing)
{
MD5CryptoServiceProvider hashmd5 = new MD5CryptoServiceProvider();
keyArray = hashmd5.ComputeHash(UTF8Encoding.UTF8.GetBytes(key));
hashmd5.Clear();
}
else
keyArray = UTF8Encoding.UTF8.GetBytes(key);

TripleDESCryptoServiceProvider tdes = new TripleDESCryptoServiceProvider();
tdes.Key = keyArray;
tdes.Mode = CipherMode.ECB;
tdes.Padding = PaddingMode.PKCS7;

ICryptoTransform cTransform = tdes.CreateEncryptor();
byte[] resultArray = cTransform.TransformFinalBlock(toEncryptArray, 0, toEncryptArray.Length);
tdes.Clear();
return Convert.ToBase64String(resultArray, 0, resultArray.Length);
}

public static string Decrypt(string cipherString, bool useHashing)
{
byte[] keyArray;
//byte[] toEncryptArray = Convert.FromBase64String(cipherString); Original coding

byte[] toEncryptArray = Convert.FromBase64String(cipherString);

System.Configuration.AppSettingsReader settingsReader = new AppSettingsReader();
string key = (string)settingsReader.GetValue("SecurityKey", typeof(String));

if (useHashing)
{
MD5CryptoServiceProvider hashmd5 = new MD5CryptoServiceProvider();
keyArray = hashmd5.ComputeHash(UTF8Encoding.UTF8.GetBytes(key));
hashmd5.Clear();
}
else
keyArray = UTF8Encoding.UTF8.GetBytes(key);

TripleDESCryptoServiceProvider tdes = new TripleDESCryptoServiceProvider();
tdes.Key = keyArray;
tdes.Mode = CipherMode.ECB;
tdes.Padding = PaddingMode.PKCS7;

ICryptoTransform cTransform = tdes.CreateDecryptor();
byte[] resultArray = cTransform.TransformFinalBlock(toEncryptArray, 0, toEncryptArray.Length);

tdes.Clear();
return UTF8Encoding.UTF8.GetString(resultArray);
}
}
}

How to call in c#?

string textpassword = txtPassword.Text.Trim();
string cipherText = EnCryptDecrypt.CryptorEngine.Encrypt(textpassword, true);
value of password is cipherText

If it have error please copy code below into Web.config in the

Count Sundays Between Two Dates

Once day I developed one application, the system required to count number of Sundays between duration of date. I tried for 2 hour to find solution to get number of Sundays. And after I finished my work I want to share this tip to other developer. I wrote the scripts to count, we just input parameter @StartDate and @EndDate, it will show result.

Please run this code and test your self. 

declare @StartDate datetime, @EndDate datetime

set @StartDate = '2009-01-01'

set @EndDate = '2010-06-01'



Select Sundays=Count(*) From (Select Top (Datediff (day, @StartDate, @EndDate) +1)

[Date] = dateadd(day, ROW_NUMBER()

Over(order by c1.name, c2.name), convert(char(10),@StartDate-1,110))

From sys.columns c1

cross join sys.columns c2) x

Where datepart(dw,[Date]) = 1;

-----------------------------------------------------------------------------------------------

Output: Number of sundays between two date is 74 sundays.

How to Show Data In TreeView

It you have some data in table and want to show it in TreeView
You can write code below:
1. tbl_Data have have data below:
2. Then please write code below:
TreeView1.Nodes.Clear();
private void showtreeview()
SqlCommand cmd= new SqlCommand ();
cmd.Connection =conn;
cmd.CommandType=CommandType.Text;
cmd.CommandText = "Select * from tbl_data order by Leve";
SqlDataReader sqlDR = cmd.ExecuteReader();

TreeView1.Nodes.Clear();

int lvCode = 0;

while (sqlDR.Read())
{
TreeNode tn = new TreeNode();
tn.Text = sqlDR["Level"].ToString() + "-" + sqlDR["Text"].ToString();
tn.Value = sqlDR["Level"].ToString();

if (sqlDR["Level"].ToString().Equals("1")){

TreeView1.Nodes.Add(tn);
TreeView1.Nodes[TreeView1.Nodes.Count - 1].Select();

}else
{
if ( lvCode 0)
{
TreeView1.SelectedNode.ChildNodes "+
" [TreeView1.SelectedNode.ChildNodes.Count-1].Select();
}
}
else if (lvCode > int.Parse(sqlDR["Level"].ToString()))
{
TreeView1.SelectedNode.Parent.Select();
}


TreeView1.SelectedNode.ChildNodes.Add(tn);
}
lvCode = int.Parse(sqlDR["Level"].ToString());


}
}

3. When already to finish your code you can run it.

How to Convert Null Value To Number In SQL Server

Do you know, or you can calculate Null value in SQL Server or not?
when you select some data from table of database, sometime you get
null value. but you want to use this value for calculate to other values.
The solution, you must convert null value to numeric value when your
data is null value.

How to Compare Date Time In C#

This article for know about during of start date and end date.
Example: StartDate= 10/05/2009 and EndDate= 15/05/2009
You want to know about during of 2 date. how do you do?
and you want to know which first and which last.
If you want to do it please see code below:

1. Find during of this date.

DateTime startDate= new DateTime();
DateTime endDate=new DateTime();

startDate=Convert.ToDateTime(txtStartDate.Text);
endDate=Convert.ToDateTime(txtEndDate.Text);

int during= endDate-startDate;

Response.Write(during.ToString());

But this code for find during that in the same month and the same year.
can not calculate in different year and month. But we can compare date time
by using function of C#.

2. Compare Date Time

DateTime startDate= new DateTime();
DateTime endDate=new DateTime();

startDate=Convert.ToDateTime(txtStartDate.Text);
endDate=Convert.ToDateTime(txtEndDate.Text);

int during =endDate.CompareTo(startDate);

if (startDate > endDate)
{
Response.Write("Start Date is big");
}
else
{
Response.Write("Start Date is Small");
}

How to Show Value From Select Multi Record In SQL

This code for show each values that you select many record
from sql server.

please see code below:

string str="select Name form tblName where ID between 1 and 5";
Sqlcommand cmd=new Sqlcommand(str,connection);
DataReader Dreader=cmd.ExecuteReader();

While (Dreader.Read())
{
if (DReader["ID"].ToString().Equals("1")) txtName1.Text = DReader["Name"].ToString();
if (DReader["ID"].ToString().Equals("2")) txtName2.Text = DReader["Name"].ToString();
if (DReader["ID"].ToString().Equals("3")) txtName3.Text = DReader["Name"].ToString();
if (DReader["ID"].ToString().Equals("4")) txtName4.Text = DReader["Name"].ToString();
if (DReader["ID"].ToString().Equals("5")) txtName5.Text = DReader["Name"].ToString();

}
Dreader.Close();

How to Date Time Format In SQL Server

SQL Server provides a number of options you can use to
format a date/time string. One of the first considerations
is the actual date/time needed. The most common is the
current date/time using getdate(). This provides the
current date and time according to the server providing
the date and time. If a universal date/time is needed,
then getutcdate() should be used. To change the format
of the date, you convert the requested date to a string
and specify the format number corresponding to the
format needed. Below is a list of formats and an example
of the output:

DATE FORMATS
-------------------------------------------------------------------------------------
Format # |Query (current date: 12/30/2006) | Sample
-------------------------------------------------------------------------------------
1 | select convert(varchar, getdate(), 1) | 12/30/06
2 | select convert(varchar, getdate(), 2) | 06.12.30
3 | select convert(varchar, getdate(), 3) | 30/12/06
4 | select convert(varchar, getdate(), 4) | 30.12.06
5 | select convert(varchar, getdate(), 5) | 30-12-06
6 | select convert(varchar, getdate(), 6) | 30 Dec 06
7 | select convert(varchar, getdate(), 7) | Dec 30, 06
10 | select convert(varchar, getdate(), 10) | 12-30-06
11 | select convert(varchar, getdate(), 11) | 06/12/30
101 | select convert(varchar, getdate(), 101) | 12/30/2006
102 | select convert(varchar, getdate(), 102) | 2006.12.30
103 | select convert(varchar, getdate(), 103) | 30/12/2006
104 | select convert(varchar, getdate(), 104) | 30.12.2006
105 | select convert(varchar, getdate(), 105) | 30-12-2006
106 | select convert(varchar, getdate(), 106) | 30 Dec 2006
107 | select convert(varchar, getdate(), 107) | Dec 30, 2006
110 | select convert(varchar, getdate(), 110) | 12-30-2006
111 | select convert(varchar, getdate(), 111) | 2006/12/30
-------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------

TIME FORMAT
-------------------------------------------------------------------------------------
8 or 108 | select convert(varchar, getdate(), 8) | 00:38:54
9 or 109 | select convert(varchar, getdate(), 9) | Dec 30 2006 12:38:54:840AM
14 or 114 | select convert(varchar, getdate(), 14) | 00:38:54:840
-------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------

SAMPLE STATEMENT
-------------------------------------------------------------------------------------
select replace(convert(varchar, getdate(),101),'/','') | 12302006
select replace(convert(varchar, getdate(),101),'/','') + | replace(convert(varchar, getdate(),108),':','') 12302006004426
-------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------

GETDATE() is field that datetime

How to Store Procedure for Update Multi Record In Table

You can update multi record by using store procedure.
If is very easy and good processes, you not write store procedure
a lot of store procedure for update data a lot of row. but if you know about
update multi data you can reduce of write store procedure.
please see store procedure below:


ALTER PROCEDURE [dbo].[Pro_UpdateTblOption]
@optionOne varchar(50),
@optionTwo varchar(50),
@optionThree varchar(50),
@optionFour varchar(50),
@optionFive varchar(50),
@SMS varchar(30) Output
AS
Update tbl_Option Set parametervalue = @optionOne
Where optionID=1;
Update tbl_Option Set parametervalue = @optionTwo
Where optionID=2;
Update tbl_Option Set parametervalue = @optionThree
Where optionID=3;
Update tbl_Option Set parametervalue = @optionFour
Where optionID=4;
Update tbl_Option Set parametervalue = @optionFive
Where optionID=5;
Set @SMS='Update Successful...'

If is help you easy.

How to Show Header of GridView when Empty Data in C#

In using gridview it always show data when in table have data.
if in table not have data when you use it, not show anything in
gridview. but we can show header by nothing data in table.
If you want to know and want to use it please see code and
practice it as below:

/// Show grid even if datasource is empty

protected void EmptyGridFix(GridView grdView)
{
// normally executes after a grid load method

if (grdView.Rows.Count == 0 &&
grdView.DataSource != null)
{
DataTable dt = null;

// need to clone sources otherwise it will be indirectly adding to

// the original source


if (grdView.DataSource is DataSet)
{
dt = ((DataSet)grdView.DataSource).Tables[0].Clone();
}
else if (grdView.DataSource is DataTable)
{
dt = ((DataTable)grdView.DataSource).Clone();
}

if (dt == null)
{
return;
}

dt.Rows.Add(dt.NewRow()); // add empty row

grdView.DataSource = dt;
grdView.DataBind();

// hide row

grdView.Rows[0].Visible = false;
grdView.Rows[0].Controls.Clear();
}

// normally executes at all postbacks

if (grdView.Rows.Count == 1 &&
grdView.DataSource == null)
{
bool bIsGridEmpty = true;

// check first row that all cells empty

for (int i = 0; i < grdView.Rows[0].Cells.Count; i++)
{
if (grdView.Rows[0].Cells[i].Text != string.Empty)
{
bIsGridEmpty = false;
}
}
// hide row

if (bIsGridEmpty)
{
grdView.Rows[0].Visible = false;
grdView.Rows[0].Controls.Clear();
}
}
}


/// This code below for select data form table. write it in page load in page

protected void LoadGrid()
{
DataSet dsMyDataSet = new Dataset();
SqlDataAdapter Dadapter=new SqlDataAdapter _
("Select * From TableName",Connection);
Dadapter.Fill(dsMyDataSet);


// obtain dataset/datatable from DAL/BAL


grdYourGrid.DataSource = dsMyDataSet.Table[0];
grdYourGrid.DataBind();

this.EmptyGridFix(grdYourGrid);
}

How to Store Procedure For Add Data to Table

Using Store Procedure for add data to table is very important
and all developer like use it. because it provide fast and
good process when you add data to table. this is a example
and code for Add data to table.


USE [SecDB]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[tbl_Group_AddData]
@ID int,
@Name varchar(50),
@Sex int,
@SMS varchar(100) Output
As
If Exists(Select * From tbl_Name Where ID=@ID)
Begin
Set @SMS='Data exist already. Please Change!'
End
Else
Begin
Insert Into tbl_Group
(
ID,
Name,
Sex
)

Values
(
@ID,
@Name,
@Sex
)
Set @SMS='Insert data successful'
End

If can show message when insert successful and
when have data already.

How to Get Data From Excel Show on Form in VB.Net

If you want to to get data from excel show in form you can
do it by use code below.
1. You must have excel file that have data


2. Open Visual Basic and Design form as below

3. Write code below

Imports System.Data

Public Class ComboBox

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

Try

Dim MyConnection As System.Data.OleDb.OleDbConnection

Dim DtSet As System.Data.DataSet

Dim MyCommand As System.Data.OleDb.OleDbDataAdapter

MyConnection = New System.Data.OleDb.OleDbConnection _

("provider=Microsoft.Jet.OLEDB.4.0; “ _

“ Data Source='E:\Computer Magazine\ReadDataFromExcel\ _

ReadDataFromExcel\Employee.xlsx'; “ Extended Properties=Excel 8.0;")

MyConnection.Open()

MyCommand = New System.Data.OleDb.OleDbDataAdapter _

("Select * From [Sheet1$]", MyConnection)

MyCommand.TableMappings.Add("Table", "TestTable")

DtSet = New System.Data.DataSet

MyCommand.Fill(DtSet)

DataGridView1.DataSource = DtSet.Tables(0)

MyConnection.Close()

Catch ex As Exception

MsgBox(ex.ToString)

End Try

End Sub

End Class

4. Show result