1.
sql =
"SELECT dbo.BCAP.Code, dbo.BCAP.Name1 FROM BCAP LEFT OUTER JOIN dbo.BCAR ON dbo.BCAP.Code = dbo.BCAR.Code"
2.
Dim
DT
As
New
DataTable
3.
DT =
New
ClassConnectDBBC().SelectDB(sql)
4.
If
DT.Rows.Count > 0
Then
5.
GridView1.DataSource = DT
6.
GridView1.DataBind()
7.
End
If