confused on how to use data with labels in aspx via vb

it has been a good while since I worked with visual studios for web. Can someone help me with the following please?

I have a main page which we will call main.aspx

I have some labels that I want to dynamically change based on data in a simple sql database.

mainly a persons name, date, and link to more info

I'm at a complete lost:
I have made the database in sql express on the local machine and populated the table called table. the database is called database1

I added to the web.config file the following:
<?xml version="1.0" encoding="utf-8"?>
<!--
  For more information on how to configure your ASP.NET application, please visit
  http://go.microsoft.com/fwlink/?LinkId=169433
  -->
<configuration>
  <system.web>
    <compilation debug="true" strict="false" explicit="true" targetFramework="4.5" />
    <httpRuntime targetFramework="4.5" />
  </system.web>
  <connectionStrings>
    <add name="ApplicationServices"
     connectionString="data source=.\SQLEXPRESS;Integrated
     Security=SSPI;AttachDBFilename=|DataDirectory|\database1.mdf;User Instance=true"
     providerName="System.Data.SqlClient"/>
  </connectionStrings>
    
</configuration>

Open in new window


then in the main.aspx.vb
i'm lost as to how to access the data (bind it) to the control

I have something like this so far but i'm certain it is not right.  Please help..
<?xml version="1.0" encoding="utf-8"?>
<!--
  For more information on how to configure your ASP.NET application, please visit
  http://go.microsoft.com/fwlink/?LinkId=169433
  -->
<configuration>
  <system.web>
    <compilation debug="true" strict="false" explicit="true" targetFramework="4.5" />
    <httpRuntime targetFramework="4.5" />
  </system.web>
  <connectionStrings>
    <add name="ApplicationServices"
     connectionString="data source=.\SQLEXPRESS;Integrated
     Security=SSPI;AttachDBFilename=|DataDirectory|\database1.mdf;User Instance=true"
     providerName="System.Data.SqlClient"/>
  </connectionStrings>
    
</configuration>

an example would be wonderful. thanks!

Open in new window

bbimisAsked:
Who is Participating?
 
BullfrogSoftwareConnect With a Mentor Commented:
Ok, if you want to use the web.config, go back to the original code I sent and replace TESTConnectionString with ApplicationServices (that is what you have the connection named in your web.config)
0
 
BullfrogSoftwareCommented:
Imports System.Data.SqlClient

Partial Class main
    Inherits System.Web.UI.Page

    Protected Sub Page_Load(sender As Object, e As EventArgs) Handles Me.Load

        Dim ConnectionString As String = System.Web.Configuration.WebConfigurationManager.ConnectionStrings("TESTConnectionString").ToString()
        Dim Id As String = "1"

        Dim MyConn As New System.Data.SqlClient.SqlConnection(ConnectionString)
        Dim MyComm As New System.Data.SqlClient.SqlCommand("SELECT * FROM [dbo].[Table] WHERE id = " + Id, MyConn)

        MyConn.Open()
        Dim DataReader As System.Data.SqlClient.SqlDataReader = MyComm.ExecuteReader()

        While (DataReader.Read())

            Label1.Text = DataReader("name")
            Label2.Text = DataReader("date")
            Label3.Text = DataReader("link")

        End While

        DataReader.Close()
        MyConn.Close()


    End Sub
End Class

Open in new window

0
 
bbimisAuthor Commented:
Okay trying to follow you but I get the following error as shown in picture.
here is the code I'm using in the vb part
Imports System.Data.SqlClient

Partial Class main
    Inherits System.Web.UI.Page

    Protected Sub Page_Load(sender As Object, e As EventArgs) Handles Me.Load

        Dim ConnectionString As String = System.Web.Configuration.WebConfigurationManager.ConnectionStrings("Data Source=(LocalDB)\v11.0;AttachDbFilename="C:\Users\tls\Documents\Visual Studio 2013\Projects\WebApplication2\WebApplication2\App_Data\Database1.mdf";Integrated Security=True").ToString()
        Dim Id As String = "1"

        Dim MyConn As New System.Data.SqlClient.SqlConnection(ConnectionString)
        Dim MyComm As New System.Data.SqlClient.SqlCommand("SELECT * FROM [dbo].[Table] WHERE id = " + Id, MyConn)

        MyConn.Open()
        Dim DataReader As System.Data.SqlClient.SqlDataReader = MyComm.ExecuteReader()

        While (DataReader.Read())

            Label1.Text = DataReader("date")
            

        End While

        DataReader.Close()
        MyConn.Close()


    End Sub
End Class[embed=file 899666]

Open in new window

error1.PNG
0
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
BullfrogSoftwareCommented:
If you are going to specify your own connection string, instead of using the web.config, then the connection string line needs to be like this:

Dim ConnectionString As String = "Data Source=(LocalDB)\v11.0;AttachDbFilename=""C:\Users\tls\Documents\Visual Studio 2013\Projects\WebApplication2\WebApplication2\App_Data\Database1.mdf"";Integrated Security=True"

Open in new window


Please note the double double-quotes inside the string value.
0
 
bbimisAuthor Commented:
So in the Web.config would I add that whole string to the connection string.  I guess that's where I'm having more trouble.  Of what should actually be in the Web.config.  Cause I'd like to read from there.
0
 
bbimisAuthor Commented:
Aww OK. Thanks will try.
0
 
bbimisAuthor Commented:
thank you so much that is what I needed!

I'm sure I will have more questions along the way. good to know I have help out there.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.