public syncController(int UserId) { FranchiseeID = _users.getFranchiseeId(UserId.ToString()); String connString = Properties.Settings.Default.FAFOS; SqlConnection con = new SqlConnection(connString); con.Open(); SqlCommand Franchisee_command = new SqlCommand("SELECT franchisee_id, company_name FROM Franchisee WHERE franchisee_id = " + FranchiseeID, con); SqlDataReader reader = Franchisee_command.ExecuteReader(); reader.Read(); String[] Franchisee_data = new String[2] { reader[0].ToString(), reader[1].ToString() }; XML = new InspectionData(Franchisee_data); }