Solved

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

Posted on 2015-02-21
7
145 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 to Create Failover DNS Record Sets in Route 53

Route 53 has the ability to easily configure DNS record sets specifically for failover scenarios. These failover record sets can be configured to failover to full-blown deployments in other regions or to a static HTML page that informs your customers of the issue.

 

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

[Webinar] How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Because your company can’t afford for you to make SEO mistakes, you’ll want to ensure you’re taking the right steps each and every time you post a new piece of content. This list of optimization do’s and don’ts can help you become an SEO wizard.
Dramatic changes are revolutionizing how we build and use technology. Every company is automating, digitizing, and modernizing operations. We need a better, more connected way to work together as teams so we can harness the insights from our system…
The viewer will learn how to count occurrences of each item in an array.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

630 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