>public SqlConnection GetConnection() >{ > > // Define variables > bool bTrustedConnection = true; > string sDatabase = "test"; > string sPassword = ""; > string sServer = "PC108\\SQLEXPRESS"; > string sUserName = ""; > > // Define variables > string sConnString = ""; > > // If the user is trusted... > if (bTrustedConnection) > { > // Create the connection string for a trusted connection > sConnString = "Server=" + sServer + ";Database= " + sDatabase + ";Trusted_Connection=yes"; > } > else > { > // Create the connection string for a logged in user > sConnString = "Server=" + sServer + ";Database= " + sDatabase + ";Uid=" + sUserName + ";Pwd=" + sPassword; > } > > // Create a connection object, passing the connection string > SqlConnection oConnection = new SqlConnection(sConnString); > > try > { > // Attempt to open the connection > oConnection.Open(); > } > catch (Exception oException) > { > // Handle exception here > } > > return oConnection; >} >