SELECT Products.Pro_ID, Products.[จำนวนในคลัง], Category.Category_Name
FROM Category INNER JOIN (Brand INNER JOIN Products ON Brand.Bran_ID = Products.Bran_ID) ON Category.Category_ID = Products.Category_ID
WHERE (((Brand.Bran_Name) Like "E*"))
ORDER BY Category.Category_ID;
Public Class Form1
'บันทึก database
Private Sub Sett_Post_PostCodeBindingNavigatorSaveItem_Click(sender As Object, e As EventArgs) Handles Sett_Post_PostCodeBindingNavigatorSaveItem.Click
Me.Validate()
Me.Sett_Post_PostCodeBindingSource.EndEdit()
Me.TableAdapterManager.UpdateAll(Me.PostCodeDataSet)
End Sub
Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the 'PostCodeDataSet.Sett_Post_PostCode' table. You can move, or remove it, as needed.
' Load Database
Me.Sett_Post_PostCodeTableAdapter.Fill(Me.PostCodeDataSet.Sett_Post_PostCode)
End Sub
End Class
Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
DataTable1BindingSource.Filter = "PostCode = " & PostCodeTextBox.Text
End Sub