vb 2008 อยากทราบโค้ดที่ติดต่อฐานข้อมูล my sQL ให้ขึ้นโชว์บน textbox
Private Sub house_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim strConn As String
strConn = "Server=localhost;User Id=root; Password=0123456789;"
Dim strSQL As String
strSQL = "SELECT * FROM house"
Dim unitQuery As String = "select * from house"
Dim sqlhouse As String = ""
sqlhouse = "SELECT * FROM house"
Dim dt As New DataTable
strSQL = "SELECT * FROM house WHERE HOUSEID = '"
If dt.Rows.Count > 0 Then
Me.txtPARCEL_CODE.Text = dt.Rows(0)("PARCEL_CODE")