public DataService() { RoomGuideDataStructure.DataService dataServiceValue = new RoomGuideDataStructure.DataService(); dataServiceValue.serverName = GetConfigValue("ServerName"); dataServiceValue.userName = GetConfigValue("UserName"); dataServiceValue.databaseName = GetConfigValue("Database"); dataServiceValue.password = GetConfigValue("Password"); this.sqlConnection = this.GetConnection(dataServiceValue); }
private SqlConnection GetConnection(RoomGuideDataStructure.DataService dataService) { string connectionString = string.Empty; try { connectionString = "Data Source=" + dataService.serverName + "; Initial Catalog=" + dataService.databaseName + ";User ID=" + dataService.userName + ";Password="******";"; return(new SqlConnection(connectionString)); } catch (Exception connectionException) { return(new SqlConnection(connectionString)); throw connectionException; } }
public DataService(RoomGuideDataStructure.DataService dataService) { this.sqlConnection = this.GetConnection(dataService); }