Windows Hosting Database Connection
<add name="strConn" connectionString="Data Source=localhost;Initial Catalog=DBNAME;Integrated Security=false;User ID=DBUSERNAME;Password=DBPASSWORD" />
In some instances, the "Data Source" will need to have the Instance Name after it(\sqlexpress), such as this:
<add name="strConn" connectionString="Data Source=localhost\sqlexpress;Initial Catalog=DBNAME;Integrated Security=false;User ID=DBUSERNAME;Password=DBPASSWORD" />
DBNAME is what you specified as your database name in the control panel
DBUSERNAME is the username you created to connect to the database (and was associated with the database in the control panel)
DBPASSWORD is the password you associated with the username above
An example script:
<%@ Import Namespace="System.Data.SqlClient" %>
Dim conn As SqlConnection
Dim sqlQuery As SqlCommand
Dim dtrTbl As SqlDataReader
conn = New SqlConnection( "Server=localhost\sqlexpress;uid=USERNAME;pwd=PASSWORD;database=DBID" )
sqlQuery = New SqlCommand( "Select COLLUMN_NAME From TABLE_NAME", condDBID)
dtrTbl = sqlQuery.ExecuteReader()
Response.Write(dtrTbl( "COLUMN_NAME" ) )
Was this answer helpful?
This tutorial is going to help you become more familiar with databases and phpMyAdmin. We are...
The purpose of this tutorial is to teach you how to rename database tables with phpMyAdmin. We...
This tutorial is to teach you about specific operations in phpMyAdmin. We are going to learn how...
This tutorial is going to teach you how to create a table in a database with phpMyAdmin. We are...
This tutorial is to teach you how to run SQL queries on a database with phpMyAdmin. We will...