FromLoad....
Dim cmdr As New SqlCommand("SELECT * FROM tb_name", con)
Dim rd As sqlDataReader
rd = cmdr.ExecuteReader
While rd.Read
textbox....text=rd("tabel").tostring
textbox....text=rd("tabel").tostring
textbox....text=rd("tabel").tostring
textbox....text=rd("tabel").tostring
textbox....text=rd("tabel").tostring
textbox....text=rd("tabel").tostring
end While
rd.close
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim ds As New DataSet
Dim sql As String = "Select * FROM TB_your"
Dim ap As SqlDataAdapter = New SqlDataAdapter(sql, clc_connectstring)
ap.Fill(ds)
txt_box1.text = ds.table(0).rows(0).item("ค่าส่วนกลาง").tostring
txt_box2.text = ds.table(0).rows(0).item("ค่าที่จอดรถ").tostring
txt_box3.text = ds.table(0).rows(0).item("ค่าที่ล้างแอร์").tostring
txt_box4.text = ds.table(0).rows(0).item("ค่าปรับ").tostring
txt_box5.text = ds.table(0).rows(0).item("ค่าน้ำ").tostring
txt_box6.text = ds.table(0).rows(0).item("ค่าไฟ").tostring
End Sub
Load balance : Server 03
