Solved

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

Posted on 2015-02-21
7
135 Views
Last Modified: 2015-02-22
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

0
Comment
Question by:bbimis
  • 4
  • 3
7 Comments
 
LVL 1

Expert Comment

by:BullfrogSoftware
ID: 40623794
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
 

Author Comment

by:bbimis
ID: 40623845
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
 
LVL 1

Expert Comment

by:BullfrogSoftware
ID: 40624276
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
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 

Author Comment

by:bbimis
ID: 40624321
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
 
LVL 1

Accepted Solution

by:
BullfrogSoftware earned 500 total points
ID: 40624326
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
 

Author Comment

by:bbimis
ID: 40624327
Aww OK. Thanks will try.
0
 

Author Closing Comment

by:bbimis
ID: 40624346
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

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

"In order to have an organized way for empathy mapping, we rely on a psychological model and trying to model it in a simple way, so we will split the board to three section for each persona and a scenario and try to see what those personas would Do,…
Boost your ability to deliver ambitious and competitive web apps by choosing the right JavaScript framework to best suit your project’s needs.
This tutorial demonstrates how to identify and create boundary or building outlines in Google Maps. In this example, I outline the boundaries of an enclosed skatepark within a community park.  Login to your Google Account, then  Google for "Google M…
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

706 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now