MS SQL

MS SQL RSS

web.config(asp.net) vs app.config(vb.net)

Please support our MS SQL advertiser: Intel Parallel Studio Home

•

Join Date: Aug 2008

Posts: 1

Reputation: darlo23288 is an unknown quantity at this point

Solved Threads: 0

darlo23288 darlo23288 is offline

Offline

Newbie Poster

web.config(asp.net) vs app.config(vb.net)

Aug 20th, 2008

Hi, i juz wanted to know how to write this following codings in app.config.

In ASP.Net in web.config:

 Help with Code Tags 
 MS SQL Syntax (Toggle Plain Text) 
<configuration>
          <appSettings>
                <add KEY = "stu" value = "database = Gred; trusted_connection = yes; server = (local)">
          </appSettings>
     </configuration>
<configuration>
          <appSettings>
                <add key = "stu" value = "database = Gred; trusted_connection = yes; server = (local)">
          </appSettings>
     </configuration>

N in codings part:

 Help with Code Tags 
 MS SQL Syntax (Toggle Plain Text) 
Imports System.DATA.SqlConnection
Dim con AS New SqlConnection (ConfigurationSetting.AppSettings("stu"))
Imports System.Data.SqlConnection
Dim con As New SqlConnection (ConfigurationSetting.AppSettings("stu"))

Now how to do the same thing in VB.Net(app.Settings)

I tried app.config:

 Help with Code Tags 
 MS SQL Syntax (Toggle Plain Text) 
<configuration>
     <appSettings>
          <add KEY = "stu.ConnectionString" value = "datasource = Gred; initial catalog = Apps; Integrated Security = SSPI; packet size = 4096"/>
     </appSettings>
</configuration>
<configuration>
     <appSettings>
          <add key = "stu.ConnectionString" value = "datasource = Gred; initial catalog = Apps; Integrated Security = SSPI; packet size = 4096"/>
     </appSettings>
</configuration>

N in codings part:

 Help with Code Tags 
 MS SQL Syntax (Toggle Plain Text) 
Imports System.DATA.SqlClient
Me.stu.ConnectionString = CType (System.Configuration.ConfigurationSettings.AppSettings.GetValues("stu.ConnectionString"))
Imports System.Data.SqlClient
Me.stu.ConnectionString = CType (System.Configuration.ConfigurationSettings.AppSettings.GetValues("stu.ConnectionString"))

ASP.Net is not a prob but how to do the same thing in vb.net. The above codes was taken in net but doesnt work. Help me please... n plz do xplain d codes 2...