توی web.config مثلا کد زیر رو قرار بدید :
<connectionStrings>
<add name="ConnectionString" connectionString="server=localhost;database=BEE;ui d=sa;pwd=123456" providerName="System.Data.SqlClient" />
<add name="ConnectionString1" connectionString="server=localhost;database=BEE;ui d=sa;pwd=123456" providerName="System.Data.SqlClient" />
<add name="ConnectionString2" connectionString="server=localhost;database=BEE;ui d=sa;pwd=123456" providerName="System.Data.SqlClient" />
</connectionStrings>
و توی پروژه تون اینطوری کانکشن رو صدا بزنید :
Dim Conn As New SqlConnection(ConfigurationManager.ConnectionStrin gs("ConnectionString").ConnectionString)
Conn.Open()
Dim CmdAdmin As New SqlCommand("select Username From admins", Conn)
Dim RAdmin As SqlDataReader = CmdAdmin.ExecuteReader
While RAdmin.Read
back = "OKay"
End While
CmdAdmin.Dispose()
RAdmin.Close()
Conn.Close()
Conn.Dispose()