>>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; >>} >>