OKay I want to read the database into some text boxes, each row going into a different text box, Can' t figure out how to do this for the life of me, Here's some t hing that I found on google but am having no luck what so ever, beeen stuck on it for 3 hours now, any Input appreciated, thanks, this is what I have so far, but it doesn't work, don't know what's wrong
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim conn As New SqlConnection(ConfigurationSettings.AppSettings("strDBConn"))
Dim dsData As DataSet
Dim dvPairView As New DataView
Dim dvPairsView As New DataView
dsData = CType(Session("DataSet"), DataSet)
With dvPairView
.Table = dsData.Tables("pairs")
End With
txtorderkey.Text = dvPairView(0).Item("orderkey").ToString()
txtbuilding.Text = dvPairView(0).Item("building").ToString()
txtroom.Text = dvPairView(0).Item("room").ToString()
txtpanel.Text = dvPairView(0).Item("panel").ToString()
txtprefix.Text = dvPairView(0).Item("prefix").ToString()
txtextension.Text = dvPairView(0).Item("ext").ToString()
txtcablepair.Text = dvPairView(0).Item("cablepair").ToString()
txtvgname.Text = dvPairView(0).Item("vgname").ToString()
txtport.Text = dvPairView(0).Item("port").ToString()
txtdescription.Text = dvPairView(0).Item("descr").ToString()
txtlocation.Text = dvPairView(0).Item("location").ToString()
txtjackdesi.Text = dvPairView(0).Item("jackdesi").ToString()
txtnotes.Text = dvPairView(0).Item("notes").ToString()
txtupdated.Text = dvPairView(0).Item("updated").ToString()
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim conn As New SqlConnection(ConfigurationSettings.AppSettings("strDBConn"))
Dim dsData As DataSet
Dim dvPairView As New DataView
Dim dvPairsView As New DataView
dsData = CType(Session("DataSet"), DataSet)
With dvPairView
.Table = dsData.Tables("pairs")
End With
txtorderkey.Text = dvPairView(0).Item("orderkey").ToString()
txtbuilding.Text = dvPairView(0).Item("building").ToString()
txtroom.Text = dvPairView(0).Item("room").ToString()
txtpanel.Text = dvPairView(0).Item("panel").ToString()
txtprefix.Text = dvPairView(0).Item("prefix").ToString()
txtextension.Text = dvPairView(0).Item("ext").ToString()
txtcablepair.Text = dvPairView(0).Item("cablepair").ToString()
txtvgname.Text = dvPairView(0).Item("vgname").ToString()
txtport.Text = dvPairView(0).Item("port").ToString()
txtdescription.Text = dvPairView(0).Item("descr").ToString()
txtlocation.Text = dvPairView(0).Item("location").ToString()
txtjackdesi.Text = dvPairView(0).Item("jackdesi").ToString()
txtnotes.Text = dvPairView(0).Item("notes").ToString()
txtupdated.Text = dvPairView(0).Item("updated").ToString()