bbimis
asked on
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:
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..
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>
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!
ASKER
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
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]
error1.PNG
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:
Please note the double double-quotes inside the string value.
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"
Please note the double double-quotes inside the string value.
ASKER
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Aww OK. Thanks will try.
ASKER
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.
I'm sure I will have more questions along the way. good to know I have help out there.
Open in new window