Okay I set up a the SQL connection SQL Adapter, and DataSet, But I can't get anything from my data to show up in my ASP page, This is what I have trying to get data to show up in a text field or at least label but just gives me erros, Can anyone, Help , T his is what IH ave in the page load entry, but nothing is showing up, seriously need some help here, All i want is data to show up, and nothing happens!!
Dim str As String
Dim conn As New SqlConnection(ConfigurationSettings.AppSettings("strDBConn"))
Try
conn.Open()
txtorderkey.Text = DataBinder.Eval(Dspairs1, "Tables[pairs].DefaultView.[0].orderkey", "{0}")
lblorderkey2.DataBindings.Add("Test", Dspairs1.Tables(), "orderkey")
Catch ex As Exception
End Try
conn.Close()
Dim str As String
Dim conn As New SqlConnection(ConfigurationSettings.AppSettings("strDBConn"))
Try
conn.Open()
txtorderkey.Text = DataBinder.Eval(Dspairs1, "Tables[pairs].DefaultView.[0].orderkey", "{0}")
lblorderkey2.DataBindings.Add("Test", Dspairs1.Tables(), "orderkey")
Catch ex As Exception
End Try
conn.Close()
