All Free <Script>

19 Febbraio 2015

Per inserire una stringa di connessione al database bisogna aprire il file web.config quindi nella sezione <AppSettings>:

<?xml version="1.0" ?>
<configuration>
        <system.web>
           <compilation debug="true"/>
        </system.web>
 <appSettings>
  <!-- stringa di conn al db -->
  <add key="connStr" value="Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=db_magazzino; Data Source=robi" />
	</appSettings>
</configuration>

Possiamo poi leggere i valori nelle nostre webform così in c#:

private void openDB(object sender, EventArgs e) 
{
  string ConnectionString = ConfigurationSettings.AppSettings["connStr"];
  OleDbConnection myconnection = new OleDbConnection(ConnectionString);
  myconnection .Open(); 
}

in vb.net:

private sub openDB (sender As Object, e As EventArgs)
    Dim ConnectionString As String = ConfigurationSettings.AppSettings("connStr")
    Dim myconnection As New OleDbConnection(ConnectionString)
    myconnection .Open() 
End sub